PREVIEW / futures_1hour / 2021-03-25

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-03-25.parquet
  size:    63 KB
  rows:    1,932

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-03-25 00:00:00	ES	Futures	4371.04	4372.44	4367.67	4368.79	3031.0
2021-03-25 01:00:00	ES	Futures	4369.07	4376.94	4367.11	4367.39	9109.0
2021-03-25 02:00:00	ES	Futures	4367.39	4372.16	4366.26	4371.32	5838.0
2021-03-25 03:00:00	ES	Futures	4371.32	4373.85	4366.26	4366.83	10609.0
2021-03-25 04:00:00	ES	Futures	4366.83	4376.94	4360.92	4371.04	25575.0
2021-03-25 05:00:00	ES	Futures	4371.04	4371.32	4365.14	4369.92	14324.0
2021-03-25 06:00:00	ES	Futures	4370.2	4374.13	4369.92	4372.73	11886.0
2021-03-25 07:00:00	ES	Futures	4372.73	4373.57	4343.79	4344.35	52214.0
2021-03-25 08:00:00	ES	Futures	4344.35	4349.97	4337.04	4341.54	73274.0
2021-03-25 09:00:00	ES	Futures	4341.26	4349.69	4331.99	4346.03	279599.0
2021-03-25 10:00:00	ES	Futures	4346.03	4357.55	4319.34	4329.46	346314.0
2021-03-25 11:00:00	ES	Futures	4329.74	4353.62	4319.62	4352.21	313710.0
2021-03-25 12:00:00	ES	Futures	4352.5	4369.63	4347.44	4365.7	238586.0
2021-03-25 13:00:00	ES	Futures	4365.7	4373.29	4356.43	4358.12	227173.0
2021-03-25 14:00:00	ES	Futures	4357.83	4376.38	4349.41	4374.97	198615.0
2021-03-25 15:00:00	ES	Futures	4374.97	4393.8	4374.41	4383.96	306321.0
2021-03-25 16:00:00	ES	Futures	4384.25	4392.39	4383.12	4391.27	59503.0
2021-03-25 18:00:00	ES	Futures	4391.55	4391.83	4383.96	4387.34	7554.0
2021-03-25 19:00:00	ES	Futures	4387.34	4396.61	4386.77	4391.27	9708.0
2021-03-25 20:00:00	ES	Futures	4391.27	4396.05	4385.93	4388.46	10628.0
2021-03-25 21:00:00	ES	Futures	4388.46	4394.92	4385.09	4394.36	10133.0
2021-03-25 22:00:00	ES	Futures	4394.36	4398.01	4391.27	4396.89	7509.0
2021-03-25 23:00:00	ES	Futures	4396.89	4401.1	4396.89	4398.29	7360.0
2021-03-25 00:00:00	NQ	Futures	14834.61	14841.27	14823.61	14832.0	1964.0
2021-03-25 01:00:00	NQ	Futures	14832.29	14867.61	14830.26	14832.87	5112.0
2021-03-25 02:00:00	NQ	Futures	14832.29	14850.24	14825.34	14845.9	4343.0
2021-03-25 03:00:00	NQ	Futures	14845.61	14865.87	14827.95	14832.0	5170.0
2021-03-25 04:00:00	NQ	Futures	14831.42	14891.06	14807.39	14864.14	12338.0
2021-03-25 05:00:00	NQ	Futures	14864.14	14865.29	14828.24	14858.92	7312.0
2021-03-25 06:00:00	NQ	Futures	14858.63	14886.43	14858.63	14872.53	5383.0
2021-03-25 07:00:00	NQ	Futures	14872.53	14874.85	14741.1	14753.84	18929.0
2021-03-25 08:00:00	NQ	Futures	14754.13	14771.21	14713.02	14728.07	26292.0
2021-03-25 09:00:00	NQ	Futures	14727.2	14825.92	14693.33	14809.42	92713.0
2021-03-25 10:00:00	NQ	Futures	14809.42	14865.0	14627.91	14667.28	117085.0
2021-03-25 11:00:00	NQ	Futures	14667.86	14715.62	14601.85	14708.39	103822.0
2021-03-25 12:00:00	NQ	Futures	14708.68	14797.26	14689.28	14765.71	79918.0
2021-03-25 13:00:00	NQ	Futures	14765.71	14806.82	14703.47	14708.97	70653.0
2021-03-25 14:00:00	NQ	Futures	14708.39	14803.92	14654.25	14797.26	61811.0
2021-03-25 15:00:00	NQ	Futures	14797.26	14847.06	14772.65	14790.31	76555.0
2021-03-25 16:00:00	NQ	Futures	14790.89	14818.11	14789.74	14812.89	11483.0
2021-03-25 18:00:00	NQ	Futures	14821.87	14821.87	14777.58	14803.34	3042.0
2021-03-25 19:00:00	NQ	Futures	14803.05	14837.5	14799.29	14823.61	3215.0
2021-03-25 20:00:00	NQ	Futures	14822.74	14845.32	14802.76	14815.21	5150.0
2021-03-25 21:00:00	NQ	Futures	14815.5	14845.61	14799.29	14841.84	5089.0
2021-03-25 22:00:00	NQ	Futures	14842.71	14852.27	14826.21	14847.34	4362.0
2021-03-25 23:00:00	NQ	Futures	14847.34	14860.66	14846.19	14852.27	4308.0
2021-03-25 00:00:00	YM	Futures	36100.0	36105.5	36072.1	36083.3	697.0
2021-03-25 01:00:00	YM	Futures	36083.3	36135.6	36063.2	36065.4	2104.0
2021-03-25 02:00:00	YM	Futures	36065.4	36105.5	36055.4	36096.6	1396.0
2021-03-25 03:00:00	YM	Futures	36097.7	36108.9	36046.5	36051.0	1840.0

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

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