PREVIEW / futures_1hour / 2020-11-26

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-11-26.parquet
  size:    43 KB
  rows:    1,323

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-26 00:00:00	ES	Futures	4067.25	4074.81	4066.97	4074.81	4484.0
2020-11-26 01:00:00	ES	Futures	4074.81	4075.94	4072.01	4074.53	3613.0
2020-11-26 02:00:00	ES	Futures	4074.53	4076.78	4071.73	4073.41	4266.0
2020-11-26 03:00:00	ES	Futures	4073.41	4074.53	4065.01	4065.29	9094.0
2020-11-26 04:00:00	ES	Futures	4065.29	4070.33	4063.61	4066.41	7205.0
2020-11-26 05:00:00	ES	Futures	4066.41	4068.93	4064.45	4064.45	4723.0
2020-11-26 06:00:00	ES	Futures	4064.45	4067.81	4064.45	4066.41	4837.0
2020-11-26 07:00:00	ES	Futures	4066.13	4066.41	4060.53	4064.17	6425.0
2020-11-26 08:00:00	ES	Futures	4063.89	4066.97	4063.61	4064.73	3317.0
2020-11-26 09:00:00	ES	Futures	4065.29	4067.81	4063.05	4066.69	6332.0
2020-11-26 10:00:00	ES	Futures	4066.69	4067.81	4058.57	4063.33	10739.0
2020-11-26 11:00:00	ES	Futures	4063.33	4065.57	4060.25	4062.21	9846.0
2020-11-26 12:00:00	ES	Futures	4062.21	4062.49	4048.21	4053.25	11881.0
2020-11-26 18:00:00	ES	Futures	4056.33	4059.41	4050.73	4056.05	6717.0
2020-11-26 19:00:00	ES	Futures	4056.05	4057.17	4049.33	4055.77	7103.0
2020-11-26 20:00:00	ES	Futures	4055.77	4058.57	4052.97	4053.25	5068.0
2020-11-26 21:00:00	ES	Futures	4053.25	4054.09	4047.65	4053.81	4291.0
2020-11-26 22:00:00	ES	Futures	4053.53	4057.17	4050.73	4056.89	4240.0
2020-11-26 23:00:00	ES	Futures	4056.89	4062.77	4056.61	4060.81	4524.0
2020-11-26 00:00:00	NQ	Futures	14118.84	14132.73	14114.2	14124.63	2578.0
2020-11-26 01:00:00	NQ	Futures	14124.63	14128.39	14107.55	14126.07	2025.0
2020-11-26 02:00:00	NQ	Futures	14126.07	14126.65	14116.23	14118.26	1854.0
2020-11-26 03:00:00	NQ	Futures	14119.13	14153.28	14104.94	14111.89	5550.0
2020-11-26 04:00:00	NQ	Futures	14111.6	14120.28	14094.23	14118.84	4009.0
2020-11-26 05:00:00	NQ	Futures	14118.26	14130.7	14111.31	14113.91	3192.0
2020-11-26 06:00:00	NQ	Futures	14113.63	14126.65	14106.68	14120.57	2690.0
2020-11-26 07:00:00	NQ	Futures	14120.57	14122.89	14111.02	14120.86	2388.0
2020-11-26 08:00:00	NQ	Futures	14120.86	14129.26	14118.55	14122.31	2313.0
2020-11-26 09:00:00	NQ	Futures	14122.31	14142.86	14112.76	14120.28	5625.0
2020-11-26 10:00:00	NQ	Futures	14120.57	14120.86	14100.31	14112.76	6238.0
2020-11-26 11:00:00	NQ	Futures	14112.18	14125.49	14109.28	14111.89	4662.0
2020-11-26 12:00:00	NQ	Futures	14111.6	14113.34	14041.55	14072.52	9597.0
2020-11-26 18:00:00	NQ	Futures	14076.28	14095.68	14062.1	14074.26	3344.0
2020-11-26 19:00:00	NQ	Futures	14074.84	14083.52	14059.21	14081.78	2918.0
2020-11-26 20:00:00	NQ	Futures	14081.2	14082.36	14061.23	14063.26	2575.0
2020-11-26 21:00:00	NQ	Futures	14062.68	14072.23	14052.84	14066.15	2445.0
2020-11-26 22:00:00	NQ	Futures	14065.57	14080.05	14060.36	14078.02	2335.0
2020-11-26 23:00:00	NQ	Futures	14078.6	14097.7	14078.02	14092.49	2891.0
2020-11-26 00:00:00	YM	Futures	32995.0	33049.2	32991.7	33049.2	1277.0
2020-11-26 01:00:00	YM	Futures	33050.3	33062.4	33026.0	33048.1	1063.0
2020-11-26 02:00:00	YM	Futures	33049.2	33058.0	33020.4	33034.8	1443.0
2020-11-26 03:00:00	YM	Futures	33035.9	33042.5	32983.9	32983.9	2976.0
2020-11-26 04:00:00	YM	Futures	32985.0	33017.1	32967.4	32987.3	2102.0
2020-11-26 05:00:00	YM	Futures	32987.3	33005.0	32978.4	32978.4	1146.0
2020-11-26 06:00:00	YM	Futures	32979.5	32997.2	32964.0	32971.8	1028.0
2020-11-26 07:00:00	YM	Futures	32974.0	32975.1	32928.7	32956.3	1774.0
2020-11-26 08:00:00	YM	Futures	32956.3	32977.3	32954.1	32969.6	926.0
2020-11-26 09:00:00	YM	Futures	32969.6	33002.7	32960.7	32988.4	1731.0
2020-11-26 10:00:00	YM	Futures	32990.6	33010.5	32929.8	32956.3	2445.0
2020-11-26 11:00:00	YM	Futures	32957.4	32979.5	32948.6	32969.6	1777.0

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

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