PREVIEW / futures_1hour / 2023-12-26

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-12-26.parquet
  size:    50 KB
  rows:    1,542

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-26 00:00:00	ES	Futures	5169.03	5170.91	5168.76	5169.29	3653.0
2023-12-26 01:00:00	ES	Futures	5169.56	5170.37	5168.49	5169.56	2568.0
2023-12-26 02:00:00	ES	Futures	5169.56	5172.79	5169.56	5172.25	3300.0
2023-12-26 03:00:00	ES	Futures	5171.98	5173.05	5170.37	5171.44	4341.0
2023-12-26 04:00:00	ES	Futures	5171.17	5171.71	5167.95	5169.56	4014.0
2023-12-26 05:00:00	ES	Futures	5169.83	5171.17	5168.76	5171.17	2692.0
2023-12-26 06:00:00	ES	Futures	5171.17	5171.44	5167.41	5168.22	9341.0
2023-12-26 07:00:00	ES	Futures	5168.22	5169.03	5163.92	5168.49	13466.0
2023-12-26 08:00:00	ES	Futures	5168.49	5169.29	5165.27	5168.22	15643.0
2023-12-26 09:00:00	ES	Futures	5168.22	5174.4	5165.53	5172.79	76749.0
2023-12-26 10:00:00	ES	Futures	5173.05	5178.7	5171.44	5175.74	78387.0
2023-12-26 11:00:00	ES	Futures	5175.74	5178.16	5171.98	5177.35	49747.0
2023-12-26 12:00:00	ES	Futures	5177.62	5181.38	5174.94	5177.35	46162.0
2023-12-26 13:00:00	ES	Futures	5177.35	5181.92	5176.82	5178.7	41194.0
2023-12-26 14:00:00	ES	Futures	5178.7	5185.14	5178.43	5184.87	42050.0
2023-12-26 15:00:00	ES	Futures	5184.87	5194.01	5180.58	5183.8	165147.0
2023-12-26 16:00:00	ES	Futures	5183.8	5186.48	5182.72	5185.95	37876.0
2023-12-26 18:00:00	ES	Futures	5186.75	5189.17	5185.41	5185.68	4966.0
2023-12-26 19:00:00	ES	Futures	5185.68	5185.95	5182.72	5182.72	4260.0
2023-12-26 20:00:00	ES	Futures	5182.99	5184.34	5181.38	5184.07	4124.0
2023-12-26 21:00:00	ES	Futures	5184.07	5185.41	5182.99	5183.53	3349.0
2023-12-26 22:00:00	ES	Futures	5183.53	5183.8	5182.19	5182.46	2617.0
2023-12-26 23:00:00	ES	Futures	5182.46	5184.6	5181.92	5184.34	2635.0
2023-12-26 00:00:00	NQ	Futures	18465.58	18471.27	18462.86	18467.75	2361.0
2023-12-26 01:00:00	NQ	Futures	18468.02	18473.17	18465.31	18469.64	1433.0
2023-12-26 02:00:00	NQ	Futures	18470.19	18482.39	18469.37	18478.05	2399.0
2023-12-26 03:00:00	NQ	Futures	18478.05	18480.76	18465.31	18467.48	2110.0
2023-12-26 04:00:00	NQ	Futures	18467.75	18467.75	18445.24	18456.36	3325.0
2023-12-26 05:00:00	NQ	Futures	18456.63	18462.05	18449.58	18459.07	1779.0
2023-12-26 06:00:00	NQ	Futures	18458.8	18459.34	18446.32	18450.39	3052.0
2023-12-26 07:00:00	NQ	Futures	18450.39	18459.88	18425.44	18458.53	6207.0
2023-12-26 08:00:00	NQ	Futures	18458.53	18459.34	18438.73	18446.32	6621.0
2023-12-26 09:00:00	NQ	Futures	18446.05	18498.39	18446.05	18486.46	48998.0
2023-12-26 10:00:00	NQ	Futures	18486.46	18507.61	18466.39	18486.73	40681.0
2023-12-26 11:00:00	NQ	Futures	18486.46	18501.1	18469.92	18497.04	28038.0
2023-12-26 12:00:00	NQ	Futures	18497.04	18504.9	18482.12	18491.61	22815.0
2023-12-26 13:00:00	NQ	Futures	18491.61	18511.95	18488.9	18494.87	19441.0
2023-12-26 14:00:00	NQ	Futures	18495.41	18523.61	18492.7	18521.72	17089.0
2023-12-26 15:00:00	NQ	Futures	18521.45	18562.67	18519.0	18533.38	51956.0
2023-12-26 16:00:00	NQ	Futures	18533.11	18541.24	18530.12	18539.62	9860.0
2023-12-26 18:00:00	NQ	Futures	18539.89	18553.45	18535.01	18538.53	3403.0
2023-12-26 19:00:00	NQ	Futures	18539.07	18541.79	18530.94	18532.56	2419.0
2023-12-26 20:00:00	NQ	Futures	18532.56	18536.09	18522.53	18531.75	3018.0
2023-12-26 21:00:00	NQ	Futures	18532.02	18536.09	18526.6	18528.5	2309.0
2023-12-26 22:00:00	NQ	Futures	18528.77	18532.02	18523.07	18523.89	1679.0
2023-12-26 23:00:00	NQ	Futures	18523.89	18532.56	18522.26	18531.48	1640.0
2023-12-26 00:00:00	YM	Futures	40579.7	40593.7	40578.7	40586.2	344.0
2023-12-26 01:00:00	YM	Futures	40587.2	40590.5	40575.4	40581.9	230.0
2023-12-26 02:00:00	YM	Futures	40581.9	40599.1	40581.9	40596.9	587.0
2023-12-26 03:00:00	YM	Futures	40598.0	40605.5	40580.8	40589.4	811.0

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

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