PREVIEW / futures_1hour / 2023-09-20

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-09-20.parquet
  size:    69 KB
  rows:    2,038

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
2023-09-20 00:00:00	ES	Futures	4872.03	4872.57	4870.94	4872.03	2506.0
2023-09-20 01:00:00	ES	Futures	4872.03	4875.02	4870.94	4872.84	4285.0
2023-09-20 02:00:00	ES	Futures	4872.84	4880.45	4872.84	4876.65	10275.0
2023-09-20 03:00:00	ES	Futures	4876.65	4881.53	4875.83	4879.63	13616.0
2023-09-20 04:00:00	ES	Futures	4879.36	4885.61	4876.37	4884.79	13792.0
2023-09-20 05:00:00	ES	Futures	4884.79	4887.51	4882.89	4886.96	10572.0
2023-09-20 06:00:00	ES	Futures	4886.69	4887.78	4883.71	4887.24	12868.0
2023-09-20 07:00:00	ES	Futures	4886.96	4889.68	4885.88	4888.05	11843.0
2023-09-20 08:00:00	ES	Futures	4887.78	4894.57	4886.96	4894.02	21754.0
2023-09-20 09:00:00	ES	Futures	4894.02	4896.74	4885.06	4892.67	132313.0
2023-09-20 10:00:00	ES	Futures	4892.67	4896.2	4884.52	4886.96	124590.0
2023-09-20 11:00:00	ES	Futures	4887.24	4890.77	4881.8	4888.32	89143.0
2023-09-20 12:00:00	ES	Futures	4888.32	4891.31	4885.33	4890.77	53172.0
2023-09-20 13:00:00	ES	Futures	4891.04	4891.31	4880.99	4886.42	70944.0
2023-09-20 14:00:00	ES	Futures	4886.69	4888.05	4863.07	4866.87	359383.0
2023-09-20 15:00:00	ES	Futures	4866.87	4871.76	4829.39	4831.57	376194.0
2023-09-20 16:00:00	ES	Futures	4831.57	4833.2	4826.41	4827.49	89319.0
2023-09-20 18:00:00	ES	Futures	4828.31	4830.48	4823.69	4825.59	11022.0
2023-09-20 19:00:00	ES	Futures	4825.32	4826.68	4822.61	4823.42	8188.0
2023-09-20 20:00:00	ES	Futures	4823.42	4827.49	4818.26	4819.35	16778.0
2023-09-20 21:00:00	ES	Futures	4819.35	4821.25	4816.9	4816.9	10900.0
2023-09-20 22:00:00	ES	Futures	4816.9	4818.53	4813.37	4815.27	10572.0
2023-09-20 23:00:00	ES	Futures	4815.27	4818.53	4815.0	4818.26	6128.0
2023-09-20 00:00:00	NQ	Futures	16864.38	16867.4	16855.87	16862.18	2585.0
2023-09-20 01:00:00	NQ	Futures	16862.18	16876.47	16856.97	16864.93	2895.0
2023-09-20 02:00:00	NQ	Futures	16864.93	16903.66	16864.11	16884.98	5663.0
2023-09-20 03:00:00	NQ	Futures	16884.43	16908.33	16880.04	16900.36	5787.0
2023-09-20 04:00:00	NQ	Futures	16899.81	16926.18	16880.86	16922.06	8005.0
2023-09-20 05:00:00	NQ	Futures	16922.61	16930.3	16913.0	16926.73	5477.0
2023-09-20 06:00:00	NQ	Futures	16926.73	16926.73	16906.13	16922.61	5130.0
2023-09-20 07:00:00	NQ	Futures	16922.06	16932.77	16911.07	16922.06	5990.0
2023-09-20 08:00:00	NQ	Futures	16921.79	16954.47	16917.12	16952.55	12086.0
2023-09-20 09:00:00	NQ	Futures	16952.82	16959.14	16891.85	16932.77	71181.0
2023-09-20 10:00:00	NQ	Futures	16933.05	16942.39	16870.97	16879.21	75335.0
2023-09-20 11:00:00	NQ	Futures	16879.21	16893.77	16840.76	16892.4	53523.0
2023-09-20 12:00:00	NQ	Futures	16892.12	16902.56	16873.45	16899.81	26899.0
2023-09-20 13:00:00	NQ	Futures	16900.09	16904.76	16861.09	16887.73	27366.0
2023-09-20 14:00:00	NQ	Futures	16885.81	16910.52	16794.07	16812.74	124555.0
2023-09-20 15:00:00	NQ	Futures	16812.2	16835.27	16641.9	16647.12	125611.0
2023-09-20 16:00:00	NQ	Futures	16647.4	16653.71	16619.38	16626.8	22890.0
2023-09-20 18:00:00	NQ	Futures	16626.25	16643.55	16606.2	16616.36	6607.0
2023-09-20 19:00:00	NQ	Futures	16616.36	16624.32	16599.61	16605.1	4819.0
2023-09-20 20:00:00	NQ	Futures	16604.82	16627.9	16579.01	16588.62	8460.0
2023-09-20 21:00:00	NQ	Futures	16588.62	16600.7	16581.75	16584.22	5581.0
2023-09-20 22:00:00	NQ	Futures	16583.95	16588.34	16567.74	16576.81	5755.0
2023-09-20 23:00:00	NQ	Futures	16577.36	16592.19	16574.89	16584.77	3458.0
2023-09-20 00:00:00	YM	Futures	37725.9	37736.7	37724.8	37732.4	256.0
2023-09-20 01:00:00	YM	Futures	37731.3	37754.1	37726.9	37742.1	474.0
2023-09-20 02:00:00	YM	Futures	37742.1	37793.1	37742.1	37768.2	1818.0
2023-09-20 03:00:00	YM	Futures	37768.2	37796.4	37758.4	37779.0	1746.0

> showing 50 of 2,038 rows — these rows as CSV

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