PREVIEW / futures_1hour / 2023-03-22

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-03-22.parquet
  size:    70 KB
  rows:    2,045

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-03-22 00:00:00	ES	Futures	4478.98	4482.59	4478.15	4481.48	4713.0
2023-03-22 01:00:00	ES	Futures	4481.48	4482.03	4478.43	4478.98	4692.0
2023-03-22 02:00:00	ES	Futures	4478.7	4480.09	4476.48	4479.53	5208.0
2023-03-22 03:00:00	ES	Futures	4479.81	4479.81	4464.83	4467.61	15475.0
2023-03-22 04:00:00	ES	Futures	4467.61	4471.21	4462.89	4467.89	19749.0
2023-03-22 05:00:00	ES	Futures	4467.89	4476.48	4465.67	4472.88	12728.0
2023-03-22 06:00:00	ES	Futures	4472.88	4480.92	4469.27	4478.7	17934.0
2023-03-22 07:00:00	ES	Futures	4478.98	4483.97	4474.54	4475.93	17909.0
2023-03-22 08:00:00	ES	Futures	4476.21	4478.98	4472.32	4477.32	18649.0
2023-03-22 09:00:00	ES	Futures	4477.32	4480.92	4469.83	4475.65	121106.0
2023-03-22 10:00:00	ES	Futures	4475.65	4490.35	4472.32	4483.14	131505.0
2023-03-22 11:00:00	ES	Futures	4483.14	4485.08	4473.43	4479.26	94391.0
2023-03-22 12:00:00	ES	Futures	4479.26	4480.09	4467.05	4468.16	83148.0
2023-03-22 13:00:00	ES	Futures	4468.44	4477.87	4461.78	4475.65	71935.0
2023-03-22 14:00:00	ES	Futures	4475.1	4519.47	4462.34	4475.37	440079.0
2023-03-22 15:00:00	ES	Futures	4475.37	4490.35	4401.88	4403.26	533423.0
2023-03-22 16:00:00	ES	Futures	4403.26	4412.97	4400.21	4406.31	107535.0
2023-03-22 18:00:00	ES	Futures	4407.42	4413.8	4406.31	4411.58	7292.0
2023-03-22 19:00:00	ES	Futures	4411.58	4412.14	4407.42	4410.2	6382.0
2023-03-22 20:00:00	ES	Futures	4409.92	4414.36	4405.2	4411.03	14008.0
2023-03-22 21:00:00	ES	Futures	4411.03	4417.68	4410.47	4417.13	11668.0
2023-03-22 22:00:00	ES	Futures	4417.13	4427.95	4416.85	4426.01	13336.0
2023-03-22 23:00:00	ES	Futures	4426.01	4426.28	4422.95	4425.17	6549.0
2023-03-22 00:00:00	NQ	Futures	14499.98	14512.65	14498.29	14507.58	1958.0
2023-03-22 01:00:00	NQ	Futures	14507.02	14508.99	14490.97	14492.66	2124.0
2023-03-22 02:00:00	NQ	Futures	14492.1	14501.95	14486.18	14499.14	2456.0
2023-03-22 03:00:00	NQ	Futures	14499.98	14500.54	14450.43	14452.96	7670.0
2023-03-22 04:00:00	NQ	Futures	14453.24	14455.21	14425.93	14434.38	10823.0
2023-03-22 05:00:00	NQ	Futures	14435.5	14469.57	14427.06	14459.16	6715.0
2023-03-22 06:00:00	NQ	Futures	14459.16	14481.68	14451.83	14475.77	6587.0
2023-03-22 07:00:00	NQ	Futures	14474.64	14491.25	14463.94	14470.98	7463.0
2023-03-22 08:00:00	NQ	Futures	14471.83	14480.55	14455.21	14475.2	8871.0
2023-03-22 09:00:00	NQ	Futures	14475.49	14523.35	14472.67	14508.99	50673.0
2023-03-22 10:00:00	NQ	Futures	14509.27	14572.06	14487.59	14543.62	68133.0
2023-03-22 11:00:00	NQ	Futures	14543.34	14579.1	14514.06	14565.02	44136.0
2023-03-22 12:00:00	NQ	Futures	14565.02	14565.58	14500.26	14518.84	42788.0
2023-03-22 13:00:00	NQ	Futures	14519.13	14566.71	14496.04	14553.48	31976.0
2023-03-22 14:00:00	NQ	Futures	14556.29	14733.11	14501.95	14552.63	180775.0
2023-03-22 15:00:00	NQ	Futures	14552.91	14629.78	14298.39	14301.49	181856.0
2023-03-22 16:00:00	NQ	Futures	14301.77	14323.17	14278.12	14301.49	33249.0
2023-03-22 18:00:00	NQ	Futures	14297.26	14332.17	14296.42	14327.67	3920.0
2023-03-22 19:00:00	NQ	Futures	14327.39	14331.89	14312.75	14324.29	3080.0
2023-03-22 20:00:00	NQ	Futures	14323.73	14340.62	14308.81	14328.8	4782.0
2023-03-22 21:00:00	NQ	Futures	14329.08	14348.79	14324.57	14346.25	4396.0
2023-03-22 22:00:00	NQ	Futures	14346.82	14388.77	14346.53	14380.6	6305.0
2023-03-22 23:00:00	NQ	Futures	14380.32	14385.95	14373.0	14382.57	3022.0
2023-03-22 00:00:00	YM	Futures	36217.6	36236.4	36209.9	36227.6	735.0
2023-03-22 01:00:00	YM	Futures	36229.8	36243.1	36215.4	36217.6	833.0
2023-03-22 02:00:00	YM	Futures	36215.4	36218.7	36196.6	36211.0	768.0
2023-03-22 03:00:00	YM	Futures	36212.1	36216.5	36109.3	36143.6	2697.0

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

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