PREVIEW / futures_1hour / 2022-07-22

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-07-22.parquet
  size:    58 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
2022-07-22 00:00:00	ES	Futures	4517.05	4518.46	4513.93	4513.93	2039.0
2022-07-22 01:00:00	ES	Futures	4514.21	4517.33	4509.97	4510.82	4320.0
2022-07-22 02:00:00	ES	Futures	4511.1	4521.86	4511.1	4519.88	8597.0
2022-07-22 03:00:00	ES	Futures	4519.88	4527.81	4509.68	4516.2	23606.0
2022-07-22 04:00:00	ES	Futures	4516.2	4523.85	4510.82	4519.6	12995.0
2022-07-22 05:00:00	ES	Futures	4519.6	4526.4	4518.46	4519.31	9923.0
2022-07-22 06:00:00	ES	Futures	4519.6	4528.38	4518.75	4523.28	11171.0
2022-07-22 07:00:00	ES	Futures	4523.0	4530.08	4519.31	4529.23	18046.0
2022-07-22 08:00:00	ES	Futures	4529.23	4531.78	4524.98	4528.09	24828.0
2022-07-22 09:00:00	ES	Futures	4528.09	4550.76	4524.98	4525.55	267431.0
2022-07-22 10:00:00	ES	Futures	4525.55	4539.99	4517.05	4534.04	253607.0
2022-07-22 11:00:00	ES	Futures	4534.04	4535.46	4495.24	4506.0	225874.0
2022-07-22 12:00:00	ES	Futures	4506.28	4510.25	4490.7	4494.39	175997.0
2022-07-22 13:00:00	ES	Futures	4494.67	4494.67	4471.72	4480.22	170866.0
2022-07-22 14:00:00	ES	Futures	4480.51	4481.92	4466.06	4476.54	145070.0
2022-07-22 15:00:00	ES	Futures	4476.82	4494.1	4472.86	4493.25	251787.0
2022-07-22 16:00:00	ES	Futures	4492.97	4493.25	4485.04	4490.7	50495.0
2022-07-22 00:00:00	NQ	Futures	14518.06	14522.4	14505.63	14505.63	1142.0
2022-07-22 01:00:00	NQ	Futures	14507.65	14518.64	14488.85	14494.93	3146.0
2022-07-22 02:00:00	NQ	Futures	14495.5	14531.08	14493.19	14521.25	3848.0
2022-07-22 03:00:00	NQ	Futures	14521.25	14549.88	14498.11	14525.3	11046.0
2022-07-22 04:00:00	NQ	Futures	14525.58	14551.33	14503.02	14541.2	8117.0
2022-07-22 05:00:00	NQ	Futures	14540.63	14565.79	14538.02	14540.34	5662.0
2022-07-22 06:00:00	NQ	Futures	14540.05	14579.96	14534.26	14561.45	6203.0
2022-07-22 07:00:00	NQ	Futures	14561.16	14597.03	14537.73	14595.87	9459.0
2022-07-22 08:00:00	NQ	Futures	14594.71	14597.32	14567.24	14573.6	10500.0
2022-07-22 09:00:00	NQ	Futures	14573.89	14691.61	14538.31	14553.35	103916.0
2022-07-22 10:00:00	NQ	Futures	14554.22	14591.82	14511.41	14557.4	89009.0
2022-07-22 11:00:00	NQ	Futures	14557.98	14563.76	14371.42	14417.99	88500.0
2022-07-22 12:00:00	NQ	Futures	14417.7	14433.32	14353.78	14378.36	56054.0
2022-07-22 13:00:00	NQ	Futures	14378.94	14380.1	14297.66	14340.18	63776.0
2022-07-22 14:00:00	NQ	Futures	14340.18	14345.1	14281.18	14329.77	57017.0
2022-07-22 15:00:00	NQ	Futures	14330.35	14381.83	14306.34	14374.31	73848.0
2022-07-22 16:00:00	NQ	Futures	14374.02	14379.81	14356.09	14379.81	13116.0
2022-07-22 00:00:00	YM	Futures	36075.4	36084.4	36054.0	36054.0	403.0
2022-07-22 01:00:00	YM	Futures	36054.0	36074.3	36023.5	36031.4	815.0
2022-07-22 02:00:00	YM	Futures	36033.7	36109.3	36032.5	36098.0	1908.0
2022-07-22 03:00:00	YM	Futures	36098.0	36162.3	36020.1	36061.9	5397.0
2022-07-22 04:00:00	YM	Futures	36065.2	36120.5	36029.1	36088.9	3080.0
2022-07-22 05:00:00	YM	Futures	36088.9	36143.1	36078.8	36090.1	2414.0
2022-07-22 06:00:00	YM	Futures	36091.2	36145.4	36086.7	36105.9	2073.0
2022-07-22 07:00:00	YM	Futures	36105.9	36187.1	36091.2	36174.7	5431.0
2022-07-22 08:00:00	YM	Futures	36174.7	36218.7	36154.4	36204.0	4854.0
2022-07-22 09:00:00	YM	Futures	36204.0	36324.8	36127.3	36136.3	28304.0
2022-07-22 10:00:00	YM	Futures	36139.7	36251.4	36084.4	36232.2	20222.0
2022-07-22 11:00:00	YM	Futures	36232.2	36245.8	35989.6	36072.0	15406.0
2022-07-22 12:00:00	YM	Futures	36069.8	36103.6	35977.2	36000.9	13022.0
2022-07-22 13:00:00	YM	Futures	35998.7	36004.3	35836.2	35883.6	13796.0
2022-07-22 14:00:00	YM	Futures	35885.8	35894.9	35773.0	35849.7	12405.0
2022-07-22 15:00:00	YM	Futures	35850.9	35977.2	35831.7	35970.5	15902.0

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

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