PREVIEW / futures_1hour / 2023-01-17

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-01-17.parquet
  size:    68 KB
  rows:    2,077

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-01-17 00:00:00	ES	Futures	4479.86	4480.97	4476.5	4479.02	3661.0
2023-01-17 01:00:00	ES	Futures	4478.74	4481.25	4474.82	4475.94	4686.0
2023-01-17 02:00:00	ES	Futures	4475.94	4480.97	4474.26	4479.02	8084.0
2023-01-17 03:00:00	ES	Futures	4479.02	4484.05	4477.34	4482.09	14214.0
2023-01-17 04:00:00	ES	Futures	4482.09	4485.73	4474.82	4480.42	13528.0
2023-01-17 05:00:00	ES	Futures	4480.14	4486.01	4477.06	4482.93	9482.0
2023-01-17 06:00:00	ES	Futures	4483.21	4485.45	4480.14	4485.17	7535.0
2023-01-17 07:00:00	ES	Futures	4485.17	4488.8	4478.74	4481.53	21077.0
2023-01-17 08:00:00	ES	Futures	4481.53	4489.36	4476.22	4482.37	34229.0
2023-01-17 09:00:00	ES	Futures	4482.37	4500.55	4482.37	4494.12	195706.0
2023-01-17 10:00:00	ES	Futures	4494.4	4513.13	4485.45	4490.2	267031.0
2023-01-17 11:00:00	ES	Futures	4490.2	4493.0	4476.78	4490.2	146684.0
2023-01-17 12:00:00	ES	Futures	4490.2	4494.95	4481.81	4489.08	81326.0
2023-01-17 13:00:00	ES	Futures	4489.08	4496.63	4486.57	4495.23	76165.0
2023-01-17 14:00:00	ES	Futures	4495.23	4497.47	4482.93	4488.8	103054.0
2023-01-17 15:00:00	ES	Futures	4489.08	4494.12	4478.18	4485.17	161977.0
2023-01-17 16:00:00	ES	Futures	4485.17	4488.24	4483.49	4483.77	45594.0
2023-01-17 18:00:00	ES	Futures	4483.21	4483.49	4470.07	4474.26	10240.0
2023-01-17 19:00:00	ES	Futures	4474.26	4475.38	4469.51	4473.15	6992.0
2023-01-17 20:00:00	ES	Futures	4473.15	4477.62	4472.87	4476.22	6763.0
2023-01-17 21:00:00	ES	Futures	4475.94	4506.7	4473.43	4492.16	34856.0
2023-01-17 22:00:00	ES	Futures	4491.88	4495.79	4482.37	4484.89	17347.0
2023-01-17 23:00:00	ES	Futures	4484.89	4491.04	4482.93	4489.92	7260.0
2023-01-17 00:00:00	NQ	Futures	13138.22	13141.92	13125.7	13136.8	2384.0
2023-01-17 01:00:00	NQ	Futures	13136.8	13145.9	13127.69	13129.97	2753.0
2023-01-17 02:00:00	NQ	Futures	13129.69	13151.59	13121.44	13142.77	4738.0
2023-01-17 03:00:00	NQ	Futures	13143.34	13165.53	13139.07	13156.43	6727.0
2023-01-17 04:00:00	NQ	Futures	13156.43	13174.92	13131.11	13150.45	7892.0
2023-01-17 05:00:00	NQ	Futures	13149.88	13176.63	13139.64	13166.39	4559.0
2023-01-17 06:00:00	NQ	Futures	13167.52	13169.23	13151.02	13166.39	4109.0
2023-01-17 07:00:00	NQ	Futures	13167.24	13188.01	13145.33	13156.14	10697.0
2023-01-17 08:00:00	NQ	Futures	13156.43	13184.31	13134.81	13159.84	17559.0
2023-01-17 09:00:00	NQ	Futures	13159.84	13231.53	13143.06	13217.31	86340.0
2023-01-17 10:00:00	NQ	Futures	13216.74	13297.25	13184.31	13211.62	95320.0
2023-01-17 11:00:00	NQ	Futures	13211.34	13231.82	13149.03	13220.72	57180.0
2023-01-17 12:00:00	NQ	Futures	13221.01	13239.5	13187.15	13229.83	34727.0
2023-01-17 13:00:00	NQ	Futures	13230.11	13257.14	13221.01	13251.73	30124.0
2023-01-17 14:00:00	NQ	Futures	13252.02	13257.42	13205.65	13230.4	40240.0
2023-01-17 15:00:00	NQ	Futures	13230.97	13250.6	13203.65	13231.82	45816.0
2023-01-17 16:00:00	NQ	Futures	13231.25	13243.48	13221.58	13226.98	10637.0
2023-01-17 18:00:00	NQ	Futures	13223.0	13227.27	13180.61	13194.27	5251.0
2023-01-17 19:00:00	NQ	Futures	13193.98	13199.1	13179.76	13191.71	3120.0
2023-01-17 20:00:00	NQ	Futures	13191.14	13208.21	13190.0	13203.65	2930.0
2023-01-17 21:00:00	NQ	Futures	13203.94	13305.79	13190.28	13256.29	12113.0
2023-01-17 22:00:00	NQ	Futures	13255.72	13271.93	13221.86	13230.97	6847.0
2023-01-17 23:00:00	NQ	Futures	13230.97	13256.0	13218.45	13252.02	4078.0
2023-01-17 00:00:00	YM	Futures	38286.6	38294.4	38263.2	38277.7	722.0
2023-01-17 01:00:00	YM	Futures	38276.6	38291.1	38251.0	38255.4	872.0
2023-01-17 02:00:00	YM	Futures	38254.3	38286.6	38242.1	38272.1	1062.0
2023-01-17 03:00:00	YM	Futures	38273.3	38302.2	38254.3	38279.9	1987.0

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

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