PREVIEW / futures_1hour / 2023-10-03

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-10-03.parquet
  size:    68 KB
  rows:    2,089

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-10-03 00:00:00	ES	Futures	4696.06	4696.06	4687.91	4688.46	8189.0
2023-10-03 01:00:00	ES	Futures	4688.18	4690.08	4685.74	4690.08	11275.0
2023-10-03 02:00:00	ES	Futures	4690.36	4696.6	4690.08	4695.79	11869.0
2023-10-03 03:00:00	ES	Futures	4695.79	4703.12	4694.7	4698.23	28327.0
2023-10-03 04:00:00	ES	Futures	4698.23	4709.64	4697.96	4705.83	24046.0
2023-10-03 05:00:00	ES	Futures	4705.56	4706.38	4698.5	4699.59	18846.0
2023-10-03 06:00:00	ES	Futures	4699.59	4705.56	4695.52	4695.52	20708.0
2023-10-03 07:00:00	ES	Futures	4695.52	4695.52	4671.89	4675.42	58981.0
2023-10-03 08:00:00	ES	Futures	4675.42	4677.05	4662.66	4664.56	79546.0
2023-10-03 09:00:00	ES	Futures	4664.56	4689.27	4662.66	4685.2	248920.0
2023-10-03 10:00:00	ES	Futures	4685.47	4686.28	4631.97	4635.23	502905.0
2023-10-03 11:00:00	ES	Futures	4635.23	4639.85	4624.1	4628.71	233129.0
2023-10-03 12:00:00	ES	Futures	4628.71	4644.46	4628.17	4640.39	189932.0
2023-10-03 13:00:00	ES	Futures	4640.39	4647.18	4623.82	4625.73	147378.0
2023-10-03 14:00:00	ES	Futures	4625.73	4633.06	4617.85	4628.44	172210.0
2023-10-03 15:00:00	ES	Futures	4628.71	4635.77	4618.94	4634.69	310082.0
2023-10-03 16:00:00	ES	Futures	4634.42	4637.67	4630.07	4630.34	67438.0
2023-10-03 18:00:00	ES	Futures	4630.34	4633.87	4628.17	4633.06	5744.0
2023-10-03 19:00:00	ES	Futures	4632.79	4634.42	4628.17	4633.33	7131.0
2023-10-03 20:00:00	ES	Futures	4633.33	4636.59	4625.73	4628.71	16805.0
2023-10-03 21:00:00	ES	Futures	4628.71	4629.53	4612.15	4619.75	27383.0
2023-10-03 22:00:00	ES	Futures	4619.48	4621.92	4615.68	4621.38	15160.0
2023-10-03 23:00:00	ES	Futures	4621.11	4622.47	4610.79	4615.13	10936.0
2023-10-03 00:00:00	NQ	Futures	16462.55	16462.82	16429.04	16430.14	5699.0
2023-10-03 01:00:00	NQ	Futures	16429.31	16434.81	16417.78	16431.24	6494.0
2023-10-03 02:00:00	NQ	Futures	16431.51	16456.51	16430.41	16452.11	5295.0
2023-10-03 03:00:00	NQ	Futures	16452.39	16482.87	16444.42	16457.6	12157.0
2023-10-03 04:00:00	NQ	Futures	16457.6	16513.91	16457.33	16486.72	12794.0
2023-10-03 05:00:00	NQ	Futures	16486.72	16489.46	16446.07	16457.6	10406.0
2023-10-03 06:00:00	NQ	Futures	16458.15	16490.56	16443.05	16443.05	9902.0
2023-10-03 07:00:00	NQ	Futures	16442.77	16445.79	16353.23	16369.16	26692.0
2023-10-03 08:00:00	NQ	Futures	16369.44	16375.48	16312.03	16318.62	28753.0
2023-10-03 09:00:00	NQ	Futures	16318.9	16452.11	16313.41	16424.92	93689.0
2023-10-03 10:00:00	NQ	Futures	16426.02	16430.14	16196.4	16203.26	163426.0
2023-10-03 11:00:00	NQ	Futures	16202.44	16215.08	16161.79	16181.84	79613.0
2023-10-03 12:00:00	NQ	Futures	16182.39	16234.3	16178.54	16218.92	57066.0
2023-10-03 13:00:00	NQ	Futures	16219.47	16243.64	16138.99	16146.68	55208.0
2023-10-03 14:00:00	NQ	Futures	16146.96	16168.66	16118.39	16148.06	54798.0
2023-10-03 15:00:00	NQ	Futures	16148.61	16180.47	16096.97	16171.68	85024.0
2023-10-03 16:00:00	NQ	Futures	16171.95	16187.61	16161.24	16166.19	18082.0
2023-10-03 18:00:00	NQ	Futures	16165.36	16171.68	16151.35	16170.03	3672.0
2023-10-03 19:00:00	NQ	Futures	16170.03	16175.25	16146.68	16168.11	4577.0
2023-10-03 20:00:00	NQ	Futures	16168.38	16186.24	16135.7	16146.96	9185.0
2023-10-03 21:00:00	NQ	Futures	16147.23	16152.73	16097.52	16127.18	13113.0
2023-10-03 22:00:00	NQ	Futures	16126.63	16132.95	16102.19	16129.65	6982.0
2023-10-03 23:00:00	NQ	Futures	16129.11	16135.15	16084.34	16102.74	7000.0
2023-10-03 00:00:00	YM	Futures	36463.2	36463.2	36407.8	36408.9	1267.0
2023-10-03 01:00:00	YM	Futures	36407.8	36427.4	36391.6	36427.4	1414.0
2023-10-03 02:00:00	YM	Futures	36428.5	36475.1	36424.1	36466.4	2017.0
2023-10-03 03:00:00	YM	Futures	36466.4	36519.6	36459.9	36490.3	4733.0

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

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