PREVIEW / futures_1hour / 2022-10-07

all futures 1-hour files

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

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-07 00:00:00	ES	Futures	4230.94	4232.91	4224.18	4225.02	5407.0
2022-10-07 01:00:00	ES	Futures	4225.02	4231.79	4221.64	4226.99	9265.0
2022-10-07 02:00:00	ES	Futures	4226.71	4230.1	4208.39	4216.28	20553.0
2022-10-07 03:00:00	ES	Futures	4216.28	4233.48	4213.75	4223.89	27865.0
2022-10-07 04:00:00	ES	Futures	4223.61	4231.22	4217.97	4230.94	16793.0
2022-10-07 05:00:00	ES	Futures	4230.66	4240.53	4229.53	4237.71	12690.0
2022-10-07 06:00:00	ES	Futures	4237.71	4238.83	4227.56	4234.04	12762.0
2022-10-07 07:00:00	ES	Futures	4234.04	4239.12	4230.94	4234.89	33267.0
2022-10-07 08:00:00	ES	Futures	4234.89	4251.52	4172.31	4188.38	171635.0
2022-10-07 09:00:00	ES	Futures	4188.38	4197.96	4145.53	4147.5	334866.0
2022-10-07 10:00:00	ES	Futures	4147.5	4166.11	4139.04	4158.21	321998.0
2022-10-07 11:00:00	ES	Futures	4158.21	4165.54	4139.89	4144.68	198331.0
2022-10-07 12:00:00	ES	Futures	4144.68	4150.88	4123.82	4128.05	173295.0
2022-10-07 13:00:00	ES	Futures	4128.33	4134.53	4120.16	4123.82	137291.0
2022-10-07 14:00:00	ES	Futures	4123.82	4128.61	4110.85	4116.49	153034.0
2022-10-07 15:00:00	ES	Futures	4116.49	4124.95	4095.91	4117.06	399998.0
2022-10-07 16:00:00	ES	Futures	4116.77	4118.75	4111.7	4116.49	67245.0
2022-10-07 00:00:00	NQ	Futures	13251.18	13260.38	13223.02	13227.05	3220.0
2022-10-07 01:00:00	NQ	Futures	13226.76	13248.6	13214.69	13233.08	4749.0
2022-10-07 02:00:00	NQ	Futures	13232.22	13242.28	13162.69	13194.29	11033.0
2022-10-07 03:00:00	NQ	Futures	13193.43	13245.72	13184.24	13199.18	13989.0
2022-10-07 04:00:00	NQ	Futures	13200.04	13221.88	13177.63	13218.14	9876.0
2022-10-07 05:00:00	NQ	Futures	13218.14	13249.75	13212.68	13235.09	6836.0
2022-10-07 06:00:00	NQ	Futures	13234.23	13237.97	13196.3	13218.43	7480.0
2022-10-07 07:00:00	NQ	Futures	13217.85	13235.95	13209.81	13219.0	7669.0
2022-10-07 08:00:00	NQ	Futures	13219.29	13267.56	12987.7	13047.76	68249.0
2022-10-07 09:00:00	NQ	Futures	13048.04	13077.64	12891.16	12901.51	117189.0
2022-10-07 10:00:00	NQ	Futures	12901.79	12959.26	12877.37	12914.15	105700.0
2022-10-07 11:00:00	NQ	Futures	12914.44	12937.14	12833.7	12858.12	73871.0
2022-10-07 12:00:00	NQ	Futures	12857.83	12875.94	12783.13	12799.79	59458.0
2022-10-07 13:00:00	NQ	Futures	12800.37	12819.04	12767.33	12773.65	49791.0
2022-10-07 14:00:00	NQ	Futures	12774.22	12796.06	12742.62	12766.75	52584.0
2022-10-07 15:00:00	NQ	Futures	12767.04	12797.5	12692.05	12756.69	110992.0
2022-10-07 16:00:00	NQ	Futures	12756.12	12764.74	12742.04	12752.96	18989.0
2022-10-07 00:00:00	YM	Futures	33626.6	33635.6	33573.9	33580.6	685.0
2022-10-07 01:00:00	YM	Futures	33580.6	33628.9	33562.6	33604.2	867.0
2022-10-07 02:00:00	YM	Futures	33600.8	33619.9	33475.1	33522.2	2467.0
2022-10-07 03:00:00	YM	Futures	33523.4	33661.4	33504.3	33594.1	3008.0
2022-10-07 04:00:00	YM	Futures	33591.8	33661.4	33562.6	33655.8	2029.0
2022-10-07 05:00:00	YM	Futures	33658.0	33731.0	33645.7	33715.3	2358.0
2022-10-07 06:00:00	YM	Futures	33715.3	33722.0	33645.7	33686.1	1910.0
2022-10-07 07:00:00	YM	Futures	33687.2	33725.4	33664.8	33697.3	1970.0
2022-10-07 08:00:00	YM	Futures	33699.6	33791.6	33263.0	33371.9	20360.0
2022-10-07 09:00:00	YM	Futures	33370.7	33437.0	33087.9	33099.2	29432.0
2022-10-07 10:00:00	YM	Futures	33103.6	33239.4	33035.2	33175.5	21669.0
2022-10-07 11:00:00	YM	Futures	33174.3	33223.7	33058.8	33096.9	12290.0
2022-10-07 12:00:00	YM	Futures	33095.8	33155.3	32962.2	32994.8	11222.0
2022-10-07 13:00:00	YM	Futures	32995.9	33039.7	32944.3	32966.7	7684.0
2022-10-07 14:00:00	YM	Futures	32966.7	32995.9	32843.3	32892.7	9259.0
2022-10-07 15:00:00	YM	Futures	32892.7	32971.2	32755.8	32926.3	20713.0

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

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