PREVIEW / futures_1hour / 2021-04-05

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-04-05.parquet
  size:    51 KB
  rows:    1,512

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-04-05 00:00:00	ES	Futures	4526.42	4527.54	4525.29	4525.57	2749.0
2021-04-05 01:00:00	ES	Futures	4525.57	4526.42	4522.76	4523.33	3443.0
2021-04-05 02:00:00	ES	Futures	4523.33	4523.61	4519.11	4523.33	5384.0
2021-04-05 03:00:00	ES	Futures	4523.33	4525.01	4521.64	4524.45	2752.0
2021-04-05 04:00:00	ES	Futures	4524.73	4529.23	4523.61	4527.26	4500.0
2021-04-05 05:00:00	ES	Futures	4527.26	4531.75	4526.13	4530.63	4224.0
2021-04-05 06:00:00	ES	Futures	4530.35	4532.88	4528.66	4531.19	3758.0
2021-04-05 07:00:00	ES	Futures	4531.19	4533.72	4530.07	4531.47	8228.0
2021-04-05 08:00:00	ES	Futures	4531.47	4538.22	4530.35	4537.09	19398.0
2021-04-05 09:00:00	ES	Futures	4537.37	4551.7	4535.97	4550.86	170470.0
2021-04-05 10:00:00	ES	Futures	4551.14	4567.72	4547.21	4563.5	234937.0
2021-04-05 11:00:00	ES	Futures	4563.5	4573.34	4561.82	4569.97	101948.0
2021-04-05 12:00:00	ES	Futures	4569.97	4578.4	4569.4	4571.65	89106.0
2021-04-05 13:00:00	ES	Futures	4571.65	4574.46	4568.56	4574.18	91019.0
2021-04-05 14:00:00	ES	Futures	4573.9	4576.71	4568.56	4568.56	93447.0
2021-04-05 15:00:00	ES	Futures	4568.84	4576.71	4564.35	4570.81	273773.0
2021-04-05 16:00:00	ES	Futures	4571.09	4575.3	4568.56	4574.46	57676.0
2021-04-05 18:00:00	ES	Futures	4573.9	4579.24	4572.49	4577.83	6262.0
2021-04-05 19:00:00	ES	Futures	4577.83	4578.96	4575.02	4575.87	4000.0
2021-04-05 20:00:00	ES	Futures	4575.59	4576.15	4569.4	4570.81	10741.0
2021-04-05 21:00:00	ES	Futures	4570.81	4571.93	4564.35	4565.19	9116.0
2021-04-05 22:00:00	ES	Futures	4565.19	4566.31	4563.5	4565.75	7104.0
2021-04-05 23:00:00	ES	Futures	4566.03	4567.16	4559.57	4562.94	8925.0
2021-04-05 00:00:00	NQ	Futures	15432.13	15441.68	15425.18	15426.91	1880.0
2021-04-05 01:00:00	NQ	Futures	15427.2	15441.39	15427.2	15432.41	1830.0
2021-04-05 02:00:00	NQ	Futures	15433.28	15438.78	15415.04	15431.55	3314.0
2021-04-05 03:00:00	NQ	Futures	15430.39	15431.84	15414.18	15426.62	2633.0
2021-04-05 04:00:00	NQ	Futures	15426.05	15477.87	15426.05	15471.5	5804.0
2021-04-05 05:00:00	NQ	Futures	15471.5	15498.71	15460.21	15490.89	4202.0
2021-04-05 06:00:00	NQ	Futures	15491.47	15499.87	15469.47	15472.94	3757.0
2021-04-05 07:00:00	NQ	Futures	15472.94	15499.29	15472.36	15497.84	6213.0
2021-04-05 08:00:00	NQ	Futures	15498.42	15555.45	15479.31	15544.16	14110.0
2021-04-05 09:00:00	NQ	Futures	15545.03	15615.95	15527.66	15604.66	55448.0
2021-04-05 10:00:00	NQ	Futures	15604.95	15677.04	15582.95	15650.69	56037.0
2021-04-05 11:00:00	NQ	Futures	15650.98	15699.62	15640.56	15680.22	37267.0
2021-04-05 12:00:00	NQ	Futures	15679.93	15725.38	15679.64	15712.65	26260.0
2021-04-05 13:00:00	NQ	Futures	15713.8	15748.54	15710.33	15747.1	22896.0
2021-04-05 14:00:00	NQ	Futures	15747.1	15765.91	15739.57	15745.65	23701.0
2021-04-05 15:00:00	NQ	Futures	15745.65	15753.75	15706.86	15727.41	49869.0
2021-04-05 16:00:00	NQ	Futures	15727.99	15752.02	15718.44	15749.12	10876.0
2021-04-05 18:00:00	NQ	Futures	15752.89	15772.28	15742.17	15765.04	2990.0
2021-04-05 19:00:00	NQ	Futures	15765.04	15774.31	15761.28	15767.36	2265.0
2021-04-05 20:00:00	NQ	Futures	15767.07	15773.73	15746.52	15753.18	4434.0
2021-04-05 21:00:00	NQ	Futures	15752.89	15760.12	15721.04	15725.38	5175.0
2021-04-05 22:00:00	NQ	Futures	15725.09	15735.52	15719.01	15732.91	2817.0
2021-04-05 23:00:00	NQ	Futures	15734.07	15735.52	15710.33	15719.59	3274.0
2021-04-05 00:00:00	YM	Futures	37043.4	37051.2	37033.3	37035.6	851.0
2021-04-05 01:00:00	YM	Futures	37035.6	37040.0	37003.3	37005.5	1171.0
2021-04-05 02:00:00	YM	Futures	37006.6	37008.8	36969.9	37006.6	1421.0
2021-04-05 03:00:00	YM	Futures	37004.4	37030.0	36992.1	37028.9	987.0

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

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