PREVIEW / futures_1hour / 2023-12-22

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-12-22.parquet
  size:    54 KB
  rows:    1,598

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-22 00:00:00	ES	Futures	5146.2	5146.46	5142.7	5142.97	5671.0
2023-12-22 01:00:00	ES	Futures	5142.97	5145.66	5141.36	5144.58	5828.0
2023-12-22 02:00:00	ES	Futures	5144.58	5146.2	5143.51	5144.32	6908.0
2023-12-22 03:00:00	ES	Futures	5144.32	5149.42	5142.7	5142.97	13144.0
2023-12-22 04:00:00	ES	Futures	5143.24	5150.76	5142.97	5147.54	8986.0
2023-12-22 05:00:00	ES	Futures	5147.54	5150.49	5145.66	5149.96	8081.0
2023-12-22 06:00:00	ES	Futures	5149.96	5151.84	5149.15	5151.03	8702.0
2023-12-22 07:00:00	ES	Futures	5151.03	5153.99	5149.69	5150.49	11459.0
2023-12-22 08:00:00	ES	Futures	5150.76	5165.27	5145.66	5164.73	56476.0
2023-12-22 09:00:00	ES	Futures	5165.0	5180.31	5162.31	5175.47	179371.0
2023-12-22 10:00:00	ES	Futures	5175.47	5179.5	5166.88	5167.15	169089.0
2023-12-22 11:00:00	ES	Futures	5166.88	5173.05	5160.7	5166.07	139210.0
2023-12-22 12:00:00	ES	Futures	5166.34	5171.71	5161.77	5171.71	81704.0
2023-12-22 13:00:00	ES	Futures	5171.71	5173.59	5167.68	5168.22	56790.0
2023-12-22 14:00:00	ES	Futures	5167.95	5168.49	5140.56	5164.46	208217.0
2023-12-22 15:00:00	ES	Futures	5164.46	5166.34	5154.79	5162.58	209185.0
2023-12-22 16:00:00	ES	Futures	5162.85	5165.8	5154.25	5156.13	54741.0
2023-12-22 00:00:00	NQ	Futures	18347.6	18348.14	18330.25	18330.52	3182.0
2023-12-22 01:00:00	NQ	Futures	18330.79	18341.36	18324.28	18337.84	3153.0
2023-12-22 02:00:00	NQ	Futures	18337.57	18349.23	18333.5	18343.53	4111.0
2023-12-22 03:00:00	NQ	Futures	18343.26	18354.38	18333.5	18335.13	5576.0
2023-12-22 04:00:00	NQ	Futures	18335.4	18358.45	18331.87	18349.23	4877.0
2023-12-22 05:00:00	NQ	Futures	18348.96	18369.03	18345.43	18368.76	4013.0
2023-12-22 06:00:00	NQ	Futures	18368.49	18374.18	18362.52	18371.2	3854.0
2023-12-22 07:00:00	NQ	Futures	18370.93	18390.18	18370.93	18383.67	6311.0
2023-12-22 08:00:00	NQ	Futures	18383.94	18449.3	18366.59	18442.52	33120.0
2023-12-22 09:00:00	NQ	Futures	18442.52	18487.0	18430.32	18466.39	74973.0
2023-12-22 10:00:00	NQ	Futures	18468.56	18480.49	18436.56	18437.64	63770.0
2023-12-22 11:00:00	NQ	Futures	18437.91	18456.9	18407.81	18431.13	49491.0
2023-12-22 12:00:00	NQ	Futures	18431.13	18452.83	18407.27	18450.66	34244.0
2023-12-22 13:00:00	NQ	Futures	18450.66	18465.03	18442.25	18446.59	23381.0
2023-12-22 14:00:00	NQ	Futures	18446.32	18448.76	18329.16	18427.88	79943.0
2023-12-22 15:00:00	NQ	Futures	18427.88	18433.57	18395.88	18420.56	51470.0
2023-12-22 16:00:00	NQ	Futures	18420.83	18428.15	18396.96	18401.3	9775.0
2023-12-22 00:00:00	YM	Futures	40415.4	40420.8	40398.2	40400.4	1058.0
2023-12-22 01:00:00	YM	Futures	40400.4	40415.4	40391.8	40408.9	639.0
2023-12-22 02:00:00	YM	Futures	40406.8	40417.5	40395.0	40396.1	1312.0
2023-12-22 03:00:00	YM	Futures	40398.2	40451.9	40397.1	40400.4	1970.0
2023-12-22 04:00:00	YM	Futures	40401.4	40456.2	40401.4	40432.6	1466.0
2023-12-22 05:00:00	YM	Futures	40431.5	40443.3	40403.6	40429.4	1224.0
2023-12-22 06:00:00	YM	Futures	40428.3	40449.8	40426.1	40444.4	895.0
2023-12-22 07:00:00	YM	Futures	40444.4	40447.6	40407.9	40412.2	1705.0
2023-12-22 08:00:00	YM	Futures	40412.2	40494.9	40369.2	40491.7	6337.0
2023-12-22 09:00:00	YM	Futures	40491.7	40683.9	40470.2	40644.2	20208.0
2023-12-22 10:00:00	YM	Futures	40644.2	40680.7	40571.1	40573.3	13720.0
2023-12-22 11:00:00	YM	Futures	40573.3	40609.8	40527.1	40587.2	10105.0
2023-12-22 12:00:00	YM	Futures	40588.3	40609.8	40558.2	40608.7	5105.0
2023-12-22 13:00:00	YM	Futures	40607.7	40619.5	40567.9	40571.1	3778.0
2023-12-22 14:00:00	YM	Futures	40570.1	40576.5	40389.6	40550.7	14703.0
2023-12-22 15:00:00	YM	Futures	40550.7	40566.8	40478.8	40541.1	11846.0

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

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