PREVIEW / futures_1hour / 2022-10-14

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-10-14.parquet
  size:    58 KB
  rows:    1,644

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-10-14 00:00:00	ES	Futures	4183.02	4184.15	4176.25	4177.66	10359.0
2022-10-14 01:00:00	ES	Futures	4177.38	4181.61	4173.15	4176.54	11165.0
2022-10-14 02:00:00	ES	Futures	4176.54	4187.25	4170.9	4177.38	21895.0
2022-10-14 03:00:00	ES	Futures	4177.1	4178.51	4151.45	4161.88	41413.0
2022-10-14 04:00:00	ES	Futures	4161.88	4162.16	4132.56	4135.1	33516.0
2022-10-14 05:00:00	ES	Futures	4135.1	4145.25	4127.2	4143.84	40604.0
2022-10-14 06:00:00	ES	Futures	4143.84	4176.54	4141.86	4170.05	43388.0
2022-10-14 07:00:00	ES	Futures	4170.05	4174.84	4141.3	4142.14	40861.0
2022-10-14 08:00:00	ES	Futures	4142.43	4210.08	4141.02	4198.52	115785.0
2022-10-14 09:00:00	ES	Futures	4198.52	4201.62	4151.45	4158.49	398786.0
2022-10-14 10:00:00	ES	Futures	4159.06	4159.62	4087.46	4106.63	545908.0
2022-10-14 11:00:00	ES	Futures	4106.91	4123.26	4075.05	4079.85	281087.0
2022-10-14 12:00:00	ES	Futures	4080.13	4095.35	4065.47	4075.62	228279.0
2022-10-14 13:00:00	ES	Futures	4075.9	4085.77	4066.03	4084.64	150759.0
2022-10-14 14:00:00	ES	Futures	4084.92	4084.92	4055.32	4065.75	160304.0
2022-10-14 15:00:00	ES	Futures	4065.75	4077.03	4049.4	4058.42	360841.0
2022-10-14 16:00:00	ES	Futures	4058.42	4060.96	4055.32	4055.32	76598.0
2022-10-14 00:00:00	NQ	Futures	12834.56	12835.71	12805.25	12812.44	8507.0
2022-10-14 01:00:00	NQ	Futures	12810.71	12825.65	12794.05	12806.98	6393.0
2022-10-14 02:00:00	NQ	Futures	12806.11	12852.66	12787.15	12819.04	10678.0
2022-10-14 03:00:00	NQ	Futures	12818.18	12821.92	12722.5	12766.46	18449.0
2022-10-14 04:00:00	NQ	Futures	12765.89	12767.9	12648.66	12655.84	17773.0
2022-10-14 05:00:00	NQ	Futures	12655.56	12696.64	12628.83	12690.9	16910.0
2022-10-14 06:00:00	NQ	Futures	12691.18	12789.16	12685.73	12771.06	20451.0
2022-10-14 07:00:00	NQ	Futures	12771.64	12786.0	12673.66	12674.52	18753.0
2022-10-14 08:00:00	NQ	Futures	12674.52	12933.69	12673.08	12895.19	50339.0
2022-10-14 09:00:00	NQ	Futures	12895.19	12902.66	12677.68	12700.38	121456.0
2022-10-14 10:00:00	NQ	Futures	12702.39	12704.98	12473.1	12546.95	141045.0
2022-10-14 11:00:00	NQ	Futures	12547.23	12609.58	12437.48	12450.12	79983.0
2022-10-14 12:00:00	NQ	Futures	12450.69	12499.25	12393.23	12434.89	67206.0
2022-10-14 13:00:00	NQ	Futures	12434.89	12473.39	12405.01	12470.52	44880.0
2022-10-14 14:00:00	NQ	Futures	12471.09	12471.67	12374.84	12412.77	52771.0
2022-10-14 15:00:00	NQ	Futures	12413.05	12440.64	12328.29	12352.71	91080.0
2022-10-14 16:00:00	NQ	Futures	12352.43	12373.4	12345.24	12350.7	19634.0
2022-10-14 00:00:00	YM	Futures	34001.4	34010.4	33954.3	33958.8	1170.0
2022-10-14 01:00:00	YM	Futures	33957.7	33994.7	33938.6	33958.8	1357.0
2022-10-14 02:00:00	YM	Futures	33952.1	34026.1	33916.1	33958.8	3043.0
2022-10-14 03:00:00	YM	Futures	33955.4	33966.6	33771.4	33842.1	5061.0
2022-10-14 04:00:00	YM	Futures	33842.1	33844.3	33649.1	33665.9	4375.0
2022-10-14 05:00:00	YM	Futures	33667.0	33756.8	33606.4	33748.9	7174.0
2022-10-14 06:00:00	YM	Futures	33748.9	33986.8	33735.5	33958.8	8835.0
2022-10-14 07:00:00	YM	Futures	33959.9	34007.0	33746.7	33750.1	6526.0
2022-10-14 08:00:00	YM	Futures	33752.3	34205.7	33741.1	34131.6	14279.0
2022-10-14 09:00:00	YM	Futures	34129.4	34200.1	33876.9	33975.6	40657.0
2022-10-14 10:00:00	YM	Futures	33981.2	33981.2	33451.5	33623.2	42412.0
2022-10-14 11:00:00	YM	Futures	33627.7	33742.2	33430.2	33471.7	21759.0
2022-10-14 12:00:00	YM	Futures	33471.7	33591.8	33362.9	33435.8	18455.0
2022-10-14 13:00:00	YM	Futures	33437.0	33511.0	33352.8	33491.9	11764.0
2022-10-14 14:00:00	YM	Futures	33493.1	33494.2	33274.2	33348.3	12687.0
2022-10-14 15:00:00	YM	Futures	33350.5	33500.9	33278.7	33351.7	21713.0

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

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