PREVIEW / futures_1hour / 2020-07-31

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-07-31.parquet
  size:    52 KB
  rows:    1,503

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-07-31 00:00:00	ES	Futures	3640.78	3641.06	3631.84	3634.35	12334.0
2020-07-31 01:00:00	ES	Futures	3634.63	3636.03	3625.42	3626.54	14349.0
2020-07-31 02:00:00	ES	Futures	3626.54	3643.01	3626.54	3639.1	19861.0
2020-07-31 03:00:00	ES	Futures	3639.1	3642.45	3632.12	3634.91	40886.0
2020-07-31 04:00:00	ES	Futures	3634.91	3645.24	3633.52	3639.38	26203.0
2020-07-31 05:00:00	ES	Futures	3639.66	3642.17	3632.68	3633.24	17807.0
2020-07-31 06:00:00	ES	Futures	3633.24	3636.87	3630.44	3633.24	15825.0
2020-07-31 07:00:00	ES	Futures	3633.24	3641.06	3632.12	3640.22	17373.0
2020-07-31 08:00:00	ES	Futures	3640.22	3641.89	3635.47	3635.75	22292.0
2020-07-31 09:00:00	ES	Futures	3635.75	3641.89	3619.55	3626.26	184797.0
2020-07-31 10:00:00	ES	Futures	3626.54	3627.09	3600.29	3610.06	293428.0
2020-07-31 11:00:00	ES	Futures	3610.06	3622.63	3606.71	3609.78	284975.0
2020-07-31 12:00:00	ES	Futures	3609.78	3610.9	3588.28	3592.19	345422.0
2020-07-31 13:00:00	ES	Futures	3592.19	3607.27	3590.51	3601.96	153520.0
2020-07-31 14:00:00	ES	Futures	3601.96	3617.32	3594.98	3616.48	186339.0
2020-07-31 15:00:00	ES	Futures	3616.48	3647.2	3614.53	3646.92	388204.0
2020-07-31 16:00:00	ES	Futures	3646.64	3652.78	3642.73	3651.95	101962.0
2020-07-31 00:00:00	NQ	Futures	12615.7	12618.59	12564.23	12577.53	5998.0
2020-07-31 01:00:00	NQ	Futures	12578.11	12591.12	12543.12	12557.58	7272.0
2020-07-31 02:00:00	NQ	Futures	12557.87	12630.74	12557.87	12624.38	8157.0
2020-07-31 03:00:00	NQ	Futures	12624.38	12635.66	12581.87	12591.41	10339.0
2020-07-31 04:00:00	NQ	Futures	12591.7	12628.43	12583.31	12613.97	6936.0
2020-07-31 05:00:00	NQ	Futures	12613.1	12632.76	12582.45	12584.18	6033.0
2020-07-31 06:00:00	NQ	Futures	12583.89	12607.03	12580.42	12592.57	3739.0
2020-07-31 07:00:00	NQ	Futures	12594.01	12628.72	12591.12	12625.53	6834.0
2020-07-31 08:00:00	NQ	Futures	12625.25	12646.93	12611.08	12612.81	13698.0
2020-07-31 09:00:00	NQ	Futures	12612.52	12618.88	12469.38	12521.43	88521.0
2020-07-31 10:00:00	NQ	Futures	12521.14	12523.74	12393.61	12469.67	99645.0
2020-07-31 11:00:00	NQ	Futures	12469.96	12527.5	12458.39	12476.61	68871.0
2020-07-31 12:00:00	NQ	Futures	12476.9	12484.42	12366.43	12387.54	70944.0
2020-07-31 13:00:00	NQ	Futures	12386.67	12459.26	12380.02	12430.92	51698.0
2020-07-31 14:00:00	NQ	Futures	12431.79	12500.03	12391.88	12492.51	46047.0
2020-07-31 15:00:00	NQ	Futures	12492.8	12606.16	12480.66	12605.58	75457.0
2020-07-31 16:00:00	NQ	Futures	12605.87	12632.48	12598.93	12624.67	14907.0
2020-07-31 00:00:00	YM	Futures	28958.9	28960.0	28882.9	28902.7	2632.0
2020-07-31 01:00:00	YM	Futures	28906.0	28914.8	28825.6	28832.2	2300.0
2020-07-31 02:00:00	YM	Futures	28832.2	28950.1	28832.2	28914.8	3812.0
2020-07-31 03:00:00	YM	Futures	28912.6	28980.9	28867.5	28925.8	6189.0
2020-07-31 04:00:00	YM	Futures	28923.6	29001.8	28914.8	28944.6	4044.0
2020-07-31 05:00:00	YM	Futures	28945.7	28956.7	28862.0	28868.6	4203.0
2020-07-31 06:00:00	YM	Futures	28869.7	28941.3	28859.8	28911.5	3721.0
2020-07-31 07:00:00	YM	Futures	28911.5	28968.8	28904.9	28958.9	3152.0
2020-07-31 08:00:00	YM	Futures	28957.8	28964.4	28904.9	28922.5	3826.0
2020-07-31 09:00:00	YM	Futures	28924.7	28957.8	28797.0	28836.7	23486.0
2020-07-31 10:00:00	YM	Futures	28836.7	28853.2	28637.3	28696.8	31176.0
2020-07-31 11:00:00	YM	Futures	28696.8	28788.2	28663.8	28680.3	25307.0
2020-07-31 12:00:00	YM	Futures	28679.2	28686.9	28525.0	28555.9	31708.0
2020-07-31 13:00:00	YM	Futures	28554.8	28667.1	28540.4	28636.2	17235.0
2020-07-31 14:00:00	YM	Futures	28635.1	28767.3	28602.1	28762.9	18001.0
2020-07-31 15:00:00	YM	Futures	28764.0	28997.4	28753.0	28988.6	32504.0

> showing 50 of 1,503 rows — these rows as CSV

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