Flipside Docs
Search…
⌃K
Welcome to Flipside!
Our Data
Data Table Documentation
Using Snowflake SQL
Writing Efficient Queries
Data Modeling Approach
Tags
Labels
Video Tutorials
Hex-to-Integer Function
Archive
Data Updates
Legacy Table Documentation
AAVE Tables
Algorand Tables
Arbitrum Tables
Astroport Tables
Avalanche Tables
Axelar Tables
BSC Tables
Compound Tables
Cosmos Tables
Crosschain Tables
Fact Hourly Prices
Dim Asset Metadata
Dim Dates
Dim Date Hours
Crosschain Address Labels
Crosschain Address Tags
Ethereum Tables
Ethereum Beacon Chain Tables
Ethereum Beta Tables
Ethereum Chainlink Tables
Ethereum Maker DAO Tables
Ethereum Sushi Tables
FLOW Tables
Gnosis Tables
NEAR Tables
Optimism Tables
Osmosis Tables
Polygon Tables
Polygon 2.0 Tables
Solana Tables
Terra Tables
Terraswap Tables
THORChain Tables
Uniswap V3 Tables
Algorand Tutorials
ShroomDK (SDK)
Getting Started
Example Code
Templates & Walkthroughs
Rate Limits
Community Showcase
Contribute to Our Data
Community Curation
Model Standards
Getting Started
PR Checklist
Data Shares
Snowflake Data Shares
Powered By
GitBook
Dim Date Hours
Table Schema
Hold rows for each hour from 2017 to current timestamp (UTC)
crosschain.dim_date_hours
Field
Type
Description
DATE_HOUR
timestamp
Specific hour of a given date
Previous
Dim Dates
Next
Crosschain Address Labels
Last modified
3mo ago
