Snowflake

Select datasets are available in Snowflake for seamless and scalable data warehousing, enabling efficient storage, retrieval, and analysis of diverse datasets in a cloud-native environment, complete with powerful SQL querying capabilities.

Market Data - Snowflake Datasets

Market TypeFeature TypeSnowflake Table Name
FuturesFunding RatesFUTURES_FUNDING_RATE
FuturesLiquidations Reference DataFUTURES_LIQUIDATION_INSTRUMENT
FuturesLiquidationsFUTURES_LIQUIDATION
FuturesOHLCV (hourly)FUTURES_OHLCV_HOURLY
FuturesOHLCV (daily)FUTURES_OHLCV_DAILY
FuturesOpen InterestFUTURES_OPEN_INTEREST
OptionsLiquidationsOPTIONS_LIQUIDATION
OptionsOHLCV (hourly)OPTIONS_OHLCV_HOURLY
OptionsOHLCV (daily)OPTIONS_OHLCV_DAILY
OptionsOpen InterestOPTIONS_OPEN_INTEREST
OptionsOrder Book EventsOPTIONS_ORDER_BOOK_EVENT
OptionsOrder Book SnapshotsOPTIONS_ORDER_BOOK_SNAPSHOT
OptionsTickersOPTIONS_TICKER
OptionsTradesOPTIONS_TRADE
SpotOHLCV (hourly)SPOT_OHLCV_HOURLY
SpotOHLCV (daily)SPOT_OHLCV_DAILY
SpotTradesSPOT_TRADE

CME Only - Snowflake Datasets

Market TypeFeature TypeSnowflake Table Name
FuturesOHLCV (hourly)CME_FUTURES_OHLCV_HOURLY
FuturesOHLCV (daily)CME_FUTURES_OHLCV_DAILY
FuturesOHLCVCME_FUTURES_OHLCV
FuturesOpen InterestCME_FUTURES_OPEN_INTEREST
FuturesTickersCME_FUTURES_TICKER
FuturesTradesCME_FUTURES_TRADE
OptionsOHLCV (hourly)CME_OPTIONS_OHLCV_HOURLY
OptionsOHLCV (daily)CME_OPTIONS_OHLCV_DAILY
OptionsOHLCVCME_OPTIONS_OHLCV
OptionsOpen InterestCME_OPTIONS_OPEN_INTEREST
OptionsTickersCME_OPTIONS_TICKER
OptionsTradesCME_OPTIONS_TRADE


FAQs

Why is delivery via Snowflake important?

  • Snowflake provides advantages in terms of query performance, data integration, scalability, security, ease of use, and data transformation. These benefits make it a valuable option for our customers who want to access and analyze historical data, even when alternative methods like REST API and Amazon S3 are available. Snowflake complements these methods by offering a comprehensive data warehousing solution for more advanced analytics and data management needs.

How does a customer get access to these datasets?

  • Customers will need to have their own Snowflake account in which we will share access. If you are interested in accessing data via Snowflake, please contact us or reach out to your Account Executive.

How do I download Snowflake sample files to see which fields are returned?

  • Amberdata can be found in Snowflake's Marketplace where all of our sample files are located and can be easily accessed.