PREVIEW / futures_1hour / 2022-07-18

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-07-18.parquet
  size:    68 KB
  rows:    2,052

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
2022-07-18 00:00:00	ES	Futures	4397.22	4399.77	4394.11	4399.21	2961.0
2022-07-18 01:00:00	ES	Futures	4399.21	4404.59	4395.52	4403.74	5267.0
2022-07-18 02:00:00	ES	Futures	4403.74	4408.55	4398.92	4408.27	12323.0
2022-07-18 03:00:00	ES	Futures	4407.99	4421.02	4402.04	4415.92	23452.0
2022-07-18 04:00:00	ES	Futures	4415.92	4429.8	4413.65	4428.95	20961.0
2022-07-18 05:00:00	ES	Futures	4428.38	4429.23	4419.04	4421.58	12308.0
2022-07-18 06:00:00	ES	Futures	4421.3	4425.27	4419.04	4421.02	10340.0
2022-07-18 07:00:00	ES	Futures	4421.02	4428.1	4417.62	4422.15	17313.0
2022-07-18 08:00:00	ES	Futures	4422.15	4424.98	4407.7	4415.07	38537.0
2022-07-18 09:00:00	ES	Futures	4414.79	4424.98	4408.84	4416.2	173367.0
2022-07-18 10:00:00	ES	Futures	4416.2	4420.73	4403.74	4411.95	174932.0
2022-07-18 11:00:00	ES	Futures	4411.95	4417.9	4404.87	4416.77	102090.0
2022-07-18 12:00:00	ES	Futures	4416.77	4417.34	4401.47	4402.89	81800.0
2022-07-18 13:00:00	ES	Futures	4402.89	4405.15	4370.88	4372.86	164844.0
2022-07-18 14:00:00	ES	Futures	4372.86	4379.94	4355.3	4357.0	182500.0
2022-07-18 15:00:00	ES	Futures	4357.0	4366.63	4328.67	4344.25	276663.0
2022-07-18 16:00:00	ES	Futures	4344.53	4350.2	4341.99	4349.07	48242.0
2022-07-18 18:00:00	ES	Futures	4349.35	4352.75	4344.25	4350.48	6084.0
2022-07-18 19:00:00	ES	Futures	4350.48	4356.43	4346.52	4355.58	6222.0
2022-07-18 20:00:00	ES	Futures	4355.87	4357.28	4345.95	4349.63	6963.0
2022-07-18 21:00:00	ES	Futures	4349.63	4356.15	4348.22	4350.2	6535.0
2022-07-18 22:00:00	ES	Futures	4350.48	4358.13	4350.48	4355.87	4944.0
2022-07-18 23:00:00	ES	Futures	4355.87	4358.42	4349.35	4351.9	4605.0
2022-07-18 00:00:00	NQ	Futures	13998.88	14008.14	13989.63	14002.35	2221.0
2022-07-18 01:00:00	NQ	Futures	14002.06	14023.47	13987.02	14016.24	3885.0
2022-07-18 02:00:00	NQ	Futures	14015.37	14033.59	13996.86	14029.83	5563.0
2022-07-18 03:00:00	NQ	Futures	14029.54	14080.16	14001.19	14055.57	12273.0
2022-07-18 04:00:00	NQ	Futures	14054.99	14092.02	14037.35	14081.6	9728.0
2022-07-18 05:00:00	NQ	Futures	14081.31	14083.63	14049.79	14056.73	5156.0
2022-07-18 06:00:00	NQ	Futures	14056.44	14067.43	14046.89	14052.1	4285.0
2022-07-18 07:00:00	NQ	Futures	14052.68	14074.08	14037.35	14056.73	6844.0
2022-07-18 08:00:00	NQ	Futures	14057.31	14066.27	14001.48	14029.83	14740.0
2022-07-18 09:00:00	NQ	Futures	14028.96	14099.25	13987.31	14071.48	83104.0
2022-07-18 10:00:00	NQ	Futures	14071.48	14095.78	13993.96	14041.98	74012.0
2022-07-18 11:00:00	NQ	Futures	14042.27	14095.2	14023.47	14091.73	44399.0
2022-07-18 12:00:00	NQ	Futures	14092.02	14096.64	14045.45	14050.08	32506.0
2022-07-18 13:00:00	NQ	Futures	14049.79	14056.44	13851.95	13869.59	68762.0
2022-07-18 14:00:00	NQ	Futures	13869.88	13901.7	13792.65	13798.44	65734.0
2022-07-18 15:00:00	NQ	Futures	13798.44	13842.4	13718.03	13775.88	76148.0
2022-07-18 16:00:00	NQ	Futures	13775.88	13790.05	13765.46	13786.58	12180.0
2022-07-18 18:00:00	NQ	Futures	13778.77	13801.04	13767.78	13794.97	3273.0
2022-07-18 19:00:00	NQ	Futures	13795.26	13817.82	13779.06	13814.06	3813.0
2022-07-18 20:00:00	NQ	Futures	13814.06	13819.55	13785.42	13799.02	3723.0
2022-07-18 21:00:00	NQ	Futures	13799.31	13826.78	13792.65	13804.22	3854.0
2022-07-18 22:00:00	NQ	Futures	13804.51	13830.25	13804.51	13819.84	2222.0
2022-07-18 23:00:00	NQ	Futures	13820.13	13827.94	13785.13	13796.99	3251.0
2022-07-18 00:00:00	YM	Futures	35343.1	35366.8	35322.8	35365.7	629.0
2022-07-18 01:00:00	YM	Futures	35366.8	35404.0	35343.1	35395.0	1364.0
2022-07-18 02:00:00	YM	Futures	35395.0	35433.4	35364.5	35430.0	2253.0
2022-07-18 03:00:00	YM	Futures	35428.9	35523.6	35392.8	35495.4	4583.0

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

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