PREVIEW / futures_1hour / 2023-12-29

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-12-29.parquet
  size:    55 KB
  rows:    1,596

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-12-29 00:00:00	ES	Futures	5194.81	5196.15	5194.54	5195.89	3053.0
2023-12-29 01:00:00	ES	Futures	5196.15	5197.23	5195.89	5196.69	2918.0
2023-12-29 02:00:00	ES	Futures	5196.69	5197.77	5196.15	5196.42	4166.0
2023-12-29 03:00:00	ES	Futures	5196.69	5200.99	5196.42	5197.77	10290.0
2023-12-29 04:00:00	ES	Futures	5198.03	5199.11	5194.01	5194.27	8613.0
2023-12-29 05:00:00	ES	Futures	5194.27	5195.62	5192.39	5194.54	9646.0
2023-12-29 06:00:00	ES	Futures	5194.54	5196.96	5193.47	5195.08	8677.0
2023-12-29 07:00:00	ES	Futures	5195.08	5195.35	5187.56	5189.44	17239.0
2023-12-29 08:00:00	ES	Futures	5189.44	5191.59	5187.02	5187.83	14811.0
2023-12-29 09:00:00	ES	Futures	5187.83	5192.93	5185.95	5191.05	73484.0
2023-12-29 10:00:00	ES	Futures	5191.32	5194.54	5172.52	5177.08	147975.0
2023-12-29 11:00:00	ES	Futures	5177.35	5179.77	5158.82	5163.39	171881.0
2023-12-29 12:00:00	ES	Futures	5163.39	5167.41	5153.45	5166.07	128066.0
2023-12-29 13:00:00	ES	Futures	5166.07	5175.47	5164.46	5172.52	97044.0
2023-12-29 14:00:00	ES	Futures	5172.52	5179.5	5170.64	5177.89	71756.0
2023-12-29 15:00:00	ES	Futures	5177.89	5181.65	5166.61	5177.08	273019.0
2023-12-29 16:00:00	ES	Futures	5177.35	5178.43	5170.1	5170.64	63807.0
2023-12-29 00:00:00	NQ	Futures	18542.87	18551.01	18542.06	18549.92	1783.0
2023-12-29 01:00:00	NQ	Futures	18550.19	18562.13	18549.92	18560.5	1808.0
2023-12-29 02:00:00	NQ	Futures	18560.23	18566.19	18556.97	18557.52	2821.0
2023-12-29 03:00:00	NQ	Futures	18557.79	18584.09	18557.79	18569.45	6140.0
2023-12-29 04:00:00	NQ	Futures	18569.45	18574.33	18558.06	18558.87	4239.0
2023-12-29 05:00:00	NQ	Futures	18558.33	18567.01	18553.45	18563.21	3568.0
2023-12-29 06:00:00	NQ	Futures	18562.94	18572.43	18556.7	18567.28	3165.0
2023-12-29 07:00:00	NQ	Futures	18567.82	18569.45	18524.16	18533.92	9770.0
2023-12-29 08:00:00	NQ	Futures	18533.38	18542.33	18513.58	18533.38	9975.0
2023-12-29 09:00:00	NQ	Futures	18533.92	18558.6	18521.99	18546.12	40106.0
2023-12-29 10:00:00	NQ	Futures	18546.4	18556.7	18443.07	18463.14	75021.0
2023-12-29 11:00:00	NQ	Futures	18463.41	18471.81	18374.99	18416.76	77201.0
2023-12-29 12:00:00	NQ	Futures	18416.49	18438.73	18380.42	18435.74	51527.0
2023-12-29 13:00:00	NQ	Futures	18435.47	18481.31	18428.96	18467.48	50513.0
2023-12-29 14:00:00	NQ	Futures	18467.75	18491.61	18458.25	18487.0	31658.0
2023-12-29 15:00:00	NQ	Futures	18487.27	18495.95	18428.15	18462.59	64930.0
2023-12-29 16:00:00	NQ	Futures	18462.86	18466.39	18445.24	18446.05	11330.0
2023-12-29 00:00:00	YM	Futures	40866.5	40874.0	40863.3	40870.8	364.0
2023-12-29 01:00:00	YM	Futures	40871.9	40878.3	40871.9	40876.2	351.0
2023-12-29 02:00:00	YM	Futures	40875.1	40889.1	40874.0	40888.0	883.0
2023-12-29 03:00:00	YM	Futures	40888.0	40910.5	40879.4	40889.1	1546.0
2023-12-29 04:00:00	YM	Futures	40890.1	40902.0	40861.1	40867.6	1629.0
2023-12-29 05:00:00	YM	Futures	40867.6	40877.2	40852.5	40868.7	1212.0
2023-12-29 06:00:00	YM	Futures	40869.7	40877.2	40860.1	40861.1	950.0
2023-12-29 07:00:00	YM	Futures	40862.2	40866.5	40826.8	40838.6	2126.0
2023-12-29 08:00:00	YM	Futures	40836.4	40854.7	40827.8	40830.0	1658.0
2023-12-29 09:00:00	YM	Futures	40832.1	40873.0	40811.7	40833.2	8976.0
2023-12-29 10:00:00	YM	Futures	40833.2	40855.8	40754.8	40789.2	11219.0
2023-12-29 11:00:00	YM	Futures	40790.2	40816.0	40677.5	40696.8	12549.0
2023-12-29 12:00:00	YM	Futures	40697.9	40745.1	40644.2	40736.5	10209.0
2023-12-29 13:00:00	YM	Futures	40736.5	40781.7	40722.6	40761.2	8133.0
2023-12-29 14:00:00	YM	Futures	40762.3	40810.7	40754.8	40799.9	5628.0
2023-12-29 15:00:00	YM	Futures	40798.8	40847.2	40737.6	40817.1	15273.0

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

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