PREVIEW / futures_1hour / 2023-05-12

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-05-12.parquet
  size:    56 KB
  rows:    1,643

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-12 00:00:00	ES	Futures	4603.23	4607.67	4602.96	4607.67	4055.0
2023-05-12 01:00:00	ES	Futures	4607.67	4608.23	4605.18	4606.01	4811.0
2023-05-12 02:00:00	ES	Futures	4605.73	4607.67	4603.51	4605.45	6115.0
2023-05-12 03:00:00	ES	Futures	4605.73	4613.5	4602.4	4609.06	21362.0
2023-05-12 04:00:00	ES	Futures	4609.34	4617.38	4606.84	4616.82	13638.0
2023-05-12 05:00:00	ES	Futures	4616.82	4620.15	4613.22	4614.61	12819.0
2023-05-12 06:00:00	ES	Futures	4614.61	4617.93	4611.83	4615.16	8520.0
2023-05-12 07:00:00	ES	Futures	4614.88	4617.1	4610.45	4611.55	10279.0
2023-05-12 08:00:00	ES	Futures	4611.55	4613.5	4607.95	4610.45	18596.0
2023-05-12 09:00:00	ES	Futures	4610.45	4613.22	4600.46	4602.4	121341.0
2023-05-12 10:00:00	ES	Futures	4602.4	4605.45	4585.48	4589.09	217604.0
2023-05-12 11:00:00	ES	Futures	4589.09	4594.91	4579.38	4588.81	154993.0
2023-05-12 12:00:00	ES	Futures	4588.53	4589.92	4565.79	4567.18	163223.0
2023-05-12 13:00:00	ES	Futures	4566.9	4580.21	4562.74	4564.4	151067.0
2023-05-12 14:00:00	ES	Futures	4564.4	4572.17	4561.63	4571.06	143158.0
2023-05-12 15:00:00	ES	Futures	4571.06	4591.31	4568.01	4590.75	223527.0
2023-05-12 16:00:00	ES	Futures	4590.48	4591.03	4583.82	4584.1	74920.0
2023-05-12 00:00:00	NQ	Futures	15183.03	15193.45	15182.46	15192.6	2220.0
2023-05-12 01:00:00	NQ	Futures	15192.88	15193.16	15175.71	15179.37	2704.0
2023-05-12 02:00:00	NQ	Futures	15179.09	15181.9	15167.82	15172.61	3699.0
2023-05-12 03:00:00	NQ	Futures	15172.05	15185.28	15156.56	15165.01	7923.0
2023-05-12 04:00:00	NQ	Futures	15165.29	15187.53	15157.69	15184.44	6183.0
2023-05-12 05:00:00	NQ	Futures	15185.0	15196.82	15173.17	15175.99	5107.0
2023-05-12 06:00:00	NQ	Futures	15176.27	15184.15	15169.23	15177.12	4028.0
2023-05-12 07:00:00	NQ	Futures	15176.83	15182.46	15160.5	15164.45	6032.0
2023-05-12 08:00:00	NQ	Futures	15165.01	15175.71	15151.78	15162.76	11610.0
2023-05-12 09:00:00	NQ	Futures	15162.76	15189.5	15135.16	15138.54	70669.0
2023-05-12 10:00:00	NQ	Futures	15141.92	15152.9	15071.25	15089.55	100189.0
2023-05-12 11:00:00	NQ	Futures	15089.83	15120.24	15057.46	15097.15	74144.0
2023-05-12 12:00:00	NQ	Futures	15097.15	15099.13	14999.74	15009.31	80819.0
2023-05-12 13:00:00	NQ	Futures	15009.59	15058.3	14996.36	15001.43	69890.0
2023-05-12 14:00:00	NQ	Futures	15001.71	15031.27	14990.45	15027.05	59424.0
2023-05-12 15:00:00	NQ	Futures	15027.61	15094.06	15020.57	15088.43	76174.0
2023-05-12 16:00:00	NQ	Futures	15088.43	15088.99	15057.74	15058.02	15690.0
2023-05-12 00:00:00	YM	Futures	36899.6	36932.8	36899.6	36930.6	560.0
2023-05-12 01:00:00	YM	Futures	36931.7	36938.3	36918.4	36925.0	1033.0
2023-05-12 02:00:00	YM	Futures	36923.9	36952.7	36907.4	36936.1	1709.0
2023-05-12 03:00:00	YM	Futures	36937.2	37022.3	36916.2	36991.4	4920.0
2023-05-12 04:00:00	YM	Futures	36991.4	37061.0	36977.0	37047.7	4074.0
2023-05-12 05:00:00	YM	Futures	37047.7	37076.5	37024.5	37030.0	2959.0
2023-05-12 06:00:00	YM	Futures	37030.0	37056.6	37007.9	37035.6	1983.0
2023-05-12 07:00:00	YM	Futures	37034.5	37046.6	37010.1	37019.0	2397.0
2023-05-12 08:00:00	YM	Futures	37019.0	37028.9	36989.1	37005.7	3204.0
2023-05-12 09:00:00	YM	Futures	37004.6	37017.9	36879.7	36901.8	18038.0
2023-05-12 10:00:00	YM	Futures	36920.6	36941.6	36821.1	36844.4	19884.0
2023-05-12 11:00:00	YM	Futures	36846.6	36877.5	36759.2	36837.7	14954.0
2023-05-12 12:00:00	YM	Futures	36839.9	36851.0	36687.4	36697.3	15478.0
2023-05-12 13:00:00	YM	Futures	36697.3	36793.5	36670.8	36690.7	15177.0
2023-05-12 14:00:00	YM	Futures	36691.8	36732.7	36655.3	36718.3	12508.0
2023-05-12 15:00:00	YM	Futures	36719.5	36873.1	36697.3	36866.5	16349.0

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

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