Skip to main content
Schema: movement.price Table: ez_prices_hourly Type: View Hourly token prices with metadata. A convenience table providing easy access to hourly price data.

Columns

Column NameData TypeDescription
HOURTIMESTAMP_NTZThe hourly time bucket.
TOKEN_ADDRESSTEXTToken contract address.
SYMBOLTEXTAsset trading symbol.
BLOCKCHAINTEXTBlockchain network name.
DECIMALSNUMBERToken decimal places.
PRICEFLOATThe hourly price value.
IS_NATIVEBOOLEANWhether this is the native blockchain asset.
IS_IMPUTEDBOOLEANWhether the price was interpolated.
IS_DEPRECATEDBOOLEANWhether this asset is deprecated.
EZ_PRICES_HOURLY_IDTEXTUnique identifier for the row.
INSERTED_TIMESTAMPTIMESTAMP_NTZTimestamp when the record was inserted.
MODIFIED_TIMESTAMPTIMESTAMP_NTZTimestamp when the record was last modified.