PREVIEW / futures_1hour / 2020-11-25

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-11-25.parquet
  size:    59 KB
  rows:    1,834

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-25 00:00:00	ES	Futures	4079.3	4080.42	4069.21	4069.77	12683.0
2020-11-25 01:00:00	ES	Futures	4070.05	4074.81	4069.49	4072.29	6942.0
2020-11-25 02:00:00	ES	Futures	4072.57	4079.3	4072.29	4079.02	6528.0
2020-11-25 03:00:00	ES	Futures	4079.3	4081.82	4068.37	4069.49	19101.0
2020-11-25 04:00:00	ES	Futures	4069.49	4074.81	4062.21	4069.49	18034.0
2020-11-25 05:00:00	ES	Futures	4069.77	4070.89	4060.81	4062.49	16922.0
2020-11-25 06:00:00	ES	Futures	4062.21	4069.49	4061.37	4066.97	12322.0
2020-11-25 07:00:00	ES	Futures	4067.25	4073.97	4063.05	4065.85	16847.0
2020-11-25 08:00:00	ES	Futures	4065.85	4071.45	4061.93	4066.97	27014.0
2020-11-25 09:00:00	ES	Futures	4066.69	4070.61	4054.37	4058.01	138734.0
2020-11-25 10:00:00	ES	Futures	4057.73	4061.93	4050.45	4056.89	145843.0
2020-11-25 11:00:00	ES	Futures	4057.17	4061.37	4051.85	4058.01	77862.0
2020-11-25 12:00:00	ES	Futures	4058.01	4064.45	4056.05	4063.89	45988.0
2020-11-25 13:00:00	ES	Futures	4064.17	4066.41	4058.01	4063.89	51366.0
2020-11-25 14:00:00	ES	Futures	4064.45	4064.45	4055.21	4061.37	79798.0
2020-11-25 15:00:00	ES	Futures	4061.65	4069.21	4060.53	4063.89	196027.0
2020-11-25 16:00:00	ES	Futures	4063.89	4067.25	4060.53	4065.85	45156.0
2020-11-25 18:00:00	ES	Futures	4067.25	4070.05	4065.85	4069.21	3440.0
2020-11-25 19:00:00	ES	Futures	4069.49	4072.57	4062.77	4068.93	5748.0
2020-11-25 20:00:00	ES	Futures	4068.93	4075.37	4068.37	4073.69	4817.0
2020-11-25 21:00:00	ES	Futures	4073.69	4075.37	4071.73	4073.97	3433.0
2020-11-25 22:00:00	ES	Futures	4073.69	4074.25	4065.29	4067.81	4592.0
2020-11-25 23:00:00	ES	Futures	4067.53	4068.65	4065.57	4067.25	2521.0
2020-11-25 00:00:00	NQ	Futures	14047.05	14049.36	14014.92	14018.1	6292.0
2020-11-25 01:00:00	NQ	Futures	14018.97	14031.71	14010.57	14023.89	4042.0
2020-11-25 02:00:00	NQ	Futures	14023.31	14040.1	14016.65	14036.63	4944.0
2020-11-25 03:00:00	NQ	Futures	14036.05	14044.73	14011.73	14016.36	7330.0
2020-11-25 04:00:00	NQ	Futures	14016.36	14033.73	14002.47	14027.94	6148.0
2020-11-25 05:00:00	NQ	Futures	14028.52	14029.39	13999.86	14008.26	4493.0
2020-11-25 06:00:00	NQ	Futures	14008.26	14021.86	13999.86	14016.65	4705.0
2020-11-25 07:00:00	NQ	Futures	14016.94	14038.36	14001.31	14008.26	5188.0
2020-11-25 08:00:00	NQ	Futures	14008.26	14034.31	13984.23	14016.65	11004.0
2020-11-25 09:00:00	NQ	Futures	14016.36	14062.68	14009.42	14039.23	57830.0
2020-11-25 10:00:00	NQ	Futures	14039.23	14043.0	13985.1	14027.65	61537.0
2020-11-25 11:00:00	NQ	Futures	14027.65	14049.65	13995.23	14010.0	39716.0
2020-11-25 12:00:00	NQ	Futures	14010.29	14057.76	14001.31	14052.55	24841.0
2020-11-25 13:00:00	NQ	Futures	14052.84	14070.49	14032.0	14057.47	23073.0
2020-11-25 14:00:00	NQ	Futures	14057.18	14069.63	14028.81	14065.86	27490.0
2020-11-25 15:00:00	NQ	Futures	14066.15	14096.84	14055.15	14072.23	54711.0
2020-11-25 16:00:00	NQ	Futures	14072.52	14100.31	14065.86	14089.89	10196.0
2020-11-25 18:00:00	NQ	Futures	14089.31	14111.02	14089.31	14103.2	2210.0
2020-11-25 19:00:00	NQ	Futures	14103.78	14107.55	14087.86	14101.76	2525.0
2020-11-25 20:00:00	NQ	Futures	14100.89	14126.07	14098.86	14120.28	2975.0
2020-11-25 21:00:00	NQ	Futures	14120.57	14141.12	14119.13	14134.18	2982.0
2020-11-25 22:00:00	NQ	Futures	14134.47	14135.05	14109.57	14115.65	2329.0
2020-11-25 23:00:00	NQ	Futures	14115.65	14120.57	14113.05	14117.97	1489.0
2020-11-25 00:00:00	YM	Futures	33219.4	33232.7	33132.1	33137.6	3891.0
2020-11-25 01:00:00	YM	Futures	33137.6	33178.5	33137.6	33164.2	1744.0
2020-11-25 02:00:00	YM	Futures	33161.9	33223.9	33161.9	33222.8	2046.0
2020-11-25 03:00:00	YM	Futures	33221.7	33237.1	33133.2	33145.4	5931.0

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

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