PREVIEW / futures_1hour / 2021-01-11

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-01-11.parquet
  size:    63 KB
  rows:    1,914

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-01-11 00:00:00	ES	Futures	4258.27	4263.6	4256.87	4259.11	7180.0
2021-01-11 01:00:00	ES	Futures	4259.11	4259.39	4254.9	4256.59	8662.0
2021-01-11 02:00:00	ES	Futures	4256.59	4263.6	4255.46	4261.08	10190.0
2021-01-11 03:00:00	ES	Futures	4261.08	4271.18	4256.31	4262.76	20697.0
2021-01-11 04:00:00	ES	Futures	4262.48	4267.25	4257.99	4257.99	11260.0
2021-01-11 05:00:00	ES	Futures	4257.99	4266.13	4256.87	4266.13	10117.0
2021-01-11 06:00:00	ES	Futures	4266.13	4266.97	4259.95	4265.01	9688.0
2021-01-11 07:00:00	ES	Futures	4265.01	4266.41	4256.03	4261.92	15555.0
2021-01-11 08:00:00	ES	Futures	4261.92	4261.92	4245.36	4246.76	43839.0
2021-01-11 09:00:00	ES	Futures	4247.04	4262.48	4239.75	4260.24	229552.0
2021-01-11 10:00:00	ES	Futures	4260.24	4269.78	4257.99	4265.57	162476.0
2021-01-11 11:00:00	ES	Futures	4265.85	4270.62	4254.9	4268.94	97965.0
2021-01-11 12:00:00	ES	Futures	4268.94	4277.92	4267.53	4273.99	86033.0
2021-01-11 13:00:00	ES	Futures	4273.99	4276.51	4257.43	4262.2	92763.0
2021-01-11 14:00:00	ES	Futures	4262.48	4266.41	4252.1	4265.57	111470.0
2021-01-11 15:00:00	ES	Futures	4265.85	4267.25	4249.85	4257.43	215387.0
2021-01-11 16:00:00	ES	Futures	4257.43	4264.45	4254.06	4256.87	45884.0
2021-01-11 18:00:00	ES	Futures	4259.67	4264.45	4255.74	4263.04	6971.0
2021-01-11 19:00:00	ES	Futures	4263.04	4271.18	4259.39	4268.37	12270.0
2021-01-11 20:00:00	ES	Futures	4268.66	4270.62	4253.5	4263.04	13616.0
2021-01-11 21:00:00	ES	Futures	4263.32	4264.73	4259.11	4264.16	6269.0
2021-01-11 22:00:00	ES	Futures	4264.16	4265.85	4256.59	4259.39	5547.0
2021-01-11 23:00:00	ES	Futures	4259.39	4259.95	4252.38	4255.74	5248.0
2021-01-11 00:00:00	NQ	Futures	15082.97	15107.86	15080.66	15093.97	2884.0
2021-01-11 01:00:00	NQ	Futures	15094.26	15098.02	15079.5	15087.02	2318.0
2021-01-11 02:00:00	NQ	Futures	15087.89	15128.99	15083.55	15106.7	5102.0
2021-01-11 03:00:00	NQ	Futures	15106.13	15137.09	15089.63	15106.42	8101.0
2021-01-11 04:00:00	NQ	Futures	15106.42	15114.81	15088.47	15092.52	5295.0
2021-01-11 05:00:00	NQ	Futures	15091.36	15112.78	15076.89	15112.49	5494.0
2021-01-11 06:00:00	NQ	Futures	15111.34	15116.83	15094.55	15102.94	3412.0
2021-01-11 07:00:00	NQ	Futures	15102.65	15106.13	15054.9	15086.73	9124.0
2021-01-11 08:00:00	NQ	Futures	15086.15	15086.15	15016.11	15028.85	14629.0
2021-01-11 09:00:00	NQ	Futures	15029.14	15034.64	14925.81	15002.8	95069.0
2021-01-11 10:00:00	NQ	Futures	15003.67	15054.9	14983.7	15022.19	66291.0
2021-01-11 11:00:00	NQ	Futures	15022.48	15036.95	14970.96	15031.74	36203.0
2021-01-11 12:00:00	NQ	Futures	15031.45	15066.76	15024.22	15044.48	27171.0
2021-01-11 13:00:00	NQ	Futures	15044.19	15060.68	14984.27	15003.67	27287.0
2021-01-11 14:00:00	NQ	Futures	15004.24	15004.53	14944.04	14982.25	38562.0
2021-01-11 15:00:00	NQ	Futures	14982.54	14983.98	14902.07	14930.44	63158.0
2021-01-11 16:00:00	NQ	Futures	14931.02	14961.41	14924.65	14941.44	8447.0
2021-01-11 18:00:00	NQ	Futures	14947.23	14968.93	14932.18	14961.41	3376.0
2021-01-11 19:00:00	NQ	Futures	14960.83	14986.88	14949.25	14979.64	4137.0
2021-01-11 20:00:00	NQ	Futures	14979.93	14985.72	14931.89	14961.41	4996.0
2021-01-11 21:00:00	NQ	Futures	14961.99	14969.22	14944.62	14967.78	2416.0
2021-01-11 22:00:00	NQ	Futures	14968.64	14977.33	14939.99	14951.57	2882.0
2021-01-11 23:00:00	NQ	Futures	14951.28	14952.44	14918.86	14936.23	4224.0
2021-01-11 00:00:00	YM	Futures	34159.9	34197.6	34148.8	34162.1	1861.0
2021-01-11 01:00:00	YM	Futures	34162.1	34175.4	34124.4	34146.6	2024.0
2021-01-11 02:00:00	YM	Futures	34146.6	34194.3	34136.6	34167.6	2770.0
2021-01-11 03:00:00	YM	Futures	34167.6	34248.6	34115.5	34184.3	5624.0

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

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