PREVIEW / futures_1hour / 2022-09-13

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-09-13.parquet
  size:    68 KB
  rows:    1,984

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
2022-09-13 00:00:00	ES	Futures	4660.95	4661.23	4656.98	4660.38	1256.0
2022-09-13 01:00:00	ES	Futures	4660.38	4670.58	4658.68	4669.73	2912.0
2022-09-13 02:00:00	ES	Futures	4669.45	4678.8	4667.18	4674.55	4805.0
2022-09-13 03:00:00	ES	Futures	4674.83	4680.78	4668.6	4678.8	7708.0
2022-09-13 04:00:00	ES	Futures	4679.08	4680.49	4675.4	4678.23	5897.0
2022-09-13 05:00:00	ES	Futures	4678.51	4679.65	4672.56	4676.53	6639.0
2022-09-13 06:00:00	ES	Futures	4676.25	4688.99	4674.83	4687.29	5361.0
2022-09-13 07:00:00	ES	Futures	4687.29	4692.68	4686.73	4690.69	7111.0
2022-09-13 08:00:00	ES	Futures	4690.69	4711.37	4555.86	4555.86	80526.0
2022-09-13 09:00:00	ES	Futures	4556.14	4568.6	4542.54	4543.67	107809.0
2022-09-13 10:00:00	ES	Futures	4543.96	4545.37	4511.1	4515.63	89987.0
2022-09-13 11:00:00	ES	Futures	4515.35	4520.16	4506.0	4509.12	40892.0
2022-09-13 12:00:00	ES	Futures	4508.83	4523.28	4506.0	4515.06	30664.0
2022-09-13 13:00:00	ES	Futures	4514.5	4529.23	4509.97	4515.35	32254.0
2022-09-13 14:00:00	ES	Futures	4515.35	4516.76	4482.77	4486.17	38645.0
2022-09-13 15:00:00	ES	Futures	4486.17	4488.72	4441.41	4455.58	102755.0
2022-09-13 16:00:00	ES	Futures	4455.86	4463.51	4454.16	4460.68	25019.0
2022-09-13 18:00:00	ES	Futures	4460.68	4467.76	4456.14	4465.21	2123.0
2022-09-13 19:00:00	ES	Futures	4465.21	4466.34	4456.43	4463.79	2988.0
2022-09-13 20:00:00	ES	Futures	4463.79	4464.64	4449.63	4455.58	7176.0
2022-09-13 21:00:00	ES	Futures	4455.86	4465.21	4455.86	4463.23	3914.0
2022-09-13 22:00:00	ES	Futures	4463.23	4470.02	4462.66	4465.21	2670.0
2022-09-13 23:00:00	ES	Futures	4465.21	4468.32	4459.54	4462.38	1545.0
2022-09-13 00:00:00	NQ	Futures	14756.4	14757.27	14741.36	14749.75	1122.0
2022-09-13 01:00:00	NQ	Futures	14749.75	14779.25	14742.8	14776.64	2095.0
2022-09-13 02:00:00	NQ	Futures	14776.64	14816.27	14769.99	14794.58	4582.0
2022-09-13 03:00:00	NQ	Futures	14794.0	14820.9	14772.6	14810.49	5680.0
2022-09-13 04:00:00	NQ	Futures	14812.51	14814.53	14789.37	14801.52	3530.0
2022-09-13 05:00:00	NQ	Futures	14801.52	14805.86	14780.4	14797.18	3134.0
2022-09-13 06:00:00	NQ	Futures	14796.02	14835.94	14788.79	14829.58	4172.0
2022-09-13 07:00:00	NQ	Futures	14829.0	14857.92	14828.42	14845.77	4761.0
2022-09-13 08:00:00	NQ	Futures	14846.06	14912.01	14318.2	14318.2	45516.0
2022-09-13 09:00:00	NQ	Futures	14319.07	14377.49	14236.64	14238.66	61155.0
2022-09-13 10:00:00	NQ	Futures	14237.5	14264.4	14126.44	14148.13	50547.0
2022-09-13 11:00:00	NQ	Futures	14146.97	14158.54	14093.17	14109.95	31957.0
2022-09-13 12:00:00	NQ	Futures	14109.37	14159.7	14094.91	14129.33	20382.0
2022-09-13 13:00:00	NQ	Futures	14128.46	14179.37	14111.68	14125.86	21803.0
2022-09-13 14:00:00	NQ	Futures	14126.44	14133.96	14028.09	14038.51	22751.0
2022-09-13 15:00:00	NQ	Futures	14037.64	14046.32	13887.23	13930.62	44708.0
2022-09-13 16:00:00	NQ	Futures	13930.62	13950.87	13915.87	13938.72	5260.0
2022-09-13 18:00:00	NQ	Futures	13941.61	13969.09	13916.74	13960.99	2422.0
2022-09-13 19:00:00	NQ	Futures	13960.7	13961.28	13929.46	13950.87	2251.0
2022-09-13 20:00:00	NQ	Futures	13951.45	13953.76	13894.18	13916.74	5130.0
2022-09-13 21:00:00	NQ	Futures	13916.45	13952.02	13911.82	13944.5	3564.0
2022-09-13 22:00:00	NQ	Futures	13944.5	13972.56	13941.9	13952.6	2342.0
2022-09-13 23:00:00	NQ	Futures	13951.45	13964.17	13934.96	13943.93	2096.0
2022-09-13 00:00:00	YM	Futures	36484.9	36487.2	36459.1	36478.2	354.0
2022-09-13 01:00:00	YM	Futures	36479.3	36548.9	36469.2	36543.3	789.0
2022-09-13 02:00:00	YM	Futures	36542.2	36609.5	36525.3	36583.7	1635.0
2022-09-13 03:00:00	YM	Futures	36581.5	36632.0	36544.4	36614.0	1749.0

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

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