PREVIEW / futures_1hour / 2019-08-08

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-08-08.parquet
  size:    62 KB
  rows:    1,875

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-08-08 00:00:00	ES	Futures	3133.68	3134.49	3129.35	3131.79	9931.0
2019-08-08 01:00:00	ES	Futures	3131.79	3134.76	3130.16	3133.41	10514.0
2019-08-08 02:00:00	ES	Futures	3133.41	3136.39	3129.89	3134.76	17706.0
2019-08-08 03:00:00	ES	Futures	3134.76	3134.76	3124.48	3129.08	33432.0
2019-08-08 04:00:00	ES	Futures	3129.08	3130.43	3119.88	3128.0	27407.0
2019-08-08 05:00:00	ES	Futures	3128.0	3132.87	3125.29	3130.97	23073.0
2019-08-08 06:00:00	ES	Futures	3130.97	3133.68	3125.29	3125.83	23759.0
2019-08-08 07:00:00	ES	Futures	3125.83	3128.0	3122.04	3126.1	26838.0
2019-08-08 08:00:00	ES	Futures	3126.1	3133.14	3124.75	3132.6	38664.0
2019-08-08 09:00:00	ES	Futures	3132.6	3146.95	3132.06	3143.97	274654.0
2019-08-08 10:00:00	ES	Futures	3144.51	3158.86	3143.7	3157.5	207463.0
2019-08-08 11:00:00	ES	Futures	3157.5	3166.71	3152.63	3165.9	162756.0
2019-08-08 12:00:00	ES	Futures	3166.17	3174.29	3164.81	3174.02	147912.0
2019-08-08 13:00:00	ES	Futures	3174.29	3176.18	3167.52	3171.85	114532.0
2019-08-08 14:00:00	ES	Futures	3172.12	3174.56	3166.44	3172.12	129511.0
2019-08-08 15:00:00	ES	Futures	3172.12	3182.41	3168.6	3182.41	287718.0
2019-08-08 16:00:00	ES	Futures	3182.14	3184.3	3180.78	3182.41	86049.0
2019-08-08 18:00:00	ES	Futures	3170.5	3175.91	3157.23	3166.71	45677.0
2019-08-08 19:00:00	ES	Futures	3166.71	3178.35	3162.65	3176.99	18346.0
2019-08-08 20:00:00	ES	Futures	3177.27	3178.89	3169.69	3169.96	26547.0
2019-08-08 21:00:00	ES	Futures	3170.23	3174.83	3166.71	3172.39	19811.0
2019-08-08 22:00:00	ES	Futures	3172.39	3174.02	3168.06	3171.04	6779.0
2019-08-08 23:00:00	ES	Futures	3171.04	3171.31	3165.08	3169.96	9476.0
2019-08-08 00:00:00	NQ	Futures	8821.78	8827.0	8805.24	8815.11	4801.0
2019-08-08 01:00:00	NQ	Futures	8815.69	8829.03	8809.59	8820.04	4454.0
2019-08-08 02:00:00	NQ	Futures	8819.75	8833.1	8807.27	8825.55	6221.0
2019-08-08 03:00:00	NQ	Futures	8825.26	8825.26	8788.12	8805.24	10167.0
2019-08-08 04:00:00	NQ	Futures	8805.24	8812.79	8772.17	8803.5	11573.0
2019-08-08 05:00:00	NQ	Futures	8803.79	8819.17	8793.35	8814.53	8216.0
2019-08-08 06:00:00	NQ	Futures	8814.82	8826.42	8797.12	8800.31	8031.0
2019-08-08 07:00:00	NQ	Futures	8800.02	8808.14	8786.09	8798.57	9353.0
2019-08-08 08:00:00	NQ	Futures	8797.99	8818.59	8793.35	8810.47	11671.0
2019-08-08 09:00:00	NQ	Futures	8810.18	8851.38	8794.8	8842.67	87041.0
2019-08-08 10:00:00	NQ	Futures	8843.25	8900.7	8838.61	8896.06	77867.0
2019-08-08 11:00:00	NQ	Futures	8896.06	8922.75	8880.68	8918.69	49984.0
2019-08-08 12:00:00	NQ	Futures	8918.69	8939.0	8909.11	8935.23	41020.0
2019-08-08 13:00:00	NQ	Futures	8935.23	8944.51	8918.4	8937.26	32536.0
2019-08-08 14:00:00	NQ	Futures	8937.26	8952.64	8922.46	8939.58	42196.0
2019-08-08 15:00:00	NQ	Futures	8939.87	8974.98	8932.62	8973.82	73648.0
2019-08-08 16:00:00	NQ	Futures	8973.82	8981.07	8968.3	8968.88	15177.0
2019-08-08 18:00:00	NQ	Futures	8935.81	8945.96	8886.77	8919.27	21578.0
2019-08-08 19:00:00	NQ	Futures	8919.27	8959.6	8906.79	8952.93	9214.0
2019-08-08 20:00:00	NQ	Futures	8952.64	8964.24	8930.87	8932.62	12769.0
2019-08-08 21:00:00	NQ	Futures	8932.91	8943.64	8917.82	8935.52	11045.0
2019-08-08 22:00:00	NQ	Futures	8936.1	8941.03	8919.85	8932.03	4398.0
2019-08-08 23:00:00	NQ	Futures	8932.33	8935.23	8908.53	8924.49	7193.0
2019-08-08 00:00:00	YM	Futures	28328.3	28338.1	28281.5	28305.5	3138.0
2019-08-08 01:00:00	YM	Futures	28306.5	28333.7	28292.4	28326.1	2431.0
2019-08-08 02:00:00	YM	Futures	28327.2	28356.6	28294.6	28341.3	3110.0
2019-08-08 03:00:00	YM	Futures	28340.3	28340.3	28240.2	28280.4	5989.0

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

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