PREVIEW / futures_1hour / 2021-10-21

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-10-21.parquet
  size:    67 KB
  rows:    2,019

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-21 00:00:00	ES	Futures	5103.81	5105.22	5097.88	5100.99	8965.0
2021-10-21 01:00:00	ES	Futures	5100.99	5100.99	5094.22	5097.32	8730.0
2021-10-21 02:00:00	ES	Futures	5097.32	5101.27	5092.52	5094.5	9180.0
2021-10-21 03:00:00	ES	Futures	5094.22	5102.4	5091.39	5100.14	20935.0
2021-10-21 04:00:00	ES	Futures	5100.14	5100.99	5095.34	5097.32	10205.0
2021-10-21 05:00:00	ES	Futures	5097.32	5101.27	5096.76	5101.27	7717.0
2021-10-21 06:00:00	ES	Futures	5100.99	5102.12	5095.91	5096.76	8851.0
2021-10-21 07:00:00	ES	Futures	5096.76	5100.42	5094.78	5095.63	13760.0
2021-10-21 08:00:00	ES	Futures	5095.91	5105.22	5095.34	5100.14	23894.0
2021-10-21 09:00:00	ES	Futures	5100.42	5110.02	5098.45	5107.76	112517.0
2021-10-21 10:00:00	ES	Futures	5107.76	5117.64	5104.94	5111.43	113547.0
2021-10-21 11:00:00	ES	Futures	5111.43	5114.25	5100.42	5107.2	134186.0
2021-10-21 12:00:00	ES	Futures	5106.92	5110.87	5104.94	5108.89	73384.0
2021-10-21 13:00:00	ES	Futures	5109.17	5112.28	5104.94	5106.63	55073.0
2021-10-21 14:00:00	ES	Futures	5106.92	5113.12	5106.35	5113.12	59651.0
2021-10-21 15:00:00	ES	Futures	5113.41	5128.65	5113.12	5126.11	160926.0
2021-10-21 16:00:00	ES	Futures	5126.39	5127.8	5112.56	5115.95	61797.0
2021-10-21 18:00:00	ES	Futures	5113.69	5115.95	5110.58	5113.97	7539.0
2021-10-21 19:00:00	ES	Futures	5114.25	5116.51	5111.71	5113.41	5098.0
2021-10-21 20:00:00	ES	Futures	5113.69	5123.28	5113.12	5121.31	12353.0
2021-10-21 21:00:00	ES	Futures	5121.31	5124.69	5119.9	5122.16	8982.0
2021-10-21 22:00:00	ES	Futures	5122.16	5122.44	5118.77	5120.74	6418.0
2021-10-21 23:00:00	ES	Futures	5120.74	5124.69	5120.18	5123.57	3325.0
2021-10-21 00:00:00	NQ	Futures	17779.41	17786.37	17763.76	17773.62	4226.0
2021-10-21 01:00:00	NQ	Futures	17773.33	17773.91	17746.66	17762.02	5541.0
2021-10-21 02:00:00	NQ	Futures	17762.02	17779.7	17740.58	17749.27	5644.0
2021-10-21 03:00:00	NQ	Futures	17748.69	17806.08	17737.97	17787.24	11666.0
2021-10-21 04:00:00	NQ	Futures	17787.24	17790.43	17772.17	17785.5	4933.0
2021-10-21 05:00:00	NQ	Futures	17785.79	17808.1	17785.5	17804.92	4323.0
2021-10-21 06:00:00	NQ	Futures	17804.34	17808.39	17783.18	17786.95	4087.0
2021-10-21 07:00:00	NQ	Futures	17787.24	17797.96	17753.62	17756.81	7915.0
2021-10-21 08:00:00	NQ	Futures	17757.1	17800.28	17752.46	17781.15	14275.0
2021-10-21 09:00:00	NQ	Futures	17781.44	17846.07	17776.22	17829.84	70748.0
2021-10-21 10:00:00	NQ	Futures	17829.84	17899.4	17823.75	17885.2	62671.0
2021-10-21 11:00:00	NQ	Futures	17885.2	17905.77	17847.81	17870.42	53323.0
2021-10-21 12:00:00	NQ	Futures	17870.42	17898.82	17848.68	17893.89	35367.0
2021-10-21 13:00:00	NQ	Futures	17893.6	17896.5	17865.78	17872.44	24457.0
2021-10-21 14:00:00	NQ	Futures	17872.15	17899.69	17866.94	17899.69	24162.0
2021-10-21 15:00:00	NQ	Futures	17899.69	17949.83	17897.37	17939.97	49662.0
2021-10-21 16:00:00	NQ	Futures	17940.26	17948.09	17815.93	17831.0	31001.0
2021-10-21 18:00:00	NQ	Futures	17833.03	17859.4	17818.54	17853.03	7064.0
2021-10-21 19:00:00	NQ	Futures	17853.32	17862.01	17835.93	17843.17	4957.0
2021-10-21 20:00:00	NQ	Futures	17842.88	17875.05	17842.01	17861.14	6199.0
2021-10-21 21:00:00	NQ	Futures	17860.27	17874.76	17852.74	17853.9	4752.0
2021-10-21 22:00:00	NQ	Futures	17854.48	17856.21	17839.12	17851.58	4857.0
2021-10-21 23:00:00	NQ	Futures	17851.87	17868.39	17851.0	17862.01	2608.0
2021-10-21 00:00:00	YM	Futures	39718.2	39730.6	39666.7	39698.1	2748.0
2021-10-21 01:00:00	YM	Futures	39696.9	39696.9	39647.6	39663.3	2754.0
2021-10-21 02:00:00	YM	Futures	39662.2	39695.8	39637.5	39654.3	3972.0
2021-10-21 03:00:00	YM	Futures	39655.5	39691.3	39629.7	39673.4	5779.0

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

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