PREVIEW / futures_1hour / 2021-09-09

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-09-09.parquet
  size:    63 KB
  rows:    1,924

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
2021-09-09 00:00:00	ES	Futures	5068.2	5068.76	5062.85	5064.26	8253.0
2021-09-09 01:00:00	ES	Futures	5063.97	5064.54	5057.78	5060.03	14037.0
2021-09-09 02:00:00	ES	Futures	5060.03	5066.79	5059.19	5061.72	12862.0
2021-09-09 03:00:00	ES	Futures	5061.44	5068.48	5052.15	5065.95	43568.0
2021-09-09 04:00:00	ES	Futures	5066.23	5072.7	5066.23	5067.35	29806.0
2021-09-09 05:00:00	ES	Futures	5067.35	5074.11	5064.26	5071.01	21339.0
2021-09-09 06:00:00	ES	Futures	5070.73	5072.14	5067.64	5068.76	13564.0
2021-09-09 07:00:00	ES	Futures	5068.76	5080.87	5065.38	5079.74	27728.0
2021-09-09 08:00:00	ES	Futures	5079.74	5083.69	5074.39	5080.59	54937.0
2021-09-09 09:00:00	ES	Futures	5080.59	5094.95	5077.49	5092.7	164165.0
2021-09-09 10:00:00	ES	Futures	5092.7	5101.71	5090.44	5093.82	165405.0
2021-09-09 11:00:00	ES	Futures	5093.82	5094.67	5080.59	5085.94	144400.0
2021-09-09 12:00:00	ES	Futures	5085.94	5086.5	5077.49	5078.9	107756.0
2021-09-09 13:00:00	ES	Futures	5078.9	5084.25	5060.88	5064.54	184025.0
2021-09-09 14:00:00	ES	Futures	5064.82	5071.3	5057.78	5070.17	132448.0
2021-09-09 15:00:00	ES	Futures	5070.17	5074.11	5058.06	5060.88	184423.0
2021-09-09 16:00:00	ES	Futures	5060.88	5063.13	5053.84	5058.06	53111.0
2021-09-09 18:00:00	ES	Futures	5058.62	5061.44	5055.81	5059.47	6352.0
2021-09-09 19:00:00	ES	Futures	5059.47	5061.16	5055.81	5058.62	3808.0
2021-09-09 20:00:00	ES	Futures	5058.62	5064.82	5057.78	5062.29	6875.0
2021-09-09 21:00:00	ES	Futures	5062.0	5067.64	5056.65	5066.23	7679.0
2021-09-09 22:00:00	ES	Futures	5066.23	5069.04	5065.1	5067.64	5930.0
2021-09-09 23:00:00	ES	Futures	5067.64	5069.89	5067.35	5068.76	3653.0
2021-09-09 00:00:00	NQ	Futures	18058.44	18059.02	18041.93	18047.43	2788.0
2021-09-09 01:00:00	NQ	Futures	18047.14	18051.78	18023.68	18028.89	5804.0
2021-09-09 02:00:00	NQ	Futures	18028.02	18054.96	18026.29	18041.06	5779.0
2021-09-09 03:00:00	NQ	Futures	18040.48	18066.84	18014.41	18059.02	13193.0
2021-09-09 04:00:00	NQ	Futures	18059.31	18067.42	18046.56	18048.59	6303.0
2021-09-09 05:00:00	NQ	Futures	18049.17	18073.5	18043.09	18062.79	5914.0
2021-09-09 06:00:00	NQ	Futures	18063.07	18071.19	18056.41	18062.5	3409.0
2021-09-09 07:00:00	NQ	Futures	18062.5	18108.27	18045.4	18102.76	11198.0
2021-09-09 08:00:00	NQ	Futures	18103.63	18115.51	18081.9	18101.02	15293.0
2021-09-09 09:00:00	NQ	Futures	18100.44	18163.88	18100.44	18144.76	66788.0
2021-09-09 10:00:00	NQ	Futures	18144.19	18163.01	18121.3	18131.15	60524.0
2021-09-09 11:00:00	NQ	Futures	18131.44	18138.68	18088.86	18110.0	59637.0
2021-09-09 12:00:00	NQ	Futures	18110.29	18121.88	18093.49	18098.13	40102.0
2021-09-09 13:00:00	NQ	Futures	18098.42	18119.56	18027.44	18052.36	77312.0
2021-09-09 14:00:00	NQ	Futures	18052.94	18077.85	18033.82	18073.21	54315.0
2021-09-09 15:00:00	NQ	Futures	18073.5	18084.51	18024.26	18034.4	54987.0
2021-09-09 16:00:00	NQ	Futures	18034.4	18038.45	18013.25	18032.66	8865.0
2021-09-09 18:00:00	NQ	Futures	18030.92	18040.19	18022.23	18032.08	2485.0
2021-09-09 19:00:00	NQ	Futures	18031.79	18038.45	18023.97	18034.11	1871.0
2021-09-09 20:00:00	NQ	Futures	18033.82	18052.94	18032.66	18039.9	3264.0
2021-09-09 21:00:00	NQ	Futures	18039.61	18055.25	18025.71	18050.33	3388.0
2021-09-09 22:00:00	NQ	Futures	18050.33	18055.54	18042.8	18048.3	2564.0
2021-09-09 23:00:00	NQ	Futures	18048.59	18057.57	18048.3	18054.96	1348.0
2021-09-09 00:00:00	YM	Futures	39010.0	39014.4	38954.1	38970.9	1543.0
2021-09-09 01:00:00	YM	Futures	38968.6	38972.0	38921.7	38947.4	2597.0
2021-09-09 02:00:00	YM	Futures	38942.9	39001.0	38937.4	38956.3	3058.0
2021-09-09 03:00:00	YM	Futures	38955.2	39003.3	38853.6	38983.2	8120.0

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

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