PREVIEW / futures_1hour / 2021-10-19

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-10-19.parquet
  size:    66 KB
  rows:    2,026

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-10-19 00:00:00	ES	Futures	5054.99	5055.55	5052.73	5054.42	2655.0
2021-10-19 01:00:00	ES	Futures	5054.42	5060.07	5053.3	5060.07	4478.0
2021-10-19 02:00:00	ES	Futures	5059.79	5067.69	5058.09	5067.41	13663.0
2021-10-19 03:00:00	ES	Futures	5067.41	5067.41	5059.22	5063.74	15309.0
2021-10-19 04:00:00	ES	Futures	5063.45	5072.77	5062.33	5068.82	16097.0
2021-10-19 05:00:00	ES	Futures	5068.82	5073.61	5066.28	5071.64	10665.0
2021-10-19 06:00:00	ES	Futures	5071.64	5081.52	5070.79	5080.11	18573.0
2021-10-19 07:00:00	ES	Futures	5080.11	5084.9	5077.85	5080.11	20843.0
2021-10-19 08:00:00	ES	Futures	5080.11	5080.39	5072.2	5072.2	20927.0
2021-10-19 09:00:00	ES	Futures	5072.2	5076.72	5065.43	5069.38	165217.0
2021-10-19 10:00:00	ES	Futures	5069.66	5084.34	5068.82	5083.21	145629.0
2021-10-19 11:00:00	ES	Futures	5083.21	5088.57	5082.93	5087.44	102817.0
2021-10-19 12:00:00	ES	Futures	5087.44	5091.39	5084.9	5090.83	56949.0
2021-10-19 13:00:00	ES	Futures	5091.11	5091.39	5086.88	5089.42	51988.0
2021-10-19 14:00:00	ES	Futures	5089.42	5090.27	5080.39	5084.62	77460.0
2021-10-19 15:00:00	ES	Futures	5084.62	5093.65	5083.77	5093.09	156696.0
2021-10-19 16:00:00	ES	Futures	5093.09	5099.58	5091.96	5097.04	61467.0
2021-10-19 18:00:00	ES	Futures	5097.88	5097.88	5091.96	5093.93	5958.0
2021-10-19 19:00:00	ES	Futures	5093.93	5098.73	5092.8	5097.6	4950.0
2021-10-19 20:00:00	ES	Futures	5097.6	5099.3	5091.11	5093.37	9404.0
2021-10-19 21:00:00	ES	Futures	5093.37	5094.22	5089.14	5091.68	8955.0
2021-10-19 22:00:00	ES	Futures	5091.68	5092.24	5087.73	5089.42	5111.0
2021-10-19 23:00:00	ES	Futures	5089.7	5093.37	5088.29	5092.8	3952.0
2021-10-19 00:00:00	NQ	Futures	17728.12	17728.98	17717.68	17722.9	1756.0
2021-10-19 01:00:00	NQ	Futures	17722.03	17747.24	17714.49	17743.48	3161.0
2021-10-19 02:00:00	NQ	Futures	17742.32	17774.78	17737.1	17769.27	7363.0
2021-10-19 03:00:00	NQ	Futures	17769.56	17769.85	17733.62	17750.14	7303.0
2021-10-19 04:00:00	NQ	Futures	17749.85	17783.18	17742.03	17766.95	9122.0
2021-10-19 05:00:00	NQ	Futures	17766.66	17782.6	17757.39	17774.78	3694.0
2021-10-19 06:00:00	NQ	Futures	17774.78	17799.41	17767.24	17795.06	5398.0
2021-10-19 07:00:00	NQ	Futures	17795.06	17815.35	17786.66	17802.6	8052.0
2021-10-19 08:00:00	NQ	Futures	17802.31	17806.37	17768.4	17770.43	10461.0
2021-10-19 09:00:00	NQ	Futures	17770.43	17803.76	17739.13	17763.18	80327.0
2021-10-19 10:00:00	NQ	Futures	17763.47	17825.49	17750.14	17824.62	64148.0
2021-10-19 11:00:00	NQ	Futures	17824.62	17837.38	17806.08	17832.74	33599.0
2021-10-19 12:00:00	NQ	Futures	17833.03	17846.94	17822.89	17844.33	19823.0
2021-10-19 13:00:00	NQ	Futures	17844.33	17849.26	17832.45	17846.65	17975.0
2021-10-19 14:00:00	NQ	Futures	17846.07	17851.0	17809.26	17824.91	23196.0
2021-10-19 15:00:00	NQ	Futures	17824.91	17857.08	17820.28	17852.74	43072.0
2021-10-19 16:00:00	NQ	Futures	17853.03	17885.49	17848.68	17865.2	15225.0
2021-10-19 18:00:00	NQ	Futures	17865.49	17867.52	17842.59	17855.06	3756.0
2021-10-19 19:00:00	NQ	Futures	17855.06	17870.13	17851.87	17863.46	2506.0
2021-10-19 20:00:00	NQ	Futures	17863.46	17868.68	17824.91	17827.52	6679.0
2021-10-19 21:00:00	NQ	Futures	17828.1	17839.69	17819.41	17825.2	4338.0
2021-10-19 22:00:00	NQ	Futures	17824.62	17833.9	17813.61	17830.42	3491.0
2021-10-19 23:00:00	NQ	Futures	17830.13	17841.14	17826.36	17838.25	2335.0
2021-10-19 00:00:00	YM	Futures	39368.5	39373.0	39349.5	39361.8	452.0
2021-10-19 01:00:00	YM	Futures	39362.9	39402.1	39355.1	39401.0	927.0
2021-10-19 02:00:00	YM	Futures	39401.0	39468.3	39386.4	39463.8	3704.0
2021-10-19 03:00:00	YM	Futures	39463.8	39463.8	39408.9	39438.0	3825.0

> showing 50 of 2,026 rows — these rows as CSV

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