PREVIEW / futures_1hour / 2021-07-21

all futures 1-hour files

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

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-21 00:00:00	ES	Futures	4858.14	4860.95	4854.48	4854.48	4721.0
2021-07-21 01:00:00	ES	Futures	4854.48	4863.77	4854.48	4858.98	7487.0
2021-07-21 02:00:00	ES	Futures	4858.98	4866.59	4858.7	4866.02	11471.0
2021-07-21 03:00:00	ES	Futures	4866.02	4883.48	4861.24	4880.1	42032.0
2021-07-21 04:00:00	ES	Futures	4879.82	4886.58	4875.6	4883.2	23933.0
2021-07-21 05:00:00	ES	Futures	4883.2	4884.89	4879.26	4881.51	12900.0
2021-07-21 06:00:00	ES	Futures	4881.79	4882.07	4876.16	4878.13	14754.0
2021-07-21 07:00:00	ES	Futures	4878.13	4878.13	4860.67	4863.21	31245.0
2021-07-21 08:00:00	ES	Futures	4863.21	4874.19	4862.08	4871.09	36700.0
2021-07-21 09:00:00	ES	Futures	4871.37	4890.24	4868.56	4889.96	171152.0
2021-07-21 10:00:00	ES	Futures	4889.68	4890.52	4880.66	4887.14	153946.0
2021-07-21 11:00:00	ES	Futures	4887.42	4893.9	4883.48	4893.9	113677.0
2021-07-21 12:00:00	ES	Futures	4893.9	4893.9	4887.14	4887.7	68515.0
2021-07-21 13:00:00	ES	Futures	4887.7	4894.18	4887.42	4892.77	64979.0
2021-07-21 14:00:00	ES	Futures	4892.77	4895.59	4889.39	4895.59	60923.0
2021-07-21 15:00:00	ES	Futures	4895.31	4902.06	4888.83	4900.94	213871.0
2021-07-21 16:00:00	ES	Futures	4900.66	4905.44	4899.81	4905.44	52616.0
2021-07-21 18:00:00	ES	Futures	4905.16	4905.16	4902.35	4903.75	4179.0
2021-07-21 19:00:00	ES	Futures	4903.75	4907.41	4902.63	4904.6	5032.0
2021-07-21 20:00:00	ES	Futures	4904.6	4905.73	4901.5	4901.78	4874.0
2021-07-21 21:00:00	ES	Futures	4902.06	4906.85	4901.5	4905.73	4577.0
2021-07-21 22:00:00	ES	Futures	4905.73	4906.01	4902.63	4902.91	3498.0
2021-07-21 23:00:00	ES	Futures	4903.19	4904.88	4902.35	4903.47	1991.0
2021-07-21 00:00:00	NQ	Futures	17032.68	17040.79	17018.77	17019.35	2446.0
2021-07-21 01:00:00	NQ	Futures	17019.35	17050.64	17018.48	17038.76	4293.0
2021-07-21 02:00:00	NQ	Futures	17039.05	17072.08	17038.18	17068.89	5162.0
2021-07-21 03:00:00	NQ	Futures	17068.89	17079.03	17043.69	17067.44	11407.0
2021-07-21 04:00:00	NQ	Futures	17066.86	17109.44	17063.38	17080.19	9116.0
2021-07-21 05:00:00	NQ	Futures	17080.77	17090.9	17067.44	17075.84	4825.0
2021-07-21 06:00:00	NQ	Futures	17076.13	17079.32	17054.4	17066.28	4840.0
2021-07-21 07:00:00	NQ	Futures	17065.99	17065.99	16996.47	17011.82	12550.0
2021-07-21 08:00:00	NQ	Futures	17011.24	17048.03	17003.13	17038.76	12891.0
2021-07-21 09:00:00	NQ	Futures	17037.89	17099.88	17023.99	17098.15	71876.0
2021-07-21 10:00:00	NQ	Futures	17097.86	17111.76	17062.81	17106.84	59047.0
2021-07-21 11:00:00	NQ	Futures	17107.13	17132.62	17095.83	17126.54	43874.0
2021-07-21 12:00:00	NQ	Futures	17126.54	17126.54	17080.77	17084.82	26125.0
2021-07-21 13:00:00	NQ	Futures	17084.53	17136.96	17073.81	17124.51	26619.0
2021-07-21 14:00:00	NQ	Futures	17125.09	17136.38	17110.31	17134.94	20841.0
2021-07-21 15:00:00	NQ	Futures	17134.94	17186.79	17122.48	17181.57	46460.0
2021-07-21 16:00:00	NQ	Futures	17181.29	17194.9	17173.17	17193.45	12020.0
2021-07-21 18:00:00	NQ	Futures	17191.71	17193.16	17180.13	17188.53	1970.0
2021-07-21 19:00:00	NQ	Futures	17188.24	17202.14	17185.34	17191.71	2102.0
2021-07-21 20:00:00	NQ	Futures	17190.84	17201.85	17184.76	17191.42	2314.0
2021-07-21 21:00:00	NQ	Futures	17191.71	17213.73	17189.4	17207.07	3064.0
2021-07-21 22:00:00	NQ	Futures	17206.78	17214.02	17198.67	17201.27	2686.0
2021-07-21 23:00:00	NQ	Futures	17201.27	17204.17	17195.77	17198.09	1549.0
2021-07-21 00:00:00	YM	Futures	38434.6	38462.5	38393.2	38396.6	1251.0
2021-07-21 01:00:00	YM	Futures	38396.6	38472.6	38396.6	38426.8	1545.0
2021-07-21 02:00:00	YM	Futures	38426.8	38484.9	38403.3	38482.6	3606.0
2021-07-21 03:00:00	YM	Futures	38481.5	38688.2	38446.9	38652.5	10641.0

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

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