PREVIEW / futures_1hour / 2022-06-24

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-06-24.parquet
  size:    57 KB
  rows:    1,641

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-06-24 00:00:00	ES	Futures	4323.57	4341.14	4322.72	4338.02	8785.0
2022-06-24 01:00:00	ES	Futures	4337.74	4344.53	4334.34	4339.15	9943.0
2022-06-24 02:00:00	ES	Futures	4339.44	4339.72	4329.52	4329.8	10088.0
2022-06-24 03:00:00	ES	Futures	4330.09	4338.59	4324.71	4334.62	20064.0
2022-06-24 04:00:00	ES	Futures	4334.62	4339.72	4325.27	4334.34	17341.0
2022-06-24 05:00:00	ES	Futures	4334.62	4340.29	4331.79	4339.72	9257.0
2022-06-24 06:00:00	ES	Futures	4339.72	4344.53	4335.47	4338.02	14412.0
2022-06-24 07:00:00	ES	Futures	4337.74	4344.53	4332.07	4334.9	17872.0
2022-06-24 08:00:00	ES	Futures	4335.19	4341.14	4332.64	4334.62	26575.0
2022-06-24 09:00:00	ES	Futures	4334.62	4372.58	4333.77	4368.9	190426.0
2022-06-24 10:00:00	ES	Futures	4368.9	4407.42	4368.9	4399.77	271335.0
2022-06-24 11:00:00	ES	Futures	4399.77	4408.55	4393.82	4405.72	139545.0
2022-06-24 12:00:00	ES	Futures	4405.72	4411.39	4400.62	4408.55	99207.0
2022-06-24 13:00:00	ES	Futures	4408.55	4413.09	4403.74	4405.72	87696.0
2022-06-24 14:00:00	ES	Futures	4406.0	4416.49	4403.46	4415.92	89059.0
2022-06-24 15:00:00	ES	Futures	4415.92	4441.13	4413.37	4440.56	294180.0
2022-06-24 16:00:00	ES	Futures	4440.85	4441.41	4424.7	4435.75	112312.0
2022-06-24 00:00:00	NQ	Futures	13667.12	13727.86	13664.23	13713.11	6448.0
2022-06-24 01:00:00	NQ	Futures	13712.82	13739.72	13697.2	13715.72	6254.0
2022-06-24 02:00:00	NQ	Futures	13715.43	13717.45	13676.38	13682.16	5656.0
2022-06-24 03:00:00	NQ	Futures	13682.74	13725.84	13658.16	13707.91	11074.0
2022-06-24 04:00:00	NQ	Futures	13707.62	13726.42	13671.17	13698.65	8604.0
2022-06-24 05:00:00	NQ	Futures	13699.52	13715.43	13685.63	13712.82	5009.0
2022-06-24 06:00:00	NQ	Futures	13712.24	13727.29	13699.52	13700.68	6634.0
2022-06-24 07:00:00	NQ	Futures	13700.68	13718.9	13668.86	13678.4	8071.0
2022-06-24 08:00:00	NQ	Futures	13678.4	13699.52	13665.1	13681.3	10451.0
2022-06-24 09:00:00	NQ	Futures	13680.43	13864.96	13676.38	13831.41	83594.0
2022-06-24 10:00:00	NQ	Futures	13830.54	13978.92	13830.54	13899.09	108206.0
2022-06-24 11:00:00	NQ	Futures	13898.8	13932.07	13847.9	13899.38	53265.0
2022-06-24 12:00:00	NQ	Futures	13899.67	13919.34	13875.09	13914.13	36384.0
2022-06-24 13:00:00	NQ	Futures	13914.71	13926.28	13881.16	13891.86	33280.0
2022-06-24 14:00:00	NQ	Futures	13892.15	13950.87	13882.61	13946.53	33455.0
2022-06-24 15:00:00	NQ	Futures	13947.11	14054.99	13926.57	14054.41	75390.0
2022-06-24 16:00:00	NQ	Futures	14053.55	14055.28	13993.39	14037.06	27890.0
2022-06-24 00:00:00	YM	Futures	34699.9	34826.3	34699.9	34808.3	1943.0
2022-06-24 01:00:00	YM	Futures	34807.1	34860.2	34786.8	34824.1	1832.0
2022-06-24 02:00:00	YM	Futures	34821.8	34821.8	34759.8	34759.8	2103.0
2022-06-24 03:00:00	YM	Futures	34762.0	34817.3	34724.8	34794.7	3194.0
2022-06-24 04:00:00	YM	Futures	34792.5	34820.7	34734.9	34809.4	3006.0
2022-06-24 05:00:00	YM	Futures	34807.1	34854.5	34786.8	34851.1	2056.0
2022-06-24 06:00:00	YM	Futures	34851.1	34888.4	34815.0	34841.0	2620.0
2022-06-24 07:00:00	YM	Futures	34837.6	34892.9	34821.8	34837.6	2492.0
2022-06-24 08:00:00	YM	Futures	34841.0	34878.2	34812.8	34822.9	3303.0
2022-06-24 09:00:00	YM	Futures	34821.8	35055.4	34816.2	35021.5	23866.0
2022-06-24 10:00:00	YM	Futures	35027.2	35330.7	35027.2	35299.1	28440.0
2022-06-24 11:00:00	YM	Futures	35296.8	35369.1	35260.7	35325.1	12532.0
2022-06-24 12:00:00	YM	Futures	35327.3	35361.2	35293.5	35335.2	6836.0
2022-06-24 13:00:00	YM	Futures	35336.3	35382.6	35307.0	35320.5	6621.0
2022-06-24 14:00:00	YM	Futures	35320.5	35393.9	35295.7	35386.0	5789.0
2022-06-24 15:00:00	YM	Futures	35389.4	35548.5	35367.9	35546.2	15985.0

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

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