PREVIEW / futures_1hour / 2022-05-04

all futures 1-hour files

  file:    by_date/futures_1hour/2022/2022-05-04.parquet
  size:    71 KB
  rows:    2,088

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-05-04 00:00:00	ES	Futures	4730.05	4736.85	4729.77	4731.47	3895.0
2022-05-04 01:00:00	ES	Futures	4731.47	4737.42	4730.62	4736.57	4225.0
2022-05-04 02:00:00	ES	Futures	4736.57	4739.12	4730.05	4737.42	6329.0
2022-05-04 03:00:00	ES	Futures	4737.14	4742.24	4725.23	4737.42	15851.0
2022-05-04 04:00:00	ES	Futures	4737.42	4742.52	4736.29	4739.97	9960.0
2022-05-04 05:00:00	ES	Futures	4739.97	4747.06	4734.02	4746.77	11646.0
2022-05-04 06:00:00	ES	Futures	4746.49	4749.04	4742.52	4745.36	14268.0
2022-05-04 07:00:00	ES	Futures	4745.07	4751.59	4742.52	4744.79	13722.0
2022-05-04 08:00:00	ES	Futures	4745.07	4748.47	4736.29	4736.57	20796.0
2022-05-04 09:00:00	ES	Futures	4736.29	4740.25	4723.53	4723.81	131043.0
2022-05-04 10:00:00	ES	Futures	4723.53	4725.23	4703.12	4712.19	179388.0
2022-05-04 11:00:00	ES	Futures	4712.48	4720.13	4696.89	4714.18	110091.0
2022-05-04 12:00:00	ES	Futures	4714.18	4747.62	4711.06	4746.21	112597.0
2022-05-04 13:00:00	ES	Futures	4746.21	4756.41	4733.45	4746.49	110138.0
2022-05-04 14:00:00	ES	Futures	4746.49	4817.07	4701.42	4810.83	481395.0
2022-05-04 15:00:00	ES	Futures	4810.83	4878.57	4803.74	4871.49	394661.0
2022-05-04 16:00:00	ES	Futures	4871.49	4872.05	4858.17	4859.58	71455.0
2022-05-04 18:00:00	ES	Futures	4863.55	4870.64	4859.02	4860.43	8814.0
2022-05-04 19:00:00	ES	Futures	4860.15	4863.83	4858.17	4861.0	5320.0
2022-05-04 20:00:00	ES	Futures	4861.28	4867.52	4859.58	4866.38	5313.0
2022-05-04 21:00:00	ES	Futures	4866.67	4872.34	4861.28	4863.55	7939.0
2022-05-04 22:00:00	ES	Futures	4863.55	4863.83	4859.58	4860.72	4499.0
2022-05-04 23:00:00	ES	Futures	4861.0	4867.52	4861.0	4866.38	3274.0
2022-05-04 00:00:00	NQ	Futures	15194.4	15228.91	15194.4	15204.84	2878.0
2022-05-04 01:00:00	NQ	Futures	15203.68	15229.2	15199.91	15220.5	2134.0
2022-05-04 02:00:00	NQ	Futures	15221.66	15231.23	15199.33	15226.01	3208.0
2022-05-04 03:00:00	NQ	Futures	15227.17	15237.03	15171.78	15216.73	8406.0
2022-05-04 04:00:00	NQ	Futures	15217.31	15234.13	15203.68	15210.35	6664.0
2022-05-04 05:00:00	NQ	Futures	15208.61	15226.01	15186.28	15223.69	5596.0
2022-05-04 06:00:00	NQ	Futures	15223.69	15242.25	15213.54	15228.62	5916.0
2022-05-04 07:00:00	NQ	Futures	15228.33	15259.07	15217.89	15231.23	6742.0
2022-05-04 08:00:00	NQ	Futures	15231.81	15240.8	15197.3	15197.88	10461.0
2022-05-04 09:00:00	NQ	Futures	15197.88	15216.73	15098.13	15099.87	63994.0
2022-05-04 10:00:00	NQ	Futures	15099.0	15112.05	14985.04	15000.7	86822.0
2022-05-04 11:00:00	NQ	Futures	15001.57	15052.6	14942.99	15033.18	52976.0
2022-05-04 12:00:00	NQ	Futures	15031.73	15198.17	15018.97	15196.72	56709.0
2022-05-04 13:00:00	NQ	Futures	15196.43	15277.92	15158.45	15244.86	44204.0
2022-05-04 14:00:00	NQ	Futures	15245.73	15491.05	15007.66	15469.59	186067.0
2022-05-04 15:00:00	NQ	Futures	15470.17	15722.74	15436.82	15696.64	117018.0
2022-05-04 16:00:00	NQ	Futures	15696.64	15698.96	15643.57	15653.72	19590.0
2022-05-04 18:00:00	NQ	Futures	15658.94	15706.5	15658.94	15665.9	5597.0
2022-05-04 19:00:00	NQ	Futures	15667.06	15681.85	15660.1	15672.57	2435.0
2022-05-04 20:00:00	NQ	Futures	15672.86	15692.58	15662.13	15689.1	3050.0
2022-05-04 21:00:00	NQ	Futures	15689.1	15707.37	15674.6	15681.85	3647.0
2022-05-04 22:00:00	NQ	Futures	15681.85	15683.88	15666.48	15670.25	2075.0
2022-05-04 23:00:00	NQ	Futures	15671.12	15687.07	15669.09	15684.17	1522.0
2022-05-04 00:00:00	YM	Futures	37248.1	37291.0	37245.9	37260.5	704.0
2022-05-04 01:00:00	YM	Futures	37258.3	37289.8	37247.0	37285.3	631.0
2022-05-04 02:00:00	YM	Futures	37286.5	37305.6	37238.0	37282.0	1060.0
2022-05-04 03:00:00	YM	Futures	37285.3	37328.2	37205.3	37291.0	2277.0

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

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