PREVIEW / futures_1hour / 2022-12-23

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-12-23.parquet
  size:    53 KB
  rows:    1,558

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-12-23 00:00:00	ES	Futures	4309.58	4313.21	4307.9	4308.18	3186.0
2022-12-23 01:00:00	ES	Futures	4308.46	4311.53	4303.42	4309.3	4791.0
2022-12-23 02:00:00	ES	Futures	4309.58	4312.09	4305.94	4307.34	5201.0
2022-12-23 03:00:00	ES	Futures	4307.34	4312.09	4301.19	4308.46	13012.0
2022-12-23 04:00:00	ES	Futures	4308.46	4309.58	4300.35	4306.78	8841.0
2022-12-23 05:00:00	ES	Futures	4306.78	4321.6	4305.1	4319.08	11615.0
2022-12-23 06:00:00	ES	Futures	4319.08	4323.84	4309.58	4311.53	11576.0
2022-12-23 07:00:00	ES	Futures	4311.53	4316.29	4308.46	4314.61	13740.0
2022-12-23 08:00:00	ES	Futures	4314.89	4329.99	4284.13	4304.82	104437.0
2022-12-23 09:00:00	ES	Futures	4304.54	4311.25	4273.79	4278.82	232692.0
2022-12-23 10:00:00	ES	Futures	4279.38	4326.63	4275.74	4305.1	238222.0
2022-12-23 11:00:00	ES	Futures	4305.38	4320.2	4296.15	4314.33	144646.0
2022-12-23 12:00:00	ES	Futures	4314.33	4328.31	4311.53	4317.13	94711.0
2022-12-23 13:00:00	ES	Futures	4317.13	4323.84	4307.9	4313.21	82808.0
2022-12-23 14:00:00	ES	Futures	4313.21	4326.07	4308.18	4325.23	84931.0
2022-12-23 15:00:00	ES	Futures	4325.23	4331.11	4314.61	4329.71	197659.0
2022-12-23 16:00:00	ES	Futures	4329.43	4330.55	4326.07	4326.35	32775.0
2022-12-23 00:00:00	NQ	Futures	12584.03	12595.97	12575.49	12577.48	2189.0
2022-12-23 01:00:00	NQ	Futures	12578.34	12594.84	12563.54	12587.16	2919.0
2022-12-23 02:00:00	NQ	Futures	12586.3	12597.97	12568.95	12575.78	3570.0
2022-12-23 03:00:00	NQ	Futures	12576.06	12595.69	12549.89	12574.92	8579.0
2022-12-23 04:00:00	NQ	Futures	12574.64	12581.47	12548.18	12565.82	4932.0
2022-12-23 05:00:00	NQ	Futures	12566.39	12633.24	12560.41	12625.56	7731.0
2022-12-23 06:00:00	NQ	Futures	12625.56	12644.05	12586.59	12595.97	8213.0
2022-12-23 07:00:00	NQ	Futures	12595.97	12628.69	12587.16	12620.16	6967.0
2022-12-23 08:00:00	NQ	Futures	12620.73	12680.47	12494.13	12574.35	49311.0
2022-12-23 09:00:00	NQ	Futures	12574.92	12586.02	12429.26	12448.32	89646.0
2022-12-23 10:00:00	NQ	Futures	12449.46	12635.23	12422.43	12534.81	111918.0
2022-12-23 11:00:00	NQ	Futures	12534.81	12590.28	12489.57	12554.44	55130.0
2022-12-23 12:00:00	NQ	Futures	12555.01	12611.62	12546.19	12566.96	36312.0
2022-12-23 13:00:00	NQ	Futures	12566.67	12590.85	12538.51	12560.98	29157.0
2022-12-23 14:00:00	NQ	Futures	12561.27	12601.66	12541.35	12598.54	29760.0
2022-12-23 15:00:00	NQ	Futures	12598.54	12618.17	12559.27	12608.78	53989.0
2022-12-23 16:00:00	NQ	Futures	12608.49	12611.05	12593.98	12593.98	7551.0
2022-12-23 00:00:00	YM	Futures	37038.7	37069.9	37029.8	37037.6	544.0
2022-12-23 01:00:00	YM	Futures	37037.6	37057.7	37003.1	37043.2	853.0
2022-12-23 02:00:00	YM	Futures	37042.1	37062.1	37017.6	37030.9	1052.0
2022-12-23 03:00:00	YM	Futures	37032.1	37085.5	36997.5	37074.4	2838.0
2022-12-23 04:00:00	YM	Futures	37073.3	37088.9	37008.7	37062.1	2065.0
2022-12-23 05:00:00	YM	Futures	37064.4	37153.5	37052.1	37132.3	2658.0
2022-12-23 06:00:00	YM	Futures	37131.2	37162.4	37067.7	37081.1	1664.0
2022-12-23 07:00:00	YM	Futures	37078.9	37100.0	37057.7	37091.1	1797.0
2022-12-23 08:00:00	YM	Futures	37092.2	37207.0	36898.4	37030.9	15901.0
2022-12-23 09:00:00	YM	Futures	37030.9	37048.8	36755.7	36797.0	29713.0
2022-12-23 10:00:00	YM	Futures	36803.7	37141.3	36771.3	37018.7	34606.0
2022-12-23 11:00:00	YM	Futures	37019.8	37134.6	36954.1	37105.6	13728.0
2022-12-23 12:00:00	YM	Futures	37106.7	37219.2	37093.3	37139.0	10555.0
2022-12-23 13:00:00	YM	Futures	37139.0	37184.7	37052.1	37087.8	8437.0
2022-12-23 14:00:00	YM	Futures	37085.5	37183.6	37049.9	37179.1	8272.0
2022-12-23 15:00:00	YM	Futures	37180.2	37225.9	37086.7	37200.3	13484.0

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

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