PREVIEW / futures_1hour / 2023-09-29

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-09-29.parquet
  size:    57 KB
  rows:    1,658

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-29 00:00:00	ES	Futures	4715.34	4716.43	4710.99	4711.27	4807.0
2023-09-29 01:00:00	ES	Futures	4710.99	4717.78	4708.55	4713.98	10244.0
2023-09-29 02:00:00	ES	Futures	4713.71	4724.03	4713.17	4722.13	15518.0
2023-09-29 03:00:00	ES	Futures	4722.13	4732.72	4720.5	4730.55	29206.0
2023-09-29 04:00:00	ES	Futures	4730.28	4734.89	4728.37	4728.37	21464.0
2023-09-29 05:00:00	ES	Futures	4728.37	4734.62	4728.1	4733.81	20883.0
2023-09-29 06:00:00	ES	Futures	4733.81	4737.61	4730.55	4733.81	18507.0
2023-09-29 07:00:00	ES	Futures	4733.53	4736.79	4726.2	4727.29	25883.0
2023-09-29 08:00:00	ES	Futures	4727.02	4746.57	4724.84	4744.67	80635.0
2023-09-29 09:00:00	ES	Futures	4744.67	4748.2	4733.81	4742.5	215045.0
2023-09-29 10:00:00	ES	Futures	4742.77	4746.84	4728.1	4733.53	262400.0
2023-09-29 11:00:00	ES	Futures	4733.53	4742.77	4712.35	4719.14	242067.0
2023-09-29 12:00:00	ES	Futures	4719.14	4724.84	4704.21	4708.01	155597.0
2023-09-29 13:00:00	ES	Futures	4708.01	4708.01	4685.47	4685.47	182699.0
2023-09-29 14:00:00	ES	Futures	4685.2	4708.28	4682.75	4708.01	189891.0
2023-09-29 15:00:00	ES	Futures	4708.28	4715.61	4691.99	4699.32	386404.0
2023-09-29 16:00:00	ES	Futures	4699.32	4706.38	4694.43	4702.58	86740.0
2023-09-29 00:00:00	NQ	Futures	16353.78	16358.72	16334.83	16335.65	2698.0
2023-09-29 01:00:00	NQ	Futures	16336.2	16368.34	16322.47	16352.41	5342.0
2023-09-29 02:00:00	NQ	Futures	16351.31	16391.41	16348.29	16382.9	6715.0
2023-09-29 03:00:00	NQ	Futures	16383.17	16431.79	16374.38	16419.97	12980.0
2023-09-29 04:00:00	NQ	Futures	16420.8	16441.67	16410.64	16410.91	9972.0
2023-09-29 05:00:00	NQ	Futures	16411.73	16443.87	16409.26	16438.65	8129.0
2023-09-29 06:00:00	NQ	Futures	16438.93	16452.11	16420.52	16425.47	7878.0
2023-09-29 07:00:00	NQ	Futures	16425.19	16437.0	16392.23	16404.59	11035.0
2023-09-29 08:00:00	NQ	Futures	16404.87	16490.56	16394.98	16482.32	34249.0
2023-09-29 09:00:00	NQ	Futures	16482.05	16528.47	16454.31	16515.56	82722.0
2023-09-29 10:00:00	NQ	Futures	16515.28	16546.59	16446.89	16470.79	107741.0
2023-09-29 11:00:00	NQ	Futures	16471.06	16491.66	16378.5	16414.48	95844.0
2023-09-29 12:00:00	NQ	Futures	16415.03	16442.22	16354.06	16365.04	65880.0
2023-09-29 13:00:00	NQ	Futures	16365.59	16365.59	16281.82	16282.09	66798.0
2023-09-29 14:00:00	NQ	Futures	16282.37	16374.38	16272.21	16372.46	65036.0
2023-09-29 15:00:00	NQ	Futures	16373.01	16401.85	16304.34	16333.73	105441.0
2023-09-29 16:00:00	NQ	Futures	16333.73	16376.85	16315.33	16360.65	19611.0
2023-09-29 00:00:00	YM	Futures	36820.1	36824.4	36792.9	36794.0	577.0
2023-09-29 01:00:00	YM	Futures	36794.0	36832.0	36776.7	36810.3	1365.0
2023-09-29 02:00:00	YM	Futures	36808.1	36874.3	36804.9	36859.1	2611.0
2023-09-29 03:00:00	YM	Futures	36859.1	36936.1	36852.6	36915.5	5126.0
2023-09-29 04:00:00	YM	Futures	36914.4	36937.2	36893.8	36893.8	3238.0
2023-09-29 05:00:00	YM	Futures	36896.0	36931.8	36889.5	36922.0	3261.0
2023-09-29 06:00:00	YM	Futures	36920.9	36958.9	36914.4	36935.0	3009.0
2023-09-29 07:00:00	YM	Futures	36932.9	36956.7	36896.0	36898.2	2988.0
2023-09-29 08:00:00	YM	Futures	36898.2	37005.6	36884.1	36993.6	9335.0
2023-09-29 09:00:00	YM	Futures	36992.5	37020.7	36817.9	36864.5	36076.0
2023-09-29 10:00:00	YM	Futures	36868.9	36897.1	36775.6	36809.2	29393.0
2023-09-29 11:00:00	YM	Futures	36810.3	36883.0	36663.9	36702.9	30146.0
2023-09-29 12:00:00	YM	Futures	36705.1	36747.4	36611.8	36637.8	19499.0
2023-09-29 13:00:00	YM	Futures	36637.8	36637.8	36503.3	36504.4	21844.0
2023-09-29 14:00:00	YM	Futures	36504.4	36640.0	36474.0	36638.9	21949.0
2023-09-29 15:00:00	YM	Futures	36638.9	36692.1	36531.5	36592.3	37561.0

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

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