PREVIEW / futures_1hour / 2020-11-05

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-11-05.parquet
  size:    65 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
2020-11-05 00:00:00	ES	Futures	3880.71	3893.59	3872.31	3888.55	11287.0
2020-11-05 01:00:00	ES	Futures	3888.55	3890.51	3870.07	3872.59	10332.0
2020-11-05 02:00:00	ES	Futures	3872.59	3897.8	3869.23	3892.47	18716.0
2020-11-05 03:00:00	ES	Futures	3892.19	3911.24	3887.43	3898.64	34666.0
2020-11-05 04:00:00	ES	Futures	3898.36	3910.96	3890.51	3910.12	24798.0
2020-11-05 05:00:00	ES	Futures	3910.12	3929.17	3907.6	3928.89	37863.0
2020-11-05 06:00:00	ES	Futures	3928.89	3930.85	3917.68	3921.6	27799.0
2020-11-05 07:00:00	ES	Futures	3921.32	3924.96	3911.24	3922.72	31842.0
2020-11-05 08:00:00	ES	Futures	3922.72	3923.28	3914.6	3914.88	33655.0
2020-11-05 09:00:00	ES	Futures	3914.88	3929.73	3904.52	3919.92	198916.0
2020-11-05 10:00:00	ES	Futures	3919.92	3946.53	3919.36	3940.37	265919.0
2020-11-05 11:00:00	ES	Futures	3940.65	3943.45	3923.84	3924.96	147310.0
2020-11-05 12:00:00	ES	Futures	3925.24	3930.85	3909.0	3927.49	136289.0
2020-11-05 13:00:00	ES	Futures	3927.77	3937.29	3926.92	3934.49	102266.0
2020-11-05 14:00:00	ES	Futures	3934.49	3945.41	3931.41	3940.93	142206.0
2020-11-05 15:00:00	ES	Futures	3940.93	3942.05	3915.44	3924.12	272370.0
2020-11-05 16:00:00	ES	Futures	3923.84	3937.29	3923.0	3934.49	56933.0
2020-11-05 18:00:00	ES	Futures	3931.13	3931.97	3902.0	3920.76	26079.0
2020-11-05 19:00:00	ES	Futures	3920.48	3923.56	3907.04	3909.0	21628.0
2020-11-05 20:00:00	ES	Futures	3909.0	3920.76	3904.8	3918.8	17807.0
2020-11-05 21:00:00	ES	Futures	3919.08	3920.2	3906.48	3911.8	11021.0
2020-11-05 22:00:00	ES	Futures	3912.08	3912.92	3902.28	3903.4	9230.0
2020-11-05 23:00:00	ES	Futures	3903.4	3905.92	3895.27	3896.39	13060.0
2020-11-05 00:00:00	NQ	Futures	13819.53	13868.73	13798.1	13856.0	4970.0
2020-11-05 01:00:00	NQ	Futures	13854.26	13865.26	13783.34	13811.42	4907.0
2020-11-05 02:00:00	NQ	Futures	13811.13	13914.47	13801.29	13895.08	10020.0
2020-11-05 03:00:00	NQ	Futures	13893.34	13950.65	13869.89	13929.81	11363.0
2020-11-05 04:00:00	NQ	Futures	13929.52	13979.89	13907.52	13973.81	9779.0
2020-11-05 05:00:00	NQ	Futures	13973.52	14025.05	13971.21	14016.65	12659.0
2020-11-05 06:00:00	NQ	Futures	14017.23	14032.86	13971.21	13972.08	8940.0
2020-11-05 07:00:00	NQ	Futures	13971.5	13989.44	13944.58	13985.1	11822.0
2020-11-05 08:00:00	NQ	Futures	13984.52	13990.02	13956.73	13959.34	15253.0
2020-11-05 09:00:00	NQ	Futures	13958.76	13995.81	13862.95	13970.92	77309.0
2020-11-05 10:00:00	NQ	Futures	13970.34	14020.42	13900.29	13975.84	95689.0
2020-11-05 11:00:00	NQ	Futures	13976.42	13988.0	13913.6	13917.66	49512.0
2020-11-05 12:00:00	NQ	Futures	13917.66	13963.68	13865.55	13932.13	54498.0
2020-11-05 13:00:00	NQ	Futures	13932.71	13973.23	13926.63	13963.39	26335.0
2020-11-05 14:00:00	NQ	Futures	13963.68	14024.47	13950.08	14012.6	49957.0
2020-11-05 15:00:00	NQ	Futures	14012.31	14018.39	13917.66	13971.5	70182.0
2020-11-05 16:00:00	NQ	Futures	13971.5	14021.57	13966.58	14001.02	10843.0
2020-11-05 18:00:00	NQ	Futures	13996.97	13997.55	13929.81	13973.81	8253.0
2020-11-05 19:00:00	NQ	Futures	13971.79	13989.15	13917.66	13918.52	7338.0
2020-11-05 20:00:00	NQ	Futures	13920.26	13943.13	13869.89	13934.44	10249.0
2020-11-05 21:00:00	NQ	Futures	13935.6	13937.92	13902.6	13919.39	4108.0
2020-11-05 22:00:00	NQ	Futures	13920.84	13922.29	13833.42	13842.97	5291.0
2020-11-05 23:00:00	NQ	Futures	13842.39	13857.45	13791.74	13809.68	10323.0
2020-11-05 00:00:00	YM	Futures	30884.4	30972.8	30812.5	30934.1	2281.0
2020-11-05 01:00:00	YM	Futures	30930.8	30956.2	30767.2	30783.8	2514.0
2020-11-05 02:00:00	YM	Futures	30784.9	30970.6	30763.9	30915.3	6928.0
2020-11-05 03:00:00	YM	Futures	30914.2	31077.9	30875.5	30957.3	9522.0

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

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