PREVIEW / futures_1hour / 2022-01-04

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-01-04.parquet
  size:    66 KB
  rows:    2,029

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-01-04 00:00:00	ES	Futures	5423.58	5427.54	5423.3	5426.69	5279.0
2022-01-04 01:00:00	ES	Futures	5426.69	5428.1	5424.43	5425.56	4823.0
2022-01-04 02:00:00	ES	Futures	5425.56	5426.97	5421.88	5426.97	6502.0
2022-01-04 03:00:00	ES	Futures	5426.97	5426.97	5421.32	5422.45	17052.0
2022-01-04 04:00:00	ES	Futures	5422.45	5425.84	5421.88	5425.84	8305.0
2022-01-04 05:00:00	ES	Futures	5425.84	5435.74	5425.84	5434.04	16848.0
2022-01-04 06:00:00	ES	Futures	5434.04	5438.28	5432.35	5433.48	13069.0
2022-01-04 07:00:00	ES	Futures	5433.19	5434.04	5424.14	5428.95	24287.0
2022-01-04 08:00:00	ES	Futures	5428.95	5435.46	5427.54	5432.91	29416.0
2022-01-04 09:00:00	ES	Futures	5432.63	5439.13	5428.67	5435.74	164452.0
2022-01-04 10:00:00	ES	Futures	5435.46	5436.87	5411.42	5412.83	253929.0
2022-01-04 11:00:00	ES	Futures	5412.83	5416.79	5399.26	5410.85	200467.0
2022-01-04 12:00:00	ES	Futures	5410.85	5416.51	5402.09	5403.5	82402.0
2022-01-04 13:00:00	ES	Futures	5403.22	5409.16	5389.64	5391.06	111182.0
2022-01-04 14:00:00	ES	Futures	5391.06	5411.7	5390.49	5410.0	106915.0
2022-01-04 15:00:00	ES	Futures	5410.0	5427.82	5409.44	5411.42	228202.0
2022-01-04 16:00:00	ES	Futures	5411.14	5413.11	5408.31	5411.42	41901.0
2022-01-04 18:00:00	ES	Futures	5411.14	5412.27	5403.78	5405.2	7601.0
2022-01-04 19:00:00	ES	Futures	5405.2	5406.33	5400.67	5403.5	8143.0
2022-01-04 20:00:00	ES	Futures	5403.78	5408.59	5395.3	5398.41	11431.0
2022-01-04 21:00:00	ES	Futures	5398.41	5401.8	5397.28	5400.11	7446.0
2022-01-04 22:00:00	ES	Futures	5400.11	5401.24	5397.28	5400.11	4258.0
2022-01-04 23:00:00	ES	Futures	5400.11	5400.67	5397.28	5399.26	2965.0
2022-01-04 00:00:00	NQ	Futures	19155.46	19171.98	19153.44	19167.35	3695.0
2022-01-04 01:00:00	NQ	Futures	19167.93	19176.62	19158.65	19164.45	2521.0
2022-01-04 02:00:00	NQ	Futures	19164.16	19175.75	19151.7	19175.46	2674.0
2022-01-04 03:00:00	NQ	Futures	19174.59	19175.75	19109.67	19115.47	9226.0
2022-01-04 04:00:00	NQ	Futures	19115.18	19151.7	19111.7	19149.96	4145.0
2022-01-04 05:00:00	NQ	Futures	19149.67	19185.03	19149.67	19180.97	5887.0
2022-01-04 06:00:00	NQ	Futures	19180.39	19202.13	19170.54	19171.98	5864.0
2022-01-04 07:00:00	NQ	Futures	19171.98	19176.04	19117.79	19145.9	10006.0
2022-01-04 08:00:00	NQ	Futures	19146.19	19165.61	19131.99	19154.89	11714.0
2022-01-04 09:00:00	NQ	Futures	19154.6	19159.52	19062.72	19082.43	85357.0
2022-01-04 10:00:00	NQ	Futures	19082.43	19087.36	18805.66	18810.58	146947.0
2022-01-04 11:00:00	NQ	Futures	18811.16	18838.98	18736.68	18785.95	105813.0
2022-01-04 12:00:00	NQ	Futures	18785.66	18816.67	18750.88	18759.28	52813.0
2022-01-04 13:00:00	NQ	Futures	18758.99	18805.95	18710.02	18716.97	55765.0
2022-01-04 14:00:00	NQ	Futures	18716.68	18813.77	18712.91	18807.97	46349.0
2022-01-04 15:00:00	NQ	Futures	18807.97	18923.9	18805.66	18863.62	85637.0
2022-01-04 16:00:00	NQ	Futures	18864.78	18867.1	18839.85	18851.16	12493.0
2022-01-04 18:00:00	NQ	Futures	18855.5	18860.14	18812.61	18817.54	4451.0
2022-01-04 19:00:00	NQ	Futures	18817.83	18825.36	18805.66	18817.25	3694.0
2022-01-04 20:00:00	NQ	Futures	18817.25	18843.33	18777.25	18787.11	6299.0
2022-01-04 21:00:00	NQ	Futures	18787.69	18804.5	18783.34	18801.6	3849.0
2022-01-04 22:00:00	NQ	Futures	18801.6	18805.66	18789.72	18797.54	1897.0
2022-01-04 23:00:00	NQ	Futures	18798.41	18800.44	18779.28	18785.95	1861.0
2022-01-04 00:00:00	YM	Futures	41023.2	41052.4	41023.2	41040.1	1212.0
2022-01-04 01:00:00	YM	Futures	41041.2	41053.5	41022.1	41033.3	1266.0
2022-01-04 02:00:00	YM	Futures	41033.3	41036.7	41004.1	41033.3	2347.0
2022-01-04 03:00:00	YM	Futures	41033.3	41081.6	41018.7	41058.0	5500.0

> showing 50 of 2,029 rows — these rows as CSV

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