PREVIEW / futures_1hour / 2023-04-07

all futures 1-hour files

  file:    by_date/futures_1hour/2023/2023-04-07.parquet
  size:    19 KB
  rows:    441

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
2023-04-07 00:00:00	ES	Futures	4580.21	4581.05	4579.38	4580.49	1162.0
2023-04-07 01:00:00	ES	Futures	4580.49	4581.32	4579.38	4580.77	1744.0
2023-04-07 02:00:00	ES	Futures	4580.77	4581.32	4579.1	4579.66	1389.0
2023-04-07 03:00:00	ES	Futures	4579.66	4579.94	4575.78	4577.16	2458.0
2023-04-07 04:00:00	ES	Futures	4576.89	4580.49	4576.89	4580.49	1318.0
2023-04-07 05:00:00	ES	Futures	4580.49	4582.16	4579.38	4580.77	1917.0
2023-04-07 06:00:00	ES	Futures	4580.77	4581.6	4580.21	4581.6	1734.0
2023-04-07 07:00:00	ES	Futures	4581.6	4582.71	4578.0	4578.55	4440.0
2023-04-07 08:00:00	ES	Futures	4578.55	4600.46	4571.89	4590.48	37646.0
2023-04-07 09:00:00	ES	Futures	4590.2	4596.02	4589.92	4594.64	4296.0
2023-04-07 00:00:00	NQ	Futures	14820.67	14825.17	14818.98	14821.8	730.0
2023-04-07 01:00:00	NQ	Futures	14822.08	14825.17	14817.29	14822.36	1011.0
2023-04-07 02:00:00	NQ	Futures	14822.36	14834.47	14817.57	14828.55	1542.0
2023-04-07 03:00:00	NQ	Futures	14828.83	14830.24	14813.91	14816.73	1843.0
2023-04-07 04:00:00	NQ	Futures	14816.16	14838.97	14815.6	14836.15	1871.0
2023-04-07 05:00:00	NQ	Futures	14835.31	14836.44	14827.14	14831.93	1317.0
2023-04-07 06:00:00	NQ	Futures	14831.93	14832.78	14818.7	14830.81	1532.0
2023-04-07 07:00:00	NQ	Futures	14831.09	14834.75	14800.4	14808.56	3409.0
2023-04-07 08:00:00	NQ	Futures	14808.56	14857.27	14778.15	14829.12	16357.0
2023-04-07 09:00:00	NQ	Futures	14829.68	14850.23	14828.55	14848.26	2087.0
2023-04-07 00:00:00	YM	Futures	37154.9	37161.6	37151.6	37158.3	267.0
2023-04-07 01:00:00	YM	Futures	37157.2	37160.5	37150.5	37154.9	551.0
2023-04-07 02:00:00	YM	Futures	37154.9	37157.2	37133.9	37136.2	446.0
2023-04-07 03:00:00	YM	Futures	37136.2	37136.2	37112.9	37127.3	751.0
2023-04-07 04:00:00	YM	Futures	37127.3	37139.5	37121.8	37139.5	386.0
2023-04-07 05:00:00	YM	Futures	37140.6	37162.7	37140.6	37157.2	461.0
2023-04-07 06:00:00	YM	Futures	37157.2	37172.6	37154.9	37164.9	473.0
2023-04-07 07:00:00	YM	Futures	37163.8	37184.8	37154.9	37163.8	1045.0
2023-04-07 08:00:00	YM	Futures	37163.8	37330.7	37124.0	37244.5	6075.0
2023-04-07 09:00:00	YM	Futures	37244.5	37279.8	37243.4	37274.3	615.0
2023-04-07 00:00:00	ZN	Futures	119.374281	119.390309	119.374281	119.374281	485.0
2023-04-07 01:00:00	ZN	Futures	119.374281	119.390309	119.374281	119.374281	842.0
2023-04-07 02:00:00	ZN	Futures	119.374281	119.422364	119.374281	119.390309	2565.0
2023-04-07 03:00:00	ZN	Futures	119.406336	119.406336	119.31017	119.342226	5703.0
2023-04-07 04:00:00	ZN	Futures	119.326198	119.422364	119.326198	119.422364	3315.0
2023-04-07 05:00:00	ZN	Futures	119.422364	119.438392	119.406336	119.438392	2285.0
2023-04-07 06:00:00	ZN	Futures	119.438392	119.502503	119.422364	119.486475	5398.0
2023-04-07 07:00:00	ZN	Futures	119.486475	119.486475	119.406336	119.422364	14331.0
2023-04-07 08:00:00	ZN	Futures	119.438392	119.438392	118.701118	119.069755	150925.0
2023-04-07 09:00:00	ZN	Futures	119.069755	119.069755	118.813312	118.845367	64661.0
2023-04-07 10:00:00	ZN	Futures	118.845367	118.861395	118.765229	118.765229	32773.0
2023-04-07 11:00:00	ZN	Futures	118.781256	118.781256	118.733173	118.733173	10604.0

> showing 42 of 441 rows — these rows as CSV

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