PREVIEW / futures_1hour / 2019-04-02

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-04-02.parquet
  size:    55 KB
  rows:    1,769

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-04-02 00:00:00	ES	Futures	3108.46	3109.27	3107.65	3108.19	3927.0
2019-04-02 01:00:00	ES	Futures	3108.46	3109.54	3107.65	3108.19	3530.0
2019-04-02 02:00:00	ES	Futures	3108.46	3109.27	3107.37	3108.46	5606.0
2019-04-02 03:00:00	ES	Futures	3108.73	3109.54	3106.29	3108.46	13680.0
2019-04-02 04:00:00	ES	Futures	3108.46	3110.63	3107.92	3109.27	9915.0
2019-04-02 05:00:00	ES	Futures	3109.0	3112.53	3108.46	3112.25	10393.0
2019-04-02 06:00:00	ES	Futures	3111.98	3113.88	3111.17	3113.07	9190.0
2019-04-02 07:00:00	ES	Futures	3113.07	3114.97	3112.8	3114.42	11440.0
2019-04-02 08:00:00	ES	Futures	3114.42	3116.32	3113.61	3115.24	18202.0
2019-04-02 09:00:00	ES	Futures	3114.97	3115.24	3109.0	3113.34	135529.0
2019-04-02 10:00:00	ES	Futures	3113.07	3114.15	3107.65	3110.09	132601.0
2019-04-02 11:00:00	ES	Futures	3109.81	3112.8	3103.85	3111.71	137814.0
2019-04-02 12:00:00	ES	Futures	3111.44	3113.34	3107.92	3110.09	66040.0
2019-04-02 13:00:00	ES	Futures	3110.36	3113.34	3108.73	3111.44	55485.0
2019-04-02 14:00:00	ES	Futures	3111.44	3113.88	3110.63	3113.88	41137.0
2019-04-02 15:00:00	ES	Futures	3113.88	3116.32	3113.07	3113.88	107001.0
2019-04-02 16:00:00	ES	Futures	3113.61	3113.88	3107.92	3108.46	47898.0
2019-04-02 18:00:00	ES	Futures	3107.92	3110.63	3107.65	3109.81	3771.0
2019-04-02 19:00:00	ES	Futures	3110.09	3110.36	3108.46	3109.0	3404.0
2019-04-02 20:00:00	ES	Futures	3109.0	3121.74	3107.1	3120.12	25002.0
2019-04-02 21:00:00	ES	Futures	3120.39	3125.54	3115.51	3122.83	27884.0
2019-04-02 22:00:00	ES	Futures	3122.83	3124.18	3121.47	3122.83	7210.0
2019-04-02 23:00:00	ES	Futures	3122.83	3123.1	3121.2	3121.74	3900.0
2019-04-02 00:00:00	NQ	Futures	8720.41	8722.16	8717.5	8719.83	1985.0
2019-04-02 01:00:00	NQ	Futures	8719.83	8724.49	8717.5	8720.71	1973.0
2019-04-02 02:00:00	NQ	Futures	8720.41	8724.49	8718.38	8723.04	2465.0
2019-04-02 03:00:00	NQ	Futures	8722.74	8726.24	8717.21	8722.45	4699.0
2019-04-02 04:00:00	NQ	Futures	8722.16	8728.57	8721.58	8724.78	3861.0
2019-04-02 05:00:00	NQ	Futures	8725.07	8730.31	8723.04	8730.02	4355.0
2019-04-02 06:00:00	NQ	Futures	8730.02	8735.26	8727.4	8732.93	5717.0
2019-04-02 07:00:00	NQ	Futures	8732.93	8741.09	8731.48	8739.92	4716.0
2019-04-02 08:00:00	NQ	Futures	8739.92	8748.37	8738.18	8741.09	9390.0
2019-04-02 09:00:00	NQ	Futures	8741.09	8744.58	8721.29	8727.69	56557.0
2019-04-02 10:00:00	NQ	Futures	8727.69	8754.77	8718.67	8749.53	67706.0
2019-04-02 11:00:00	NQ	Futures	8749.53	8752.73	8724.78	8747.49	55378.0
2019-04-02 12:00:00	NQ	Futures	8747.49	8753.02	8738.18	8747.49	30819.0
2019-04-02 13:00:00	NQ	Futures	8747.2	8757.68	8741.67	8755.35	25808.0
2019-04-02 14:00:00	NQ	Futures	8755.35	8762.63	8750.7	8762.34	19686.0
2019-04-02 15:00:00	NQ	Futures	8762.63	8772.53	8761.76	8764.38	33534.0
2019-04-02 16:00:00	NQ	Futures	8764.38	8765.54	8753.02	8753.02	11065.0
2019-04-02 18:00:00	NQ	Futures	8754.48	8760.01	8753.02	8757.97	1607.0
2019-04-02 19:00:00	NQ	Futures	8758.27	8759.43	8752.15	8755.35	2132.0
2019-04-02 20:00:00	NQ	Futures	8755.06	8798.44	8750.11	8792.33	10849.0
2019-04-02 21:00:00	NQ	Futures	8792.33	8813.88	8778.65	8803.39	12312.0
2019-04-02 22:00:00	NQ	Futures	8803.69	8813.29	8799.9	8808.64	4485.0
2019-04-02 23:00:00	NQ	Futures	8808.64	8809.51	8802.23	8804.27	2397.0
2019-04-02 00:00:00	YM	Futures	28529.5	28540.4	28519.7	28528.4	2487.0
2019-04-02 01:00:00	YM	Futures	28529.5	28542.6	28523.0	28530.6	929.0
2019-04-02 02:00:00	YM	Futures	28530.6	28538.2	28516.5	28526.2	1505.0
2019-04-02 03:00:00	YM	Futures	28526.2	28537.1	28505.6	28521.9	2950.0

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

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