PREVIEW / futures_1hour / 2021-07-20

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-07-20.parquet
  size:    66 KB
  rows:    1,996

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-07-20 00:00:00	ES	Futures	4798.44	4800.98	4792.53	4800.13	9650.0
2021-07-20 01:00:00	ES	Futures	4800.13	4804.07	4796.75	4803.23	9508.0
2021-07-20 02:00:00	ES	Futures	4803.51	4810.83	4802.1	4810.27	13022.0
2021-07-20 03:00:00	ES	Futures	4809.99	4819.84	4806.61	4810.83	49640.0
2021-07-20 04:00:00	ES	Futures	4810.83	4819.0	4809.14	4812.8	22699.0
2021-07-20 05:00:00	ES	Futures	4812.52	4815.62	4801.54	4804.92	28328.0
2021-07-20 06:00:00	ES	Futures	4804.92	4815.06	4800.98	4811.11	30845.0
2021-07-20 07:00:00	ES	Futures	4810.83	4816.75	4805.48	4814.49	31399.0
2021-07-20 08:00:00	ES	Futures	4814.49	4817.59	4802.95	4805.2	59885.0
2021-07-20 09:00:00	ES	Futures	4804.92	4830.26	4790.0	4828.57	292230.0
2021-07-20 10:00:00	ES	Futures	4828.57	4851.66	4825.19	4851.38	275368.0
2021-07-20 11:00:00	ES	Futures	4851.1	4861.8	4846.87	4861.52	164063.0
2021-07-20 12:00:00	ES	Futures	4861.52	4871.37	4858.14	4871.37	137639.0
2021-07-20 13:00:00	ES	Futures	4871.37	4872.22	4857.01	4860.95	143313.0
2021-07-20 14:00:00	ES	Futures	4860.95	4870.25	4860.67	4865.74	119215.0
2021-07-20 15:00:00	ES	Futures	4866.02	4875.88	4859.55	4859.83	279417.0
2021-07-20 16:00:00	ES	Futures	4860.11	4866.3	4859.26	4864.61	75711.0
2021-07-20 18:00:00	ES	Futures	4864.33	4869.12	4863.77	4868.27	4889.0
2021-07-20 19:00:00	ES	Futures	4868.27	4872.78	4867.43	4870.81	5091.0
2021-07-20 20:00:00	ES	Futures	4870.81	4873.63	4864.9	4871.65	10756.0
2021-07-20 21:00:00	ES	Futures	4871.65	4871.65	4864.33	4866.3	9340.0
2021-07-20 22:00:00	ES	Futures	4866.02	4866.3	4854.48	4855.89	14732.0
2021-07-20 23:00:00	ES	Futures	4855.89	4859.83	4855.32	4858.14	6851.0
2021-07-20 00:00:00	NQ	Futures	16911.88	16925.5	16898.27	16922.6	4162.0
2021-07-20 01:00:00	NQ	Futures	16922.31	16939.11	16909.56	16935.35	3941.0
2021-07-20 02:00:00	NQ	Futures	16935.64	16960.84	16932.74	16951.86	5925.0
2021-07-20 03:00:00	NQ	Futures	16951.86	16967.21	16913.91	16914.78	11133.0
2021-07-20 04:00:00	NQ	Futures	16914.49	16944.91	16912.17	16934.48	7327.0
2021-07-20 05:00:00	NQ	Futures	16934.77	16938.82	16897.11	16911.01	6874.0
2021-07-20 06:00:00	NQ	Futures	16911.3	16942.3	16900.58	16939.98	8067.0
2021-07-20 07:00:00	NQ	Futures	16940.85	16948.67	16906.09	16926.66	10604.0
2021-07-20 08:00:00	NQ	Futures	16926.37	16929.26	16907.25	16917.68	8654.0
2021-07-20 09:00:00	NQ	Futures	16917.1	16926.66	16820.92	16900.87	89893.0
2021-07-20 10:00:00	NQ	Futures	16900.87	16987.49	16854.81	16976.77	82527.0
2021-07-20 11:00:00	NQ	Futures	16976.77	17039.63	16962.87	17036.73	50402.0
2021-07-20 12:00:00	NQ	Futures	17036.73	17085.4	17034.42	17083.66	40568.0
2021-07-20 13:00:00	NQ	Futures	17083.66	17084.82	17037.31	17060.78	39928.0
2021-07-20 14:00:00	NQ	Futures	17060.78	17110.89	17058.75	17093.22	36030.0
2021-07-20 15:00:00	NQ	Futures	17093.22	17128.85	17053.25	17054.69	63755.0
2021-07-20 16:00:00	NQ	Futures	17054.4	17069.18	17017.04	17064.25	20303.0
2021-07-20 18:00:00	NQ	Futures	17067.73	17084.24	17061.07	17074.39	3140.0
2021-07-20 19:00:00	NQ	Futures	17074.39	17092.35	17070.63	17083.95	2435.0
2021-07-20 20:00:00	NQ	Futures	17083.37	17085.11	17060.2	17077.0	4338.0
2021-07-20 21:00:00	NQ	Futures	17077.29	17079.32	17056.72	17065.41	4210.0
2021-07-20 22:00:00	NQ	Futures	17065.12	17067.44	17019.93	17028.04	5797.0
2021-07-20 23:00:00	NQ	Futures	17028.33	17039.05	17023.99	17032.97	3305.0
2021-07-20 00:00:00	YM	Futures	37871.5	37888.3	37811.2	37879.3	2164.0
2021-07-20 01:00:00	YM	Futures	37880.4	37922.9	37848.0	37918.4	2710.0
2021-07-20 02:00:00	YM	Futures	37916.2	37983.2	37907.2	37978.7	3391.0
2021-07-20 03:00:00	YM	Futures	37977.6	38139.6	37946.3	38040.2	11961.0

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

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