PREVIEW / futures_1hour / 2019-10-08

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-10-08.parquet
  size:    61 KB
  rows:    1,878

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
2019-10-08 00:00:00	ES	Futures	3201.44	3202.53	3200.9	3202.26	3161.0
2019-10-08 01:00:00	ES	Futures	3202.53	3202.53	3198.45	3201.17	6176.0
2019-10-08 02:00:00	ES	Futures	3201.17	3205.25	3200.36	3200.36	8880.0
2019-10-08 03:00:00	ES	Futures	3200.36	3200.63	3186.5	3187.32	40641.0
2019-10-08 04:00:00	ES	Futures	3187.32	3192.48	3186.23	3188.68	32994.0
2019-10-08 05:00:00	ES	Futures	3188.68	3190.31	3179.98	3182.43	32767.0
2019-10-08 06:00:00	ES	Futures	3182.7	3182.97	3170.75	3174.28	58268.0
2019-10-08 07:00:00	ES	Futures	3174.28	3175.91	3162.06	3171.02	66691.0
2019-10-08 08:00:00	ES	Futures	3171.02	3173.46	3166.95	3171.02	44024.0
2019-10-08 09:00:00	ES	Futures	3171.02	3174.55	3153.91	3153.91	222695.0
2019-10-08 10:00:00	ES	Futures	3153.91	3160.15	3147.12	3159.34	275580.0
2019-10-08 11:00:00	ES	Futures	3159.34	3161.78	3145.22	3152.55	195130.0
2019-10-08 12:00:00	ES	Futures	3152.55	3169.66	3149.83	3161.24	123461.0
2019-10-08 13:00:00	ES	Futures	3161.24	3168.85	3158.25	3164.23	87899.0
2019-10-08 14:00:00	ES	Futures	3164.5	3177.81	3154.18	3162.87	213597.0
2019-10-08 15:00:00	ES	Futures	3162.6	3169.93	3140.87	3141.96	285608.0
2019-10-08 16:00:00	ES	Futures	3141.68	3147.66	3140.6	3143.86	69657.0
2019-10-08 18:00:00	ES	Futures	3143.86	3146.57	3138.42	3140.05	8844.0
2019-10-08 19:00:00	ES	Futures	3140.05	3143.86	3138.15	3142.23	8189.0
2019-10-08 20:00:00	ES	Futures	3142.23	3150.92	3142.23	3149.56	13407.0
2019-10-08 21:00:00	ES	Futures	3149.56	3152.82	3147.93	3152.28	10434.0
2019-10-08 22:00:00	ES	Futures	3152.28	3154.45	3149.29	3153.36	8871.0
2019-10-08 23:00:00	ES	Futures	3153.64	3154.45	3150.1	3152.28	6708.0
2019-10-08 00:00:00	NQ	Futures	9034.31	9038.38	9032.28	9036.34	1331.0
2019-10-08 01:00:00	NQ	Futures	9036.93	9036.93	9023.27	9029.95	2964.0
2019-10-08 02:00:00	NQ	Futures	9029.95	9045.35	9027.63	9030.24	5431.0
2019-10-08 03:00:00	NQ	Futures	9030.24	9030.82	8983.18	8986.38	13263.0
2019-10-08 04:00:00	NQ	Futures	8986.67	9000.61	8981.44	8990.16	10138.0
2019-10-08 05:00:00	NQ	Futures	8990.45	8995.09	8963.72	8973.89	9738.0
2019-10-08 06:00:00	NQ	Futures	8973.6	8975.05	8930.02	8945.42	17416.0
2019-10-08 07:00:00	NQ	Futures	8945.71	8954.72	8907.08	8938.45	21649.0
2019-10-08 08:00:00	NQ	Futures	8937.87	8945.42	8923.34	8935.54	17928.0
2019-10-08 09:00:00	NQ	Futures	8935.83	8946.0	8880.06	8882.96	71894.0
2019-10-08 10:00:00	NQ	Futures	8883.55	8909.4	8860.6	8905.91	84245.0
2019-10-08 11:00:00	NQ	Futures	8905.91	8917.82	8870.18	8892.26	54618.0
2019-10-08 12:00:00	NQ	Futures	8892.26	8946.87	8882.67	8919.28	39434.0
2019-10-08 13:00:00	NQ	Futures	8918.99	8943.1	8908.24	8925.96	31013.0
2019-10-08 14:00:00	NQ	Futures	8925.67	8972.15	8885.58	8917.24	61832.0
2019-10-08 15:00:00	NQ	Futures	8916.37	8942.22	8847.81	8850.14	70466.0
2019-10-08 16:00:00	NQ	Futures	8850.14	8865.53	8846.65	8858.27	14062.0
2019-10-08 18:00:00	NQ	Futures	8855.37	8866.99	8838.52	8845.2	2979.0
2019-10-08 19:00:00	NQ	Futures	8845.2	8855.37	8836.19	8850.43	2632.0
2019-10-08 20:00:00	NQ	Futures	8850.72	8881.8	8850.72	8874.83	5315.0
2019-10-08 21:00:00	NQ	Futures	8875.12	8887.61	8869.6	8885.0	4731.0
2019-10-08 22:00:00	NQ	Futures	8885.0	8888.48	8875.7	8884.42	2418.0
2019-10-08 23:00:00	NQ	Futures	8884.13	8886.16	8869.89	8877.44	2317.0
2019-10-08 00:00:00	YM	Futures	28854.4	28866.4	28850.0	28863.1	750.0
2019-10-08 01:00:00	YM	Futures	28863.1	28863.1	28826.1	28853.3	1697.0
2019-10-08 02:00:00	YM	Futures	28853.3	28894.7	28844.6	28846.8	2542.0
2019-10-08 03:00:00	YM	Futures	28845.7	28850.0	28726.0	28732.5	8808.0

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

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