PREVIEW / futures_1hour / 2022-09-09

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-09-09.parquet
  size:    56 KB
  rows:    1,614

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-09-09 00:00:00	ES	Futures	4553.87	4563.22	4553.59	4560.1	6427.0
2022-09-09 01:00:00	ES	Futures	4559.82	4560.67	4553.02	4555.01	6163.0
2022-09-09 02:00:00	ES	Futures	4555.29	4555.29	4544.81	4550.76	10071.0
2022-09-09 03:00:00	ES	Futures	4551.04	4573.42	4549.91	4563.22	30072.0
2022-09-09 04:00:00	ES	Futures	4563.22	4577.1	4560.39	4576.53	24373.0
2022-09-09 05:00:00	ES	Futures	4576.53	4577.38	4569.45	4574.27	15500.0
2022-09-09 06:00:00	ES	Futures	4573.98	4582.77	4569.45	4578.8	18080.0
2022-09-09 07:00:00	ES	Futures	4579.08	4579.08	4569.74	4572.57	14893.0
2022-09-09 08:00:00	ES	Futures	4572.85	4583.33	4568.04	4572.85	36825.0
2022-09-09 09:00:00	ES	Futures	4572.85	4583.05	4562.09	4582.48	171460.0
2022-09-09 10:00:00	ES	Futures	4582.77	4605.14	4581.07	4602.31	191862.0
2022-09-09 11:00:00	ES	Futures	4602.31	4604.86	4589.28	4598.63	118445.0
2022-09-09 12:00:00	ES	Futures	4598.63	4602.88	4583.62	4602.31	107870.0
2022-09-09 13:00:00	ES	Futures	4602.31	4611.66	4596.36	4609.11	79238.0
2022-09-09 14:00:00	ES	Futures	4608.83	4613.36	4602.31	4611.09	93468.0
2022-09-09 15:00:00	ES	Futures	4611.09	4619.87	4607.13	4607.98	156541.0
2022-09-09 16:00:00	ES	Futures	4607.98	4608.54	4603.16	4607.41	36929.0
2022-09-09 00:00:00	NQ	Futures	14331.79	14363.61	14331.79	14355.22	3903.0
2022-09-09 01:00:00	NQ	Futures	14354.36	14357.54	14329.48	14334.69	3432.0
2022-09-09 02:00:00	NQ	Futures	14336.13	14336.13	14295.35	14323.41	4952.0
2022-09-09 03:00:00	NQ	Futures	14323.99	14409.89	14319.65	14368.53	15797.0
2022-09-09 04:00:00	NQ	Futures	14368.82	14409.02	14355.51	14405.26	11464.0
2022-09-09 05:00:00	NQ	Futures	14404.97	14420.3	14390.8	14407.0	8886.0
2022-09-09 06:00:00	NQ	Futures	14406.71	14440.84	14387.04	14420.3	8164.0
2022-09-09 07:00:00	NQ	Futures	14420.3	14421.17	14387.04	14399.19	6703.0
2022-09-09 08:00:00	NQ	Futures	14398.9	14431.58	14378.07	14398.32	12687.0
2022-09-09 09:00:00	NQ	Futures	14398.03	14467.16	14353.49	14464.84	76289.0
2022-09-09 10:00:00	NQ	Futures	14465.42	14542.94	14446.91	14530.21	80336.0
2022-09-09 11:00:00	NQ	Futures	14530.79	14555.09	14487.12	14529.63	56298.0
2022-09-09 12:00:00	NQ	Futures	14529.63	14550.17	14474.1	14548.15	44138.0
2022-09-09 13:00:00	NQ	Futures	14548.15	14584.01	14527.9	14563.19	32950.0
2022-09-09 14:00:00	NQ	Futures	14562.9	14576.78	14530.21	14551.91	34113.0
2022-09-09 15:00:00	NQ	Futures	14551.62	14593.56	14544.67	14565.79	50064.0
2022-09-09 16:00:00	NQ	Futures	14566.08	14571.57	14545.25	14566.66	10198.0
2022-09-09 00:00:00	YM	Futures	35938.9	35995.3	35935.5	35982.9	775.0
2022-09-09 01:00:00	YM	Futures	35984.0	35985.1	35935.5	35949.0	686.0
2022-09-09 02:00:00	YM	Futures	35945.6	35946.8	35883.6	35918.6	1028.0
2022-09-09 03:00:00	YM	Futures	35915.2	36074.3	35908.4	36008.8	2966.0
2022-09-09 04:00:00	YM	Futures	36005.4	36130.7	35989.6	36119.4	3042.0
2022-09-09 05:00:00	YM	Futures	36119.4	36126.2	36060.7	36098.0	1699.0
2022-09-09 06:00:00	YM	Futures	36095.7	36157.8	36064.1	36130.7	1982.0
2022-09-09 07:00:00	YM	Futures	36131.8	36134.1	36065.2	36087.8	1874.0
2022-09-09 08:00:00	YM	Futures	36086.7	36151.0	36057.3	36076.5	3066.0
2022-09-09 09:00:00	YM	Futures	36076.5	36127.3	35979.5	36098.0	13039.0
2022-09-09 10:00:00	YM	Futures	36100.2	36304.5	36085.6	36281.9	13495.0
2022-09-09 11:00:00	YM	Futures	36284.1	36295.4	36172.4	36233.4	8071.0
2022-09-09 12:00:00	YM	Futures	36234.5	36246.9	36116.0	36236.8	7072.0
2022-09-09 13:00:00	YM	Futures	36239.0	36315.7	36190.5	36293.2	5202.0
2022-09-09 14:00:00	YM	Futures	36294.3	36346.2	36246.9	36330.4	5447.0
2022-09-09 15:00:00	YM	Futures	36332.7	36369.9	36280.8	36295.4	7493.0

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

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