PREVIEW / futures_1hour / 2023-12-27

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-12-27.parquet
  size:    66 KB
  rows:    2,066

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-27 00:00:00	ES	Futures	5184.34	5186.48	5183.53	5186.22	3130.0
2023-12-27 01:00:00	ES	Futures	5186.22	5187.83	5185.14	5186.22	3960.0
2023-12-27 02:00:00	ES	Futures	5186.22	5188.36	5184.07	5184.34	4820.0
2023-12-27 03:00:00	ES	Futures	5184.34	5186.22	5181.38	5183.53	13853.0
2023-12-27 04:00:00	ES	Futures	5183.53	5184.07	5180.58	5182.46	7598.0
2023-12-27 05:00:00	ES	Futures	5182.72	5183.8	5180.31	5182.46	5150.0
2023-12-27 06:00:00	ES	Futures	5182.46	5183.53	5181.38	5182.72	4520.0
2023-12-27 07:00:00	ES	Futures	5182.72	5184.07	5179.5	5183.8	10478.0
2023-12-27 08:00:00	ES	Futures	5183.53	5187.83	5183.53	5184.07	17954.0
2023-12-27 09:00:00	ES	Futures	5183.8	5188.1	5178.7	5186.48	93926.0
2023-12-27 10:00:00	ES	Futures	5186.48	5188.1	5176.28	5179.77	130196.0
2023-12-27 11:00:00	ES	Futures	5180.04	5185.95	5177.62	5184.07	72789.0
2023-12-27 12:00:00	ES	Futures	5184.34	5187.02	5178.96	5181.38	61427.0
2023-12-27 13:00:00	ES	Futures	5181.38	5194.54	5181.38	5186.75	117269.0
2023-12-27 14:00:00	ES	Futures	5187.02	5187.02	5174.67	5181.11	134892.0
2023-12-27 15:00:00	ES	Futures	5181.11	5195.08	5178.16	5194.27	190781.0
2023-12-27 16:00:00	ES	Futures	5194.27	5196.15	5191.86	5194.27	55270.0
2023-12-27 18:00:00	ES	Futures	5194.01	5194.81	5192.12	5194.01	4722.0
2023-12-27 19:00:00	ES	Futures	5194.01	5197.5	5193.74	5196.96	4716.0
2023-12-27 20:00:00	ES	Futures	5196.96	5200.45	5196.96	5200.45	6613.0
2023-12-27 21:00:00	ES	Futures	5200.45	5201.53	5199.38	5201.26	5525.0
2023-12-27 22:00:00	ES	Futures	5201.53	5201.53	5197.77	5199.65	5447.0
2023-12-27 23:00:00	ES	Futures	5199.65	5201.26	5198.3	5198.3	3620.0
2023-12-27 00:00:00	NQ	Futures	18531.48	18539.89	18526.33	18539.89	2366.0
2023-12-27 01:00:00	NQ	Futures	18540.16	18547.75	18535.82	18540.97	2530.0
2023-12-27 02:00:00	NQ	Futures	18541.24	18551.28	18532.84	18533.38	3743.0
2023-12-27 03:00:00	NQ	Futures	18533.38	18547.21	18520.9	18540.16	6521.0
2023-12-27 04:00:00	NQ	Futures	18539.62	18542.06	18525.51	18530.94	3162.0
2023-12-27 05:00:00	NQ	Futures	18530.67	18536.63	18521.72	18530.67	2919.0
2023-12-27 06:00:00	NQ	Futures	18530.39	18536.9	18528.77	18533.11	2429.0
2023-12-27 07:00:00	NQ	Futures	18533.38	18540.16	18523.07	18537.72	4949.0
2023-12-27 08:00:00	NQ	Futures	18538.53	18557.24	18537.99	18551.28	9435.0
2023-12-27 09:00:00	NQ	Futures	18551.01	18574.06	18537.99	18567.28	51663.0
2023-12-27 10:00:00	NQ	Futures	18567.28	18577.31	18502.19	18527.14	73576.0
2023-12-27 11:00:00	NQ	Futures	18527.41	18547.75	18511.68	18537.45	33536.0
2023-12-27 12:00:00	NQ	Futures	18537.72	18546.12	18513.85	18523.61	28527.0
2023-12-27 13:00:00	NQ	Futures	18523.89	18580.57	18523.07	18555.35	52637.0
2023-12-27 14:00:00	NQ	Futures	18555.35	18558.06	18507.88	18527.95	54193.0
2023-12-27 15:00:00	NQ	Futures	18527.68	18570.53	18519.55	18568.91	56016.0
2023-12-27 16:00:00	NQ	Futures	18568.36	18586.26	18560.5	18583.01	14390.0
2023-12-27 18:00:00	NQ	Futures	18579.75	18580.84	18570.26	18573.79	2753.0
2023-12-27 19:00:00	NQ	Futures	18574.06	18590.33	18573.52	18587.08	3137.0
2023-12-27 20:00:00	NQ	Futures	18587.08	18610.94	18585.72	18606.06	5711.0
2023-12-27 21:00:00	NQ	Futures	18606.33	18609.04	18601.45	18607.42	2420.0
2023-12-27 22:00:00	NQ	Futures	18607.42	18607.42	18592.77	18598.2	2958.0
2023-12-27 23:00:00	NQ	Futures	18598.74	18604.43	18593.59	18595.48	1855.0
2023-12-27 00:00:00	YM	Futures	40695.7	40703.2	40686.1	40701.1	443.0
2023-12-27 01:00:00	YM	Futures	40702.2	40715.1	40697.9	40706.5	680.0
2023-12-27 02:00:00	YM	Futures	40705.4	40720.4	40682.8	40689.3	930.0
2023-12-27 03:00:00	YM	Futures	40689.3	40704.3	40661.4	40690.4	1855.0

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

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