PREVIEW / futures_1hour / 2023-12-20

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-12-20.parquet
  size:    67 KB
  rows:    2,068

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-20 00:00:00	ES	Futures	5181.11	5182.99	5179.5	5181.11	6337.0
2023-12-20 01:00:00	ES	Futures	5181.11	5181.65	5178.43	5179.23	5136.0
2023-12-20 02:00:00	ES	Futures	5179.5	5181.38	5178.43	5180.31	6573.0
2023-12-20 03:00:00	ES	Futures	5180.31	5180.31	5173.05	5174.13	18268.0
2023-12-20 04:00:00	ES	Futures	5173.86	5174.4	5168.22	5170.37	18134.0
2023-12-20 05:00:00	ES	Futures	5170.37	5171.98	5167.95	5169.03	10651.0
2023-12-20 06:00:00	ES	Futures	5169.03	5171.17	5166.34	5168.76	15246.0
2023-12-20 07:00:00	ES	Futures	5168.49	5170.1	5165.8	5167.15	15889.0
2023-12-20 08:00:00	ES	Futures	5167.15	5171.44	5166.61	5168.49	17739.0
2023-12-20 09:00:00	ES	Futures	5168.76	5176.01	5165.0	5175.47	130863.0
2023-12-20 10:00:00	ES	Futures	5175.47	5186.48	5175.2	5183.8	144588.0
2023-12-20 11:00:00	ES	Futures	5183.8	5184.87	5180.31	5181.92	89321.0
2023-12-20 12:00:00	ES	Futures	5181.92	5189.98	5180.84	5188.63	78611.0
2023-12-20 13:00:00	ES	Futures	5188.9	5188.9	5179.77	5180.58	80833.0
2023-12-20 14:00:00	ES	Futures	5180.58	5180.84	5128.74	5130.89	294739.0
2023-12-20 15:00:00	ES	Futures	5131.15	5138.41	5101.07	5102.95	544647.0
2023-12-20 16:00:00	ES	Futures	5103.22	5107.52	5095.97	5106.71	119973.0
2023-12-20 18:00:00	ES	Futures	5104.3	5113.43	5104.3	5113.16	12757.0
2023-12-20 19:00:00	ES	Futures	5112.89	5113.43	5110.2	5111.28	7146.0
2023-12-20 20:00:00	ES	Futures	5111.28	5113.16	5110.47	5112.08	8162.0
2023-12-20 21:00:00	ES	Futures	5112.08	5115.31	5112.08	5115.04	10992.0
2023-12-20 22:00:00	ES	Futures	5115.04	5115.85	5114.23	5114.77	5992.0
2023-12-20 23:00:00	ES	Futures	5114.77	5119.34	5113.97	5119.07	8261.0
2023-12-20 00:00:00	NQ	Futures	18486.19	18491.88	18474.8	18482.12	4020.0
2023-12-20 01:00:00	NQ	Futures	18481.85	18484.29	18470.19	18476.97	3168.0
2023-12-20 02:00:00	NQ	Futures	18477.51	18485.65	18472.63	18481.85	4448.0
2023-12-20 03:00:00	NQ	Futures	18482.12	18482.12	18421.64	18426.79	14547.0
2023-12-20 04:00:00	NQ	Futures	18426.25	18433.3	18400.76	18415.13	13200.0
2023-12-20 05:00:00	NQ	Futures	18415.4	18423.0	18406.18	18412.69	6893.0
2023-12-20 06:00:00	NQ	Futures	18412.96	18420.29	18402.11	18414.59	6226.0
2023-12-20 07:00:00	NQ	Futures	18414.59	18427.61	18406.45	18411.61	7655.0
2023-12-20 08:00:00	NQ	Futures	18411.34	18428.15	18409.44	18422.46	8766.0
2023-12-20 09:00:00	NQ	Futures	18422.46	18468.02	18410.52	18459.88	66859.0
2023-12-20 10:00:00	NQ	Futures	18459.88	18521.72	18451.75	18498.94	77726.0
2023-12-20 11:00:00	NQ	Futures	18498.94	18502.73	18472.63	18486.73	46312.0
2023-12-20 12:00:00	NQ	Futures	18486.73	18511.95	18466.12	18508.7	35907.0
2023-12-20 13:00:00	NQ	Futures	18508.7	18513.31	18475.07	18484.29	35322.0
2023-12-20 14:00:00	NQ	Futures	18484.56	18488.63	18262.71	18270.31	112301.0
2023-12-20 15:00:00	NQ	Futures	18270.85	18299.87	18181.9	18186.23	156443.0
2023-12-20 16:00:00	NQ	Futures	18185.96	18219.32	18180.0	18219.32	24843.0
2023-12-20 18:00:00	NQ	Futures	18214.44	18239.93	18214.44	18237.76	5699.0
2023-12-20 19:00:00	NQ	Futures	18237.49	18238.04	18225.83	18230.71	4068.0
2023-12-20 20:00:00	NQ	Futures	18230.44	18239.12	18226.1	18236.14	4244.0
2023-12-20 21:00:00	NQ	Futures	18235.87	18251.6	18235.32	18246.99	4325.0
2023-12-20 22:00:00	NQ	Futures	18246.99	18257.02	18246.17	18249.97	2736.0
2023-12-20 23:00:00	NQ	Futures	18249.7	18266.78	18247.26	18266.78	3291.0
2023-12-20 00:00:00	YM	Futures	40743.0	40757.0	40737.6	40743.0	842.0
2023-12-20 01:00:00	YM	Futures	40741.9	40749.4	40731.2	40736.5	617.0
2023-12-20 02:00:00	YM	Futures	40736.5	40757.0	40730.1	40743.0	1436.0
2023-12-20 03:00:00	YM	Futures	40745.1	40749.4	40723.7	40731.2	2925.0

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

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