PREVIEW / futures_1hour / 2020-11-12

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-11-12.parquet
  size:    64 KB
  rows:    1,923

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-12 00:00:00	ES	Futures	3967.54	3980.42	3966.98	3977.62	15368.0
2020-11-12 01:00:00	ES	Futures	3977.34	3979.02	3966.7	3972.02	10208.0
2020-11-12 02:00:00	ES	Futures	3972.02	3979.86	3968.94	3972.3	12829.0
2020-11-12 03:00:00	ES	Futures	3972.02	3982.94	3970.06	3973.98	20900.0
2020-11-12 04:00:00	ES	Futures	3974.26	3992.47	3973.42	3990.79	20177.0
2020-11-12 05:00:00	ES	Futures	3991.07	3999.19	3989.11	3993.87	20047.0
2020-11-12 06:00:00	ES	Futures	3994.15	3998.35	3988.55	3989.11	13247.0
2020-11-12 07:00:00	ES	Futures	3989.11	3990.79	3971.18	3973.14	30980.0
2020-11-12 08:00:00	ES	Futures	3973.14	3987.99	3972.02	3987.43	37965.0
2020-11-12 09:00:00	ES	Futures	3987.43	3988.55	3974.26	3981.82	154616.0
2020-11-12 10:00:00	ES	Futures	3981.82	3993.87	3977.62	3989.39	193694.0
2020-11-12 11:00:00	ES	Futures	3989.11	3994.43	3974.82	3980.98	125815.0
2020-11-12 12:00:00	ES	Futures	3980.98	3985.18	3949.89	3958.58	180491.0
2020-11-12 13:00:00	ES	Futures	3958.3	3961.38	3943.73	3960.26	179927.0
2020-11-12 14:00:00	ES	Futures	3960.54	3965.3	3942.61	3944.85	174324.0
2020-11-12 15:00:00	ES	Futures	3944.85	3959.42	3935.89	3958.86	328340.0
2020-11-12 16:00:00	ES	Futures	3958.86	3975.1	3958.3	3964.74	69195.0
2020-11-12 18:00:00	ES	Futures	3963.34	3966.14	3958.58	3959.98	9813.0
2020-11-12 19:00:00	ES	Futures	3960.26	3965.02	3951.85	3951.85	11379.0
2020-11-12 20:00:00	ES	Futures	3951.85	3958.02	3944.85	3946.25	13068.0
2020-11-12 21:00:00	ES	Futures	3946.25	3952.69	3941.49	3951.29	11436.0
2020-11-12 22:00:00	ES	Futures	3951.01	3954.93	3948.77	3951.29	5844.0
2020-11-12 23:00:00	ES	Futures	3951.29	3961.66	3950.17	3960.26	6545.0
2020-11-12 00:00:00	NQ	Futures	13670.74	13749.18	13668.71	13739.92	9889.0
2020-11-12 01:00:00	NQ	Futures	13739.63	13745.13	13694.76	13717.34	5707.0
2020-11-12 02:00:00	NQ	Futures	13716.76	13741.66	13678.84	13713.0	6788.0
2020-11-12 03:00:00	NQ	Futures	13710.97	13730.37	13688.97	13721.97	6997.0
2020-11-12 04:00:00	NQ	Futures	13721.4	13830.81	13713.87	13830.53	12051.0
2020-11-12 05:00:00	NQ	Futures	13830.81	13854.55	13814.89	13823.29	9934.0
2020-11-12 06:00:00	NQ	Futures	13824.16	13839.21	13803.03	13809.39	6827.0
2020-11-12 07:00:00	NQ	Futures	13809.1	13818.08	13748.61	13771.47	13356.0
2020-11-12 08:00:00	NQ	Futures	13771.18	13818.95	13763.66	13797.24	18714.0
2020-11-12 09:00:00	NQ	Futures	13797.53	13853.1	13755.55	13809.39	70304.0
2020-11-12 10:00:00	NQ	Futures	13808.81	13866.42	13787.39	13809.97	66207.0
2020-11-12 11:00:00	NQ	Futures	13809.68	13843.26	13728.92	13772.63	44886.0
2020-11-12 12:00:00	NQ	Futures	13772.34	13797.24	13671.03	13705.47	53212.0
2020-11-12 13:00:00	NQ	Futures	13705.19	13732.11	13648.16	13729.21	52356.0
2020-11-12 14:00:00	NQ	Futures	13729.21	13749.76	13658.29	13667.55	56187.0
2020-11-12 15:00:00	NQ	Futures	13667.84	13699.69	13634.84	13690.42	71963.0
2020-11-12 16:00:00	NQ	Futures	13691.87	13742.82	13689.26	13736.74	12465.0
2020-11-12 18:00:00	NQ	Futures	13728.92	13741.37	13716.76	13723.13	3198.0
2020-11-12 19:00:00	NQ	Futures	13724.29	13730.66	13691.29	13696.5	4332.0
2020-11-12 20:00:00	NQ	Futures	13696.79	13720.53	13675.08	13679.42	6056.0
2020-11-12 21:00:00	NQ	Futures	13677.4	13716.18	13668.42	13709.82	5165.0
2020-11-12 22:00:00	NQ	Futures	13710.68	13720.82	13699.69	13710.11	3266.0
2020-11-12 23:00:00	NQ	Futures	13710.4	13743.97	13704.9	13736.45	4070.0
2020-11-12 00:00:00	YM	Futures	32142.6	32249.8	32140.4	32218.9	4026.0
2020-11-12 01:00:00	YM	Futures	32218.9	32234.3	32133.7	32175.7	2955.0
2020-11-12 02:00:00	YM	Futures	32175.7	32238.8	32139.3	32169.1	3865.0
2020-11-12 03:00:00	YM	Futures	32169.1	32284.1	32164.7	32183.5	7653.0

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

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