PREVIEW / futures_1hour / 2023-05-15

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-05-15.parquet
  size:    64 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-05-15 00:00:00	ES	Futures	4589.92	4593.53	4589.92	4592.69	4209.0
2023-05-15 01:00:00	ES	Futures	4592.69	4600.18	4592.14	4599.63	10259.0
2023-05-15 02:00:00	ES	Futures	4599.63	4605.45	4598.52	4605.18	11520.0
2023-05-15 03:00:00	ES	Futures	4604.9	4608.5	4603.51	4607.95	18451.0
2023-05-15 04:00:00	ES	Futures	4607.67	4611.0	4603.51	4604.9	15727.0
2023-05-15 05:00:00	ES	Futures	4604.9	4608.78	4604.34	4606.01	11301.0
2023-05-15 06:00:00	ES	Futures	4605.73	4609.06	4603.79	4608.78	9522.0
2023-05-15 07:00:00	ES	Futures	4608.5	4609.89	4605.18	4606.84	16167.0
2023-05-15 08:00:00	ES	Futures	4606.84	4609.06	4597.96	4598.52	29212.0
2023-05-15 09:00:00	ES	Futures	4598.52	4599.91	4579.94	4581.05	157116.0
2023-05-15 10:00:00	ES	Futures	4581.05	4593.8	4574.11	4587.43	179348.0
2023-05-15 11:00:00	ES	Futures	4587.43	4596.3	4586.59	4593.8	116621.0
2023-05-15 12:00:00	ES	Futures	4593.8	4602.96	4590.48	4602.4	92738.0
2023-05-15 13:00:00	ES	Futures	4602.4	4609.89	4589.09	4597.41	137343.0
2023-05-15 14:00:00	ES	Futures	4597.41	4602.96	4594.36	4598.8	97595.0
2023-05-15 15:00:00	ES	Futures	4598.52	4606.29	4597.96	4605.73	137963.0
2023-05-15 16:00:00	ES	Futures	4605.45	4605.73	4601.29	4602.68	62963.0
2023-05-15 18:00:00	ES	Futures	4602.12	4604.62	4600.18	4601.57	3774.0
2023-05-15 19:00:00	ES	Futures	4601.57	4602.96	4599.63	4600.74	2401.0
2023-05-15 20:00:00	ES	Futures	4600.46	4600.74	4597.41	4600.18	6661.0
2023-05-15 21:00:00	ES	Futures	4600.18	4600.18	4594.91	4597.96	6910.0
2023-05-15 22:00:00	ES	Futures	4597.96	4598.24	4594.08	4597.13	5203.0
2023-05-15 23:00:00	ES	Futures	4597.13	4598.24	4595.47	4595.47	2886.0
2023-05-15 00:00:00	NQ	Futures	15080.54	15090.12	15078.29	15088.14	1920.0
2023-05-15 01:00:00	NQ	Futures	15088.43	15112.08	15085.61	15110.67	4951.0
2023-05-15 02:00:00	NQ	Futures	15110.67	15129.81	15104.76	15128.97	5719.0
2023-05-15 03:00:00	NQ	Futures	15128.13	15140.23	15116.86	15133.76	8206.0
2023-05-15 04:00:00	NQ	Futures	15133.19	15137.42	15121.37	15126.44	6374.0
2023-05-15 05:00:00	NQ	Futures	15126.72	15144.74	15121.65	15127.0	5262.0
2023-05-15 06:00:00	NQ	Futures	15126.72	15134.04	15112.64	15128.97	5488.0
2023-05-15 07:00:00	NQ	Futures	15128.69	15139.67	15116.86	15124.75	8114.0
2023-05-15 08:00:00	NQ	Futures	15124.46	15133.47	15105.32	15118.27	13410.0
2023-05-15 09:00:00	NQ	Futures	15117.99	15126.44	15062.24	15065.34	73944.0
2023-05-15 10:00:00	NQ	Futures	15065.06	15102.22	15036.62	15073.79	82974.0
2023-05-15 11:00:00	NQ	Futures	15073.5	15145.86	15071.81	15143.61	65797.0
2023-05-15 12:00:00	NQ	Futures	15143.89	15152.34	15118.27	15150.93	37094.0
2023-05-15 13:00:00	NQ	Futures	15150.93	15181.34	15111.51	15147.55	59473.0
2023-05-15 14:00:00	NQ	Futures	15147.83	15163.6	15139.39	15145.3	38343.0
2023-05-15 15:00:00	NQ	Futures	15145.58	15173.74	15140.23	15172.33	43852.0
2023-05-15 16:00:00	NQ	Futures	15172.05	15172.89	15158.25	15163.32	12528.0
2023-05-15 18:00:00	NQ	Futures	15159.94	15166.42	15154.31	15155.44	2000.0
2023-05-15 19:00:00	NQ	Futures	15155.72	15161.63	15152.34	15156.56	1697.0
2023-05-15 20:00:00	NQ	Futures	15156.56	15166.13	15152.06	15163.32	3229.0
2023-05-15 21:00:00	NQ	Futures	15164.45	15164.73	15148.68	15161.63	3739.0
2023-05-15 22:00:00	NQ	Futures	15161.35	15161.63	15149.8	15160.22	2084.0
2023-05-15 23:00:00	NQ	Futures	15159.94	15162.76	15155.72	15157.41	1296.0
2023-05-15 00:00:00	YM	Futures	36858.7	36881.9	36857.6	36875.3	535.0
2023-05-15 01:00:00	YM	Futures	36876.4	36932.8	36873.1	36930.6	1466.0
2023-05-15 02:00:00	YM	Futures	36929.5	36971.5	36918.4	36970.4	2004.0
2023-05-15 03:00:00	YM	Futures	36969.2	37000.2	36951.6	36990.3	3254.0

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

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