PREVIEW / futures_1hour / 2018-10-02

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-10-02.parquet
  size:    55 KB
  rows:    1,715

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
2018-10-02 00:00:00	ES	Futures	3183.74	3184.28	3183.2	3183.2	2876.0
2018-10-02 01:00:00	ES	Futures	3183.47	3183.47	3181.56	3182.11	4684.0
2018-10-02 02:00:00	ES	Futures	3181.84	3182.65	3178.57	3179.12	11414.0
2018-10-02 03:00:00	ES	Futures	3179.39	3182.92	3178.03	3182.92	22846.0
2018-10-02 04:00:00	ES	Futures	3182.65	3182.92	3175.31	3176.4	18892.0
2018-10-02 05:00:00	ES	Futures	3176.4	3178.03	3174.22	3177.48	20364.0
2018-10-02 06:00:00	ES	Futures	3177.48	3181.29	3177.21	3180.48	15785.0
2018-10-02 07:00:00	ES	Futures	3180.48	3182.38	3178.84	3181.56	19083.0
2018-10-02 08:00:00	ES	Futures	3181.84	3184.56	3181.29	3183.74	20481.0
2018-10-02 09:00:00	ES	Futures	3184.01	3188.64	3183.47	3187.28	148958.0
2018-10-02 10:00:00	ES	Futures	3187.0	3189.72	3181.29	3187.0	170727.0
2018-10-02 11:00:00	ES	Futures	3187.0	3193.53	3186.19	3192.72	107528.0
2018-10-02 12:00:00	ES	Futures	3192.72	3194.35	3188.91	3190.27	100693.0
2018-10-02 13:00:00	ES	Futures	3190.0	3193.8	3190.0	3192.17	56374.0
2018-10-02 14:00:00	ES	Futures	3192.17	3194.35	3188.09	3188.91	74314.0
2018-10-02 15:00:00	ES	Futures	3188.91	3188.91	3181.29	3185.92	234113.0
2018-10-02 16:00:00	ES	Futures	3185.92	3188.09	3185.64	3187.82	46184.0
2018-10-02 18:00:00	ES	Futures	3186.73	3187.82	3186.19	3187.0	3093.0
2018-10-02 19:00:00	ES	Futures	3187.0	3187.55	3185.37	3185.92	2128.0
2018-10-02 20:00:00	ES	Futures	3186.19	3186.46	3183.2	3185.1	6131.0
2018-10-02 21:00:00	ES	Futures	3185.37	3189.45	3183.74	3188.91	7359.0
2018-10-02 22:00:00	ES	Futures	3188.64	3194.08	3188.64	3192.99	15747.0
2018-10-02 23:00:00	ES	Futures	3193.26	3193.26	3190.0	3190.0	5480.0
2018-10-02 00:00:00	NQ	Futures	8993.6	8995.65	8990.96	8992.72	913.0
2018-10-02 01:00:00	NQ	Futures	8992.72	8993.31	8983.04	8986.27	2307.0
2018-10-02 02:00:00	NQ	Futures	8986.27	8987.44	8971.31	8972.77	4422.0
2018-10-02 03:00:00	NQ	Futures	8973.07	8985.97	8968.08	8985.09	7786.0
2018-10-02 04:00:00	NQ	Futures	8985.09	8985.97	8953.12	8959.87	7988.0
2018-10-02 05:00:00	NQ	Futures	8959.57	8964.27	8952.24	8962.21	6760.0
2018-10-02 06:00:00	NQ	Futures	8962.51	8975.12	8960.75	8971.31	5279.0
2018-10-02 07:00:00	NQ	Futures	8971.31	8981.57	8963.09	8973.65	6869.0
2018-10-02 08:00:00	NQ	Futures	8973.95	8988.32	8973.65	8981.28	7416.0
2018-10-02 09:00:00	NQ	Futures	8981.28	9013.84	8958.11	9010.02	74690.0
2018-10-02 10:00:00	NQ	Futures	9009.73	9030.56	8988.03	9019.41	71282.0
2018-10-02 11:00:00	NQ	Futures	9019.12	9044.34	9012.37	9042.0	41161.0
2018-10-02 12:00:00	NQ	Futures	9042.0	9049.03	9007.68	9014.42	35444.0
2018-10-02 13:00:00	NQ	Futures	9014.13	9028.21	9011.49	9014.13	19620.0
2018-10-02 14:00:00	NQ	Futures	9014.72	9021.76	8994.18	8997.41	24111.0
2018-10-02 15:00:00	NQ	Futures	8997.12	8997.41	8960.16	8980.11	53067.0
2018-10-02 16:00:00	NQ	Futures	8979.81	8985.09	8975.71	8985.09	8448.0
2018-10-02 18:00:00	NQ	Futures	8982.75	8984.8	8978.05	8982.45	1152.0
2018-10-02 19:00:00	NQ	Futures	8982.45	8984.51	8973.07	8977.47	1357.0
2018-10-02 20:00:00	NQ	Futures	8977.76	8979.23	8965.44	8974.53	2530.0
2018-10-02 21:00:00	NQ	Futures	8974.53	8986.85	8967.2	8985.09	3778.0
2018-10-02 22:00:00	NQ	Futures	8984.8	9005.33	8984.8	9000.34	6568.0
2018-10-02 23:00:00	NQ	Futures	9000.34	9001.81	8988.32	8989.79	3688.0
2018-10-02 00:00:00	YM	Futures	28956.6	28962.1	28951.2	28951.2	678.0
2018-10-02 01:00:00	YM	Futures	28950.1	28951.2	28925.1	28930.6	1536.0
2018-10-02 02:00:00	YM	Futures	28930.6	28934.9	28894.7	28900.1	3059.0
2018-10-02 03:00:00	YM	Futures	28899.1	28941.4	28886.0	28939.3	4793.0

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

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