PREVIEW / futures_1hour / 2020-03-08

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-03-08.parquet
  size:    19 KB
  rows:    384

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2020-03-08 18:00:00	ES	Futures	3160.8	3160.8	3065.2	3078.7	120994.0
2020-03-08 19:00:00	ES	Futures	3078.7	3089.3	3055.7	3059.5	63302.0
2020-03-08 20:00:00	ES	Futures	3059.5	3077.4	3055.7	3072.5	39960.0
2020-03-08 21:00:00	ES	Futures	3072.5	3077.4	3055.7	3055.7	38345.0
2020-03-08 22:00:00	ES	Futures	3055.7	3055.7	3055.7	3055.7	2240.0
2020-03-08 23:00:00	ES	Futures	3055.7	3066.0	3055.7	3055.7	25131.0
2020-03-08 18:00:00	NQ	Futures	9680.36	9687.3	9398.13	9453.36	27868.0
2020-03-08 19:00:00	NQ	Futures	9451.63	9484.3	9371.53	9386.85	19169.0
2020-03-08 20:00:00	NQ	Futures	9385.7	9438.04	9370.37	9413.75	16914.0
2020-03-08 21:00:00	NQ	Futures	9415.19	9429.65	9361.41	9361.41	11663.0
2020-03-08 22:00:00	NQ	Futures	9361.41	9361.7	9361.41	9361.41	375.0
2020-03-08 23:00:00	NQ	Futures	9361.41	9401.02	9361.41	9361.41	7239.0
2020-03-08 18:00:00	YM	Futures	27606.2	27606.2	26847.3	26995.4	12533.0
2020-03-08 19:00:00	YM	Futures	26993.2	27075.9	26828.8	26863.6	11887.0
2020-03-08 20:00:00	YM	Futures	26858.2	26986.7	26840.8	26934.4	7553.0
2020-03-08 21:00:00	YM	Futures	26934.4	26981.2	26783.1	26786.3	7923.0
2020-03-08 22:00:00	YM	Futures	26786.3	26792.9	26711.2	26711.2	2521.0
2020-03-08 23:00:00	YM	Futures	26711.2	26890.8	26711.2	26770.0	6575.0
2020-03-08 18:00:00	CL	Futures	28.98	29.4	26.45	28.75	70662.0
2020-03-08 19:00:00	CL	Futures	28.74	29.62	28.49	28.67	40140.0
2020-03-08 20:00:00	CL	Futures	28.67	29.25	28.22	28.96	29719.0
2020-03-08 21:00:00	CL	Futures	28.97	29.09	26.62	27.18	61684.0
2020-03-08 22:00:00	CL	Futures	27.19	27.32	26.73	26.88	27612.0
2020-03-08 23:00:00	CL	Futures	26.87	26.97	24.6	25.09	68746.0
2020-03-08 18:00:00	GC	Futures	2114.2	2126.5	2098.9	2122.2	23263.0
2020-03-08 19:00:00	GC	Futures	2122.0	2128.8	2114.3	2124.9	14415.0
2020-03-08 20:00:00	GC	Futures	2124.9	2128.0	2112.2	2124.4	18907.0
2020-03-08 21:00:00	GC	Futures	2124.9	2128.4	2118.4	2125.8	22594.0
2020-03-08 22:00:00	GC	Futures	2125.5	2126.1	2113.3	2117.9	16747.0
2020-03-08 23:00:00	GC	Futures	2117.8	2118.4	2092.2	2100.9	26863.0
2020-03-08 18:00:00	ZN	Futures	137.695498	138.658621	137.66443	138.503279	85127.0
2020-03-08 19:00:00	ZN	Futures	138.503279	138.891635	138.347936	138.767361	37744.0
2020-03-08 20:00:00	ZN	Futures	138.767361	138.860566	138.410073	138.518813	65331.0
2020-03-08 21:00:00	ZN	Futures	138.518813	139.109114	138.425608	139.078046	55257.0
2020-03-08 22:00:00	ZN	Futures	139.109114	139.124648	138.876101	138.891635	34638.0
2020-03-08 23:00:00	ZN	Futures	138.891635	138.907169	138.549881	138.705224	41158.0

> showing 36 of 384 rows — these rows as CSV

> unlock the full archive -- $79 one-time