PREVIEW / futures_1hour / 2019-08-02

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-08-02.parquet
  size:    52 KB
  rows:    1,526

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-02 00:00:00	ES	Futures	3188.36	3193.24	3188.09	3191.88	9379.0
2019-08-02 01:00:00	ES	Futures	3191.88	3192.7	3189.99	3192.42	11160.0
2019-08-02 02:00:00	ES	Futures	3192.7	3194.86	3189.72	3192.15	26460.0
2019-08-02 03:00:00	ES	Futures	3192.15	3194.86	3178.08	3181.87	77632.0
2019-08-02 04:00:00	ES	Futures	3181.6	3186.2	3178.08	3181.33	45533.0
2019-08-02 05:00:00	ES	Futures	3181.6	3185.12	3176.45	3183.22	39955.0
2019-08-02 06:00:00	ES	Futures	3183.22	3191.07	3182.68	3188.64	37172.0
2019-08-02 07:00:00	ES	Futures	3188.36	3189.18	3183.76	3184.57	30138.0
2019-08-02 08:00:00	ES	Futures	3184.57	3188.36	3175.91	3187.82	94648.0
2019-08-02 09:00:00	ES	Futures	3187.82	3206.23	3174.56	3176.99	386259.0
2019-08-02 10:00:00	ES	Futures	3176.99	3181.33	3155.61	3156.15	335117.0
2019-08-02 11:00:00	ES	Futures	3156.15	3171.85	3154.8	3166.71	247561.0
2019-08-02 12:00:00	ES	Futures	3166.71	3176.45	3164.54	3164.81	177520.0
2019-08-02 13:00:00	ES	Futures	3165.08	3165.63	3157.77	3161.29	134095.0
2019-08-02 14:00:00	ES	Futures	3161.29	3174.02	3159.4	3169.69	155345.0
2019-08-02 15:00:00	ES	Futures	3169.96	3188.91	3162.92	3174.83	369595.0
2019-08-02 16:00:00	ES	Futures	3174.56	3178.62	3171.31	3177.54	77202.0
2019-08-02 00:00:00	NQ	Futures	9028.65	9044.32	9026.62	9040.26	2920.0
2019-08-02 01:00:00	NQ	Futures	9040.55	9043.16	9032.42	9043.16	2601.0
2019-08-02 02:00:00	NQ	Futures	9043.16	9052.15	9031.55	9042.0	6846.0
2019-08-02 03:00:00	NQ	Futures	9041.71	9050.41	8984.26	8997.9	16602.0
2019-08-02 04:00:00	NQ	Futures	8997.9	9010.08	8980.2	8992.09	11220.0
2019-08-02 05:00:00	NQ	Futures	8992.38	9007.76	8977.88	8997.61	8444.0
2019-08-02 06:00:00	NQ	Futures	8997.61	9026.62	8996.45	9017.63	9078.0
2019-08-02 07:00:00	NQ	Futures	9017.34	9019.37	8996.74	8999.06	6927.0
2019-08-02 08:00:00	NQ	Futures	8999.06	9012.4	8964.82	9003.7	27715.0
2019-08-02 09:00:00	NQ	Futures	9002.54	9057.09	8958.44	8970.04	117453.0
2019-08-02 10:00:00	NQ	Futures	8970.04	8988.32	8881.84	8885.03	110227.0
2019-08-02 11:00:00	NQ	Futures	8885.03	8936.68	8884.16	8914.34	87501.0
2019-08-02 12:00:00	NQ	Futures	8914.34	8946.83	8901.86	8905.34	63799.0
2019-08-02 13:00:00	NQ	Futures	8905.34	8909.11	8878.65	8891.71	49579.0
2019-08-02 14:00:00	NQ	Futures	8891.42	8930.58	8881.55	8914.92	56300.0
2019-08-02 15:00:00	NQ	Futures	8915.21	8965.69	8896.64	8937.84	93105.0
2019-08-02 16:00:00	NQ	Futures	8937.55	8947.7	8926.23	8945.67	11343.0
2019-08-02 00:00:00	YM	Futures	28812.2	28851.4	28811.1	28842.7	2011.0
2019-08-02 01:00:00	YM	Futures	28842.7	28848.1	28829.6	28847.0	2123.0
2019-08-02 02:00:00	YM	Futures	28847.0	28871.0	28820.9	28849.2	4754.0
2019-08-02 03:00:00	YM	Futures	28848.1	28869.9	28733.9	28774.2	12485.0
2019-08-02 04:00:00	YM	Futures	28772.0	28807.9	28741.5	28764.4	7782.0
2019-08-02 05:00:00	YM	Futures	28763.3	28792.7	28724.1	28774.2	6089.0
2019-08-02 06:00:00	YM	Futures	28773.1	28844.9	28769.8	28824.2	6534.0
2019-08-02 07:00:00	YM	Futures	28824.2	28834.0	28787.2	28799.2	4731.0
2019-08-02 08:00:00	YM	Futures	28797.0	28828.5	28724.1	28822.0	13520.0
2019-08-02 09:00:00	YM	Futures	28822.0	28996.0	28685.0	28701.3	62503.0
2019-08-02 10:00:00	YM	Futures	28700.2	28739.4	28515.3	28515.3	45494.0
2019-08-02 11:00:00	YM	Futures	28515.3	28669.8	28506.6	28617.6	37948.0
2019-08-02 12:00:00	YM	Futures	28616.5	28702.4	28599.1	28615.4	27072.0
2019-08-02 13:00:00	YM	Futures	28615.4	28628.4	28562.1	28608.9	21759.0
2019-08-02 14:00:00	YM	Futures	28608.9	28725.2	28594.7	28687.2	25504.0
2019-08-02 15:00:00	YM	Futures	28688.3	28860.1	28630.6	28765.5	46310.0

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

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