PREVIEW / futures_1hour / 2021-09-08

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-09-08.parquet
  size:    62 KB
  rows:    1,939

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-08 00:00:00	ES	Futures	5089.6	5091.57	5088.75	5090.72	3046.0
2021-09-08 01:00:00	ES	Futures	5090.72	5093.82	5088.75	5093.54	6193.0
2021-09-08 02:00:00	ES	Futures	5093.54	5094.67	5085.66	5086.5	9081.0
2021-09-08 03:00:00	ES	Futures	5086.78	5087.06	5068.48	5072.42	61325.0
2021-09-08 04:00:00	ES	Futures	5072.14	5077.21	5065.1	5073.27	43058.0
2021-09-08 05:00:00	ES	Futures	5073.55	5085.37	5072.42	5084.81	22338.0
2021-09-08 06:00:00	ES	Futures	5084.81	5089.88	5083.4	5086.5	19155.0
2021-09-08 07:00:00	ES	Futures	5086.22	5092.7	5086.22	5087.91	19838.0
2021-09-08 08:00:00	ES	Futures	5087.63	5090.16	5081.43	5087.35	61277.0
2021-09-08 09:00:00	ES	Futures	5087.06	5088.47	5076.36	5086.5	147248.0
2021-09-08 10:00:00	ES	Futures	5086.78	5091.29	5059.47	5065.95	288399.0
2021-09-08 11:00:00	ES	Futures	5065.95	5076.65	5062.85	5065.38	218303.0
2021-09-08 12:00:00	ES	Futures	5065.1	5082.28	5062.85	5075.24	146282.0
2021-09-08 13:00:00	ES	Futures	5075.24	5080.87	5072.99	5075.8	84851.0
2021-09-08 14:00:00	ES	Futures	5076.08	5083.97	5075.8	5080.87	100247.0
2021-09-08 15:00:00	ES	Futures	5081.15	5085.09	5076.93	5083.12	141956.0
2021-09-08 16:00:00	ES	Futures	5083.4	5083.4	5080.31	5081.15	44181.0
2021-09-08 18:00:00	ES	Futures	5080.87	5081.71	5077.21	5077.77	4673.0
2021-09-08 19:00:00	ES	Futures	5077.77	5079.18	5075.52	5076.93	4328.0
2021-09-08 20:00:00	ES	Futures	5077.21	5080.02	5070.17	5071.58	10785.0
2021-09-08 21:00:00	ES	Futures	5071.58	5075.24	5069.32	5073.55	9983.0
2021-09-08 22:00:00	ES	Futures	5073.27	5076.08	5070.73	5072.42	5987.0
2021-09-08 23:00:00	ES	Futures	5072.42	5073.55	5065.1	5068.2	7696.0
2021-09-08 00:00:00	NQ	Futures	18165.33	18170.55	18161.28	18162.73	1651.0
2021-09-08 01:00:00	NQ	Futures	18162.73	18168.81	18155.48	18165.91	2465.0
2021-09-08 02:00:00	NQ	Futures	18165.62	18174.89	18150.27	18154.32	3555.0
2021-09-08 03:00:00	NQ	Futures	18154.03	18158.09	18082.19	18106.82	18267.0
2021-09-08 04:00:00	NQ	Futures	18107.11	18127.96	18089.44	18118.69	11310.0
2021-09-08 05:00:00	NQ	Futures	18118.69	18152.3	18115.22	18147.95	6730.0
2021-09-08 06:00:00	NQ	Futures	18148.53	18157.8	18143.9	18145.92	5424.0
2021-09-08 07:00:00	NQ	Futures	18145.63	18167.65	18145.34	18156.06	6723.0
2021-09-08 08:00:00	NQ	Futures	18156.06	18165.91	18140.71	18156.64	11266.0
2021-09-08 09:00:00	NQ	Futures	18156.35	18159.54	18090.02	18116.38	67426.0
2021-09-08 10:00:00	NQ	Futures	18116.67	18144.19	18000.21	18018.46	116104.0
2021-09-08 11:00:00	NQ	Futures	18018.46	18066.55	17993.26	18009.19	86073.0
2021-09-08 12:00:00	NQ	Futures	18008.9	18081.9	17987.76	18049.17	65616.0
2021-09-08 13:00:00	NQ	Futures	18049.17	18091.46	18047.72	18066.84	40598.0
2021-09-08 14:00:00	NQ	Futures	18067.13	18105.95	18066.26	18080.17	38383.0
2021-09-08 15:00:00	NQ	Futures	18080.46	18103.92	18066.26	18102.47	44947.0
2021-09-08 16:00:00	NQ	Futures	18102.47	18102.76	18084.22	18087.41	8355.0
2021-09-08 18:00:00	NQ	Futures	18087.7	18091.46	18074.66	18075.53	1999.0
2021-09-08 19:00:00	NQ	Futures	18075.24	18080.17	18067.42	18076.11	2312.0
2021-09-08 20:00:00	NQ	Futures	18076.11	18086.83	18055.83	18061.92	4417.0
2021-09-08 21:00:00	NQ	Futures	18061.63	18073.79	18054.67	18070.32	4347.0
2021-09-08 22:00:00	NQ	Futures	18069.74	18078.43	18063.94	18068.87	2654.0
2021-09-08 23:00:00	NQ	Futures	18068.87	18073.79	18043.38	18057.86	3921.0
2021-09-08 00:00:00	YM	Futures	39195.4	39215.5	39191.0	39212.2	636.0
2021-09-08 01:00:00	YM	Futures	39212.2	39246.8	39199.9	39245.7	1132.0
2021-09-08 02:00:00	YM	Futures	39244.6	39249.1	39155.2	39163.0	2638.0
2021-09-08 03:00:00	YM	Futures	39161.9	39164.2	39004.4	39035.7	11466.0

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

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