PREVIEW / futures_1hour / 2020-11-10

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-11-10.parquet
  size:    63 KB
  rows:    1,910

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
2020-11-10 00:00:00	ES	Futures	3937.85	3952.69	3936.45	3945.41	12481.0
2020-11-10 01:00:00	ES	Futures	3945.41	3965.86	3943.73	3962.78	13732.0
2020-11-10 02:00:00	ES	Futures	3962.78	3983.5	3962.78	3967.82	32140.0
2020-11-10 03:00:00	ES	Futures	3967.54	3987.43	3967.26	3972.3	47122.0
2020-11-10 04:00:00	ES	Futures	3972.3	3987.43	3969.78	3981.26	37387.0
2020-11-10 05:00:00	ES	Futures	3981.26	3983.5	3947.93	3948.49	40088.0
2020-11-10 06:00:00	ES	Futures	3948.77	3972.02	3943.73	3971.46	36853.0
2020-11-10 07:00:00	ES	Futures	3971.18	3974.54	3959.14	3960.54	32543.0
2020-11-10 08:00:00	ES	Futures	3960.26	3966.42	3953.25	3959.42	37662.0
2020-11-10 09:00:00	ES	Futures	3959.42	3971.18	3943.17	3961.94	225402.0
2020-11-10 10:00:00	ES	Futures	3961.94	3973.14	3928.61	3940.93	316654.0
2020-11-10 11:00:00	ES	Futures	3940.93	3970.06	3939.53	3962.22	263198.0
2020-11-10 12:00:00	ES	Futures	3961.94	3980.14	3961.1	3969.78	196054.0
2020-11-10 13:00:00	ES	Futures	3969.78	3975.1	3946.81	3968.1	154412.0
2020-11-10 14:00:00	ES	Futures	3967.82	3974.26	3954.37	3966.98	246142.0
2020-11-10 15:00:00	ES	Futures	3966.98	3976.5	3958.58	3968.1	259783.0
2020-11-10 16:00:00	ES	Futures	3968.1	3975.38	3966.98	3972.58	41425.0
2020-11-10 18:00:00	ES	Futures	3973.14	3980.14	3960.26	3963.34	12980.0
2020-11-10 19:00:00	ES	Futures	3963.06	3967.26	3956.05	3961.66	16086.0
2020-11-10 20:00:00	ES	Futures	3961.38	3972.02	3956.05	3970.9	12139.0
2020-11-10 21:00:00	ES	Futures	3970.9	3984.9	3969.78	3977.9	13945.0
2020-11-10 22:00:00	ES	Futures	3978.18	3982.1	3970.34	3975.94	9903.0
2020-11-10 23:00:00	ES	Futures	3976.22	3977.06	3968.38	3973.42	6575.0
2020-11-10 00:00:00	NQ	Futures	13581.0	13620.95	13566.24	13574.06	5818.0
2020-11-10 01:00:00	NQ	Futures	13574.35	13680.87	13566.53	13659.45	7546.0
2020-11-10 02:00:00	NQ	Futures	13659.16	13696.5	13622.69	13642.95	11730.0
2020-11-10 03:00:00	NQ	Futures	13642.37	13746.0	13622.4	13642.08	15877.0
2020-11-10 04:00:00	NQ	Futures	13641.79	13650.76	13562.48	13576.95	14490.0
2020-11-10 05:00:00	NQ	Futures	13575.21	13599.53	13391.4	13396.61	19055.0
2020-11-10 06:00:00	NQ	Futures	13397.77	13502.27	13376.93	13492.43	21141.0
2020-11-10 07:00:00	NQ	Futures	13491.85	13523.11	13441.77	13454.79	18791.0
2020-11-10 08:00:00	NQ	Futures	13453.35	13512.4	13436.27	13509.5	27195.0
2020-11-10 09:00:00	NQ	Futures	13509.21	13604.45	13445.82	13490.4	94124.0
2020-11-10 10:00:00	NQ	Futures	13489.82	13535.56	13319.32	13394.87	114019.0
2020-11-10 11:00:00	NQ	Futures	13394.3	13573.77	13387.35	13500.53	84143.0
2020-11-10 12:00:00	NQ	Futures	13500.53	13598.37	13497.93	13542.5	65029.0
2020-11-10 13:00:00	NQ	Futures	13543.95	13585.92	13402.69	13494.74	67933.0
2020-11-10 14:00:00	NQ	Futures	13494.74	13535.27	13401.24	13460.87	99022.0
2020-11-10 15:00:00	NQ	Futures	13461.45	13503.43	13413.98	13453.64	83911.0
2020-11-10 16:00:00	NQ	Futures	13453.64	13483.16	13447.27	13459.14	9535.0
2020-11-10 18:00:00	NQ	Futures	13468.69	13493.87	13413.69	13429.9	7958.0
2020-11-10 19:00:00	NQ	Futures	13429.03	13460.58	13407.9	13451.61	7934.0
2020-11-10 20:00:00	NQ	Futures	13449.87	13491.85	13416.01	13488.08	10709.0
2020-11-10 21:00:00	NQ	Futures	13487.5	13544.82	13483.74	13521.66	11448.0
2020-11-10 22:00:00	NQ	Futures	13521.95	13534.69	13474.48	13512.11	5837.0
2020-11-10 23:00:00	NQ	Futures	13513.27	13515.58	13481.14	13507.19	3486.0
2020-11-10 00:00:00	YM	Futures	31871.7	32003.3	31859.5	31924.8	3677.0
2020-11-10 01:00:00	YM	Futures	31924.8	32095.0	31910.4	32071.8	4293.0
2020-11-10 02:00:00	YM	Futures	32074.0	32333.8	32074.0	32166.9	12166.0
2020-11-10 03:00:00	YM	Futures	32165.8	32311.7	32137.0	32204.5	7749.0

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

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