PREVIEW / futures_1hour / 2021-03-09

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-03-09.parquet
  size:    64 KB
  rows:    1,936

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-09 00:00:00	ES	Futures	4323.39	4326.47	4319.18	4320.3	7687.0
2021-03-09 01:00:00	ES	Futures	4319.74	4324.51	4305.7	4309.07	11380.0
2021-03-09 02:00:00	ES	Futures	4308.79	4323.1	4304.3	4321.98	16309.0
2021-03-09 03:00:00	ES	Futures	4321.98	4330.96	4314.68	4327.31	34528.0
2021-03-09 04:00:00	ES	Futures	4327.31	4337.14	4326.47	4332.37	28774.0
2021-03-09 05:00:00	ES	Futures	4332.09	4335.73	4326.75	4329.84	18809.0
2021-03-09 06:00:00	ES	Futures	4329.84	4339.66	4329.28	4336.3	28236.0
2021-03-09 07:00:00	ES	Futures	4336.01	4336.3	4322.54	4324.79	32320.0
2021-03-09 08:00:00	ES	Futures	4325.07	4332.93	4323.67	4330.96	40126.0
2021-03-09 09:00:00	ES	Futures	4330.68	4353.14	4327.88	4350.05	217926.0
2021-03-09 10:00:00	ES	Futures	4350.33	4366.61	4347.8	4363.24	277099.0
2021-03-09 11:00:00	ES	Futures	4363.24	4369.69	4359.87	4368.57	135057.0
2021-03-09 12:00:00	ES	Futures	4368.85	4378.11	4367.17	4370.26	100012.0
2021-03-09 13:00:00	ES	Futures	4370.26	4379.8	4370.26	4378.11	106395.0
2021-03-09 14:00:00	ES	Futures	4378.4	4379.8	4368.29	4370.26	115725.0
2021-03-09 15:00:00	ES	Futures	4369.98	4376.71	4345.0	4348.08	279852.0
2021-03-09 16:00:00	ES	Futures	4348.36	4351.45	4344.43	4346.68	73588.0
2021-03-09 18:00:00	ES	Futures	4354.26	4355.38	4349.21	4351.73	8955.0
2021-03-09 19:00:00	ES	Futures	4351.45	4351.73	4343.59	4346.68	14293.0
2021-03-09 20:00:00	ES	Futures	4346.4	4351.73	4336.86	4337.42	16846.0
2021-03-09 21:00:00	ES	Futures	4337.7	4342.19	4335.17	4340.79	11700.0
2021-03-09 22:00:00	ES	Futures	4340.79	4343.03	4338.26	4338.26	6117.0
2021-03-09 23:00:00	ES	Futures	4338.82	4346.96	4334.33	4343.59	10400.0
2021-03-09 00:00:00	NQ	Futures	14421.33	14442.74	14398.75	14402.51	5804.0
2021-03-09 01:00:00	NQ	Futures	14401.35	14418.14	14317.13	14339.99	7808.0
2021-03-09 02:00:00	NQ	Futures	14339.42	14458.37	14318.58	14456.06	12817.0
2021-03-09 03:00:00	NQ	Futures	14455.77	14499.47	14436.09	14489.05	16292.0
2021-03-09 04:00:00	NQ	Futures	14490.21	14561.99	14484.71	14540.28	15234.0
2021-03-09 05:00:00	NQ	Futures	14540.86	14556.49	14504.97	14540.86	11513.0
2021-03-09 06:00:00	NQ	Futures	14541.44	14601.64	14535.65	14582.25	14283.0
2021-03-09 07:00:00	NQ	Futures	14582.54	14582.54	14513.94	14519.15	17956.0
2021-03-09 08:00:00	NQ	Futures	14518.86	14592.38	14518.86	14581.38	21873.0
2021-03-09 09:00:00	NQ	Futures	14581.38	14722.63	14562.28	14708.73	95682.0
2021-03-09 10:00:00	NQ	Futures	14708.73	14781.67	14691.37	14709.89	96954.0
2021-03-09 11:00:00	NQ	Futures	14709.31	14773.57	14684.71	14757.36	56672.0
2021-03-09 12:00:00	NQ	Futures	14758.81	14814.96	14743.75	14789.77	38849.0
2021-03-09 13:00:00	NQ	Futures	14790.06	14886.73	14790.06	14882.1	44051.0
2021-03-09 14:00:00	NQ	Futures	14882.1	14886.16	14826.82	14860.11	34436.0
2021-03-09 15:00:00	NQ	Futures	14859.82	14897.15	14790.64	14803.96	72849.0
2021-03-09 16:00:00	NQ	Futures	14804.25	14815.24	14782.25	14805.11	14429.0
2021-03-09 18:00:00	NQ	Futures	14832.9	14851.13	14810.32	14830.87	5103.0
2021-03-09 19:00:00	NQ	Futures	14829.72	14834.93	14786.88	14801.06	8741.0
2021-03-09 20:00:00	NQ	Futures	14800.77	14822.77	14750.7	14752.15	9743.0
2021-03-09 21:00:00	NQ	Futures	14752.73	14768.36	14729.86	14758.81	7866.0
2021-03-09 22:00:00	NQ	Futures	14758.23	14768.07	14748.96	14750.7	3342.0
2021-03-09 23:00:00	NQ	Futures	14751.86	14811.77	14731.02	14789.2	7555.0
2021-03-09 00:00:00	YM	Futures	35475.4	35490.9	35445.4	35454.3	1750.0
2021-03-09 01:00:00	YM	Futures	35454.3	35492.0	35382.2	35398.9	2740.0
2021-03-09 02:00:00	YM	Futures	35396.6	35436.6	35344.5	35425.5	4308.0
2021-03-09 03:00:00	YM	Futures	35424.4	35488.7	35348.9	35449.9	7749.0

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

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