PREVIEW / futures_1hour / 2020-11-27

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-11-27.parquet
  size:    42 KB
  rows:    1,215

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
2020-11-27 00:00:00	ES	Futures	4060.53	4066.97	4058.57	4066.69	6196.0
2020-11-27 01:00:00	ES	Futures	4066.97	4070.89	4064.45	4068.09	5925.0
2020-11-27 02:00:00	ES	Futures	4068.09	4069.21	4063.89	4064.17	4469.0
2020-11-27 03:00:00	ES	Futures	4063.89	4074.25	4063.89	4073.69	12684.0
2020-11-27 04:00:00	ES	Futures	4073.97	4075.66	4068.37	4069.77	8844.0
2020-11-27 05:00:00	ES	Futures	4070.05	4072.01	4067.25	4070.33	7190.0
2020-11-27 06:00:00	ES	Futures	4070.33	4072.85	4068.93	4072.01	6863.0
2020-11-27 07:00:00	ES	Futures	4072.01	4075.37	4070.89	4075.37	10674.0
2020-11-27 08:00:00	ES	Futures	4075.37	4079.86	4073.41	4076.78	19291.0
2020-11-27 09:00:00	ES	Futures	4077.06	4080.42	4073.41	4075.09	94633.0
2020-11-27 10:00:00	ES	Futures	4075.37	4081.26	4074.25	4078.74	85426.0
2020-11-27 11:00:00	ES	Futures	4079.02	4080.42	4069.49	4072.01	92271.0
2020-11-27 12:00:00	ES	Futures	4072.29	4075.66	4062.77	4074.81	95720.0
2020-11-27 13:00:00	ES	Futures	4074.81	4075.94	4071.73	4074.81	18650.0
2020-11-27 00:00:00	NQ	Futures	14092.2	14108.99	14086.7	14108.99	2874.0
2020-11-27 01:00:00	NQ	Futures	14108.99	14122.31	14103.78	14111.89	2541.0
2020-11-27 02:00:00	NQ	Futures	14112.18	14119.7	14106.39	14108.13	2034.0
2020-11-27 03:00:00	NQ	Futures	14108.7	14130.41	14107.84	14126.07	4076.0
2020-11-27 04:00:00	NQ	Futures	14126.36	14133.89	14115.65	14119.13	3063.0
2020-11-27 05:00:00	NQ	Futures	14118.84	14125.2	14106.39	14121.44	3313.0
2020-11-27 06:00:00	NQ	Futures	14121.44	14127.23	14115.65	14121.15	2179.0
2020-11-27 07:00:00	NQ	Futures	14120.28	14131.28	14115.65	14128.68	3301.0
2020-11-27 08:00:00	NQ	Futures	14128.97	14172.39	14123.76	14161.97	9536.0
2020-11-27 09:00:00	NQ	Futures	14162.26	14189.18	14142.86	14182.23	45521.0
2020-11-27 10:00:00	NQ	Futures	14182.52	14250.54	14173.26	14236.94	49722.0
2020-11-27 11:00:00	NQ	Futures	14236.36	14242.15	14175.57	14187.15	39976.0
2020-11-27 12:00:00	NQ	Futures	14187.15	14203.65	14163.41	14195.83	35708.0
2020-11-27 13:00:00	NQ	Futures	14195.83	14212.91	14188.89	14210.89	4998.0
2020-11-27 00:00:00	YM	Futures	32941.9	32993.9	32919.8	32992.8	1698.0
2020-11-27 01:00:00	YM	Futures	32991.7	33019.3	32969.6	33009.4	1774.0
2020-11-27 02:00:00	YM	Futures	33010.5	33013.8	32970.7	32976.2	1637.0
2020-11-27 03:00:00	YM	Futures	32975.1	33064.7	32966.3	33049.2	3313.0
2020-11-27 04:00:00	YM	Futures	33050.3	33083.4	33014.9	33031.5	2602.0
2020-11-27 05:00:00	YM	Futures	33032.6	33049.2	33014.9	33041.4	1653.0
2020-11-27 06:00:00	YM	Futures	33039.2	33055.8	33030.4	33044.8	1038.0
2020-11-27 07:00:00	YM	Futures	33044.8	33061.3	33033.7	33061.3	1193.0
2020-11-27 08:00:00	YM	Futures	33060.2	33086.8	33029.3	33055.8	3417.0
2020-11-27 09:00:00	YM	Futures	33055.8	33144.3	33021.5	33035.9	13164.0
2020-11-27 10:00:00	YM	Futures	33035.9	33082.3	33013.8	33038.1	10316.0
2020-11-27 11:00:00	YM	Futures	33037.0	33060.2	32971.8	33007.2	9117.0
2020-11-27 12:00:00	YM	Futures	33008.3	33043.6	32917.6	33031.5	10342.0
2020-11-27 13:00:00	YM	Futures	33032.6	33051.4	33002.7	33048.1	1333.0
2020-11-27 00:00:00	CL	Futures	30.56	30.56	30.45	30.49	2976.0
2020-11-27 01:00:00	CL	Futures	30.49	30.62	30.44	30.54	4022.0
2020-11-27 02:00:00	CL	Futures	30.54	30.58	30.32	30.36	8158.0
2020-11-27 03:00:00	CL	Futures	30.36	30.58	30.28	30.54	12630.0
2020-11-27 04:00:00	CL	Futures	30.54	30.81	30.54	30.77	11492.0
2020-11-27 05:00:00	CL	Futures	30.77	30.83	30.74	30.8	6590.0
2020-11-27 06:00:00	CL	Futures	30.81	30.94	30.75	30.92	7036.0
2020-11-27 07:00:00	CL	Futures	30.91	31.01	30.75	30.78	11515.0

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

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