PREVIEW / futures_1hour / 2023-07-18

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-07-18.parquet
  size:    66 KB
  rows:    2,031

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-07-18 00:00:00	ES	Futures	4995.56	4996.93	4994.73	4996.93	2445.0
2023-07-18 01:00:00	ES	Futures	4996.66	4999.95	4995.83	4998.85	6862.0
2023-07-18 02:00:00	ES	Futures	4998.85	4998.85	4996.38	4998.03	4977.0
2023-07-18 03:00:00	ES	Futures	4997.75	5001.32	4995.01	4999.13	14608.0
2023-07-18 04:00:00	ES	Futures	4999.4	5002.42	4995.83	4997.75	10206.0
2023-07-18 05:00:00	ES	Futures	4997.75	5001.87	4997.75	5000.77	6761.0
2023-07-18 06:00:00	ES	Futures	5001.05	5002.15	4996.11	4997.75	7980.0
2023-07-18 07:00:00	ES	Futures	4997.75	4999.13	4995.01	4996.93	10932.0
2023-07-18 08:00:00	ES	Futures	4997.21	4999.13	4990.34	4994.19	34136.0
2023-07-18 09:00:00	ES	Futures	4993.91	5009.01	4990.89	5007.36	187101.0
2023-07-18 10:00:00	ES	Futures	5007.64	5016.42	5005.72	5015.87	140278.0
2023-07-18 11:00:00	ES	Futures	5015.87	5028.5	5013.68	5026.3	163914.0
2023-07-18 12:00:00	ES	Futures	5026.58	5027.4	5017.79	5022.19	116882.0
2023-07-18 13:00:00	ES	Futures	5022.46	5029.87	5021.91	5029.32	74046.0
2023-07-18 14:00:00	ES	Futures	5029.32	5040.03	5028.5	5037.01	124781.0
2023-07-18 15:00:00	ES	Futures	5037.01	5044.97	5033.44	5037.56	233316.0
2023-07-18 16:00:00	ES	Futures	5037.28	5037.56	5032.34	5032.34	53781.0
2023-07-18 18:00:00	ES	Futures	5032.07	5036.74	5031.52	5034.54	4537.0
2023-07-18 19:00:00	ES	Futures	5034.54	5036.74	5034.54	5035.64	3052.0
2023-07-18 20:00:00	ES	Futures	5035.36	5036.19	5033.99	5035.09	4139.0
2023-07-18 21:00:00	ES	Futures	5035.09	5037.01	5033.99	5035.91	5166.0
2023-07-18 22:00:00	ES	Futures	5035.91	5036.19	5033.99	5035.09	4681.0
2023-07-18 23:00:00	ES	Futures	5035.09	5036.46	5034.81	5035.91	2794.0
2023-07-18 00:00:00	NQ	Futures	17593.19	17597.91	17589.85	17595.97	1385.0
2023-07-18 01:00:00	NQ	Futures	17595.41	17613.49	17593.19	17604.03	3881.0
2023-07-18 02:00:00	NQ	Futures	17604.03	17605.98	17595.13	17604.59	2470.0
2023-07-18 03:00:00	NQ	Futures	17604.03	17624.34	17596.52	17612.93	5991.0
2023-07-18 04:00:00	NQ	Futures	17613.49	17626.56	17597.36	17604.31	5211.0
2023-07-18 05:00:00	NQ	Futures	17604.31	17615.99	17602.09	17611.82	2810.0
2023-07-18 06:00:00	NQ	Futures	17612.1	17615.99	17592.35	17602.64	5101.0
2023-07-18 07:00:00	NQ	Futures	17602.36	17613.49	17590.4	17600.97	5843.0
2023-07-18 08:00:00	NQ	Futures	17600.69	17619.89	17573.44	17591.79	20650.0
2023-07-18 09:00:00	NQ	Futures	17591.79	17599.03	17503.35	17554.53	96420.0
2023-07-18 10:00:00	NQ	Futures	17554.25	17579.56	17525.32	17567.32	82175.0
2023-07-18 11:00:00	NQ	Futures	17567.32	17676.9	17547.57	17669.12	91381.0
2023-07-18 12:00:00	NQ	Futures	17669.39	17719.73	17653.26	17696.65	78357.0
2023-07-18 13:00:00	NQ	Futures	17696.93	17747.83	17694.98	17747.55	47070.0
2023-07-18 14:00:00	NQ	Futures	17747.27	17814.3	17743.38	17805.12	57850.0
2023-07-18 15:00:00	NQ	Futures	17804.84	17833.49	17767.3	17770.35	79346.0
2023-07-18 16:00:00	NQ	Futures	17769.8	17770.08	17741.99	17742.82	18426.0
2023-07-18 18:00:00	NQ	Futures	17743.93	17760.9	17739.2	17755.06	2951.0
2023-07-18 19:00:00	NQ	Futures	17754.78	17763.96	17754.78	17757.84	2116.0
2023-07-18 20:00:00	NQ	Futures	17757.0	17758.12	17747.55	17753.67	2818.0
2023-07-18 21:00:00	NQ	Futures	17753.67	17764.51	17748.38	17758.12	3443.0
2023-07-18 22:00:00	NQ	Futures	17757.84	17758.95	17748.1	17754.5	2599.0
2023-07-18 23:00:00	NQ	Futures	17753.95	17762.29	17753.39	17759.23	1891.0
2023-07-18 00:00:00	YM	Futures	38071.3	38077.9	38066.9	38076.8	382.0
2023-07-18 01:00:00	YM	Futures	38077.9	38094.3	38073.5	38089.9	934.0
2023-07-18 02:00:00	YM	Futures	38089.9	38089.9	38069.1	38076.8	1128.0
2023-07-18 03:00:00	YM	Futures	38075.7	38106.3	38050.5	38091.0	2247.0

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

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