PREVIEW / futures_1hour / 2021-05-31

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-05-31.parquet
  size:    44 KB
  rows:    1,332

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
2021-05-31 00:00:00	ES	Futures	4727.59	4728.15	4726.19	4726.47	1410.0
2021-05-31 01:00:00	ES	Futures	4726.47	4727.59	4725.06	4726.47	3166.0
2021-05-31 02:00:00	ES	Futures	4726.47	4728.15	4725.9	4727.59	3645.0
2021-05-31 03:00:00	ES	Futures	4727.59	4730.68	4727.03	4727.87	7273.0
2021-05-31 04:00:00	ES	Futures	4727.87	4728.43	4721.97	4723.09	5740.0
2021-05-31 05:00:00	ES	Futures	4723.38	4725.62	4718.88	4721.97	5661.0
2021-05-31 06:00:00	ES	Futures	4721.97	4723.38	4717.76	4722.81	5995.0
2021-05-31 07:00:00	ES	Futures	4722.81	4723.38	4721.97	4722.25	2346.0
2021-05-31 08:00:00	ES	Futures	4722.25	4722.25	4719.44	4720.28	5994.0
2021-05-31 09:00:00	ES	Futures	4720.0	4720.28	4711.57	4714.1	15372.0
2021-05-31 10:00:00	ES	Futures	4714.38	4715.23	4712.98	4713.26	6197.0
2021-05-31 11:00:00	ES	Futures	4713.26	4714.1	4710.73	4712.14	7079.0
2021-05-31 12:00:00	ES	Futures	4711.86	4714.1	4709.05	4710.45	7812.0
2021-05-31 18:00:00	ES	Futures	4711.29	4719.72	4711.01	4719.16	6145.0
2021-05-31 19:00:00	ES	Futures	4719.16	4721.69	4717.19	4721.41	5186.0
2021-05-31 20:00:00	ES	Futures	4721.41	4724.78	4718.04	4723.09	9610.0
2021-05-31 21:00:00	ES	Futures	4722.81	4724.78	4718.04	4721.41	9525.0
2021-05-31 22:00:00	ES	Futures	4721.69	4723.09	4717.47	4719.16	5203.0
2021-05-31 23:00:00	ES	Futures	4718.88	4724.22	4718.6	4722.25	3857.0
2021-05-31 00:00:00	NQ	Futures	15861.16	15863.47	15856.24	15858.26	572.0
2021-05-31 01:00:00	NQ	Futures	15858.26	15867.82	15856.81	15861.45	1183.0
2021-05-31 02:00:00	NQ	Futures	15861.74	15866.37	15856.24	15860.29	1052.0
2021-05-31 03:00:00	NQ	Futures	15860.29	15878.24	15853.05	15857.68	3388.0
2021-05-31 04:00:00	NQ	Futures	15856.81	15857.1	15830.47	15833.08	3466.0
2021-05-31 05:00:00	NQ	Futures	15833.94	15845.52	15818.31	15828.44	2540.0
2021-05-31 06:00:00	NQ	Futures	15828.73	15839.73	15814.55	15839.73	2158.0
2021-05-31 07:00:00	NQ	Futures	15839.73	15841.18	15827.29	15832.5	1633.0
2021-05-31 08:00:00	NQ	Futures	15832.5	15845.23	15822.08	15838.58	3603.0
2021-05-31 09:00:00	NQ	Futures	15838.58	15841.18	15825.55	15833.37	4586.0
2021-05-31 10:00:00	NQ	Futures	15832.79	15834.23	15819.76	15821.79	3560.0
2021-05-31 11:00:00	NQ	Futures	15821.79	15833.66	15820.34	15830.47	2674.0
2021-05-31 12:00:00	NQ	Futures	15830.47	15834.81	15808.18	15811.94	3251.0
2021-05-31 18:00:00	NQ	Futures	15818.6	15845.81	15812.23	15844.08	2948.0
2021-05-31 19:00:00	NQ	Futures	15844.08	15851.89	15838.29	15848.42	1539.0
2021-05-31 20:00:00	NQ	Futures	15848.13	15858.55	15834.81	15853.92	3823.0
2021-05-31 21:00:00	NQ	Futures	15854.21	15863.76	15831.92	15846.39	4045.0
2021-05-31 22:00:00	NQ	Futures	15846.97	15859.42	15834.52	15839.16	2788.0
2021-05-31 23:00:00	NQ	Futures	15840.02	15856.24	15837.13	15849.58	1921.0
2021-05-31 00:00:00	YM	Futures	38472.4	38478.0	38457.9	38460.1	326.0
2021-05-31 01:00:00	YM	Futures	38461.3	38470.2	38454.6	38462.4	591.0
2021-05-31 02:00:00	YM	Futures	38463.5	38483.5	38461.3	38476.9	684.0
2021-05-31 03:00:00	YM	Futures	38476.9	38491.3	38467.9	38483.5	1379.0
2021-05-31 04:00:00	YM	Futures	38482.4	38502.5	38460.1	38467.9	1324.0
2021-05-31 05:00:00	YM	Futures	38469.1	38484.7	38423.4	38450.1	1307.0
2021-05-31 06:00:00	YM	Futures	38447.9	38470.2	38426.7	38456.8	1041.0
2021-05-31 07:00:00	YM	Futures	38461.3	38471.3	38454.6	38457.9	387.0
2021-05-31 08:00:00	YM	Futures	38459.0	38460.1	38432.3	38434.5	795.0
2021-05-31 09:00:00	YM	Futures	38435.6	38436.8	38353.2	38378.8	2900.0
2021-05-31 10:00:00	YM	Futures	38378.8	38388.9	38349.9	38357.7	1463.0
2021-05-31 11:00:00	YM	Futures	38356.6	38358.8	38324.3	38346.5	1711.0

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

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