PREVIEW / futures_1hour / 2019-06-25

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-06-25.parquet
  size:    58 KB
  rows:    1,845

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-06-25 00:00:00	ES	Futures	3189.45	3190.53	3185.93	3186.47	11403.0
2019-06-25 01:00:00	ES	Futures	3186.47	3189.45	3185.93	3189.45	10726.0
2019-06-25 02:00:00	ES	Futures	3189.45	3191.07	3187.01	3188.09	12539.0
2019-06-25 03:00:00	ES	Futures	3188.36	3192.15	3187.82	3189.99	21489.0
2019-06-25 04:00:00	ES	Futures	3189.99	3193.78	3188.91	3190.53	17819.0
2019-06-25 05:00:00	ES	Futures	3190.26	3193.78	3188.91	3191.34	14805.0
2019-06-25 06:00:00	ES	Futures	3191.34	3192.7	3189.72	3192.7	12294.0
2019-06-25 07:00:00	ES	Futures	3192.42	3193.78	3191.07	3192.97	16526.0
2019-06-25 08:00:00	ES	Futures	3192.97	3195.94	3191.07	3195.13	19567.0
2019-06-25 09:00:00	ES	Futures	3195.13	3197.57	3184.03	3188.64	181731.0
2019-06-25 10:00:00	ES	Futures	3188.64	3189.45	3179.43	3181.33	203334.0
2019-06-25 11:00:00	ES	Futures	3181.33	3186.2	3179.16	3182.68	110272.0
2019-06-25 12:00:00	ES	Futures	3182.68	3185.66	3174.29	3176.18	116718.0
2019-06-25 13:00:00	ES	Futures	3175.91	3182.14	3169.14	3175.37	170660.0
2019-06-25 14:00:00	ES	Futures	3175.37	3176.72	3162.92	3169.14	138654.0
2019-06-25 15:00:00	ES	Futures	3169.14	3172.12	3161.84	3164.0	210905.0
2019-06-25 16:00:00	ES	Futures	3164.0	3166.17	3163.46	3165.08	61233.0
2019-06-25 18:00:00	ES	Futures	3164.54	3167.25	3164.0	3167.25	4466.0
2019-06-25 19:00:00	ES	Futures	3167.25	3167.52	3159.13	3162.65	8951.0
2019-06-25 20:00:00	ES	Futures	3162.65	3168.33	3162.38	3166.71	11122.0
2019-06-25 21:00:00	ES	Futures	3166.44	3167.52	3163.46	3165.08	9448.0
2019-06-25 22:00:00	ES	Futures	3165.08	3167.52	3164.0	3165.35	8541.0
2019-06-25 23:00:00	ES	Futures	3165.35	3166.98	3164.54	3165.63	4447.0
2019-06-25 00:00:00	NQ	Futures	8970.33	8974.4	8952.93	8956.99	5435.0
2019-06-25 01:00:00	NQ	Futures	8956.99	8969.75	8955.25	8968.88	4391.0
2019-06-25 02:00:00	NQ	Futures	8969.17	8976.43	8961.05	8968.59	4580.0
2019-06-25 03:00:00	NQ	Futures	8968.88	8983.68	8967.43	8978.46	5771.0
2019-06-25 04:00:00	NQ	Futures	8978.75	8990.06	8972.36	8976.43	5689.0
2019-06-25 05:00:00	NQ	Futures	8975.56	8985.13	8969.75	8977.59	4118.0
2019-06-25 06:00:00	NQ	Futures	8977.88	8985.13	8972.07	8985.13	3227.0
2019-06-25 07:00:00	NQ	Futures	8984.84	8989.77	8979.62	8988.03	3510.0
2019-06-25 08:00:00	NQ	Futures	8987.74	8997.9	8982.52	8995.29	4978.0
2019-06-25 09:00:00	NQ	Futures	8995.29	9002.25	8952.05	8966.85	53991.0
2019-06-25 10:00:00	NQ	Futures	8966.56	8972.65	8913.47	8923.04	73122.0
2019-06-25 11:00:00	NQ	Futures	8923.33	8932.91	8914.92	8922.46	29576.0
2019-06-25 12:00:00	NQ	Futures	8922.17	8935.23	8886.77	8892.0	33898.0
2019-06-25 13:00:00	NQ	Futures	8891.71	8913.47	8863.27	8889.09	50091.0
2019-06-25 14:00:00	NQ	Futures	8888.51	8891.12	8833.39	8850.21	43500.0
2019-06-25 15:00:00	NQ	Futures	8850.5	8861.24	8831.36	8845.57	53651.0
2019-06-25 16:00:00	NQ	Futures	8845.57	8861.24	8845.28	8860.95	12001.0
2019-06-25 18:00:00	NQ	Futures	8858.63	8867.91	8857.47	8867.91	2363.0
2019-06-25 19:00:00	NQ	Futures	8868.2	8869.07	8839.19	8851.09	3620.0
2019-06-25 20:00:00	NQ	Futures	8850.21	8868.49	8849.92	8863.56	4044.0
2019-06-25 21:00:00	NQ	Futures	8863.56	8867.62	8851.96	8859.5	4064.0
2019-06-25 22:00:00	NQ	Futures	8859.21	8874.01	8856.6	8865.88	4883.0
2019-06-25 23:00:00	NQ	Futures	8865.59	8870.81	8861.82	8865.88	2154.0
2019-06-25 00:00:00	YM	Futures	29047.1	29056.9	29019.9	29023.2	2197.0
2019-06-25 01:00:00	YM	Futures	29025.4	29049.3	29017.8	29048.2	2183.0
2019-06-25 02:00:00	YM	Futures	29048.2	29064.5	29027.6	29041.7	2665.0
2019-06-25 03:00:00	YM	Futures	29041.7	29072.1	29036.3	29054.7	3176.0

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

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