PREVIEW / futures_1hour / 2017-05-02

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-05-02.parquet
  size:    53 KB
  rows:    1,655

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
2017-05-02 00:00:00	ES	Futures	2606.88	2607.15	2606.06	2606.6	1505.0
2017-05-02 01:00:00	ES	Futures	2606.6	2606.88	2604.96	2604.96	4621.0
2017-05-02 02:00:00	ES	Futures	2604.96	2607.42	2604.96	2607.42	5965.0
2017-05-02 03:00:00	ES	Futures	2607.42	2607.7	2604.96	2607.15	13030.0
2017-05-02 04:00:00	ES	Futures	2606.88	2607.15	2604.96	2605.51	9304.0
2017-05-02 05:00:00	ES	Futures	2605.51	2607.97	2605.24	2607.15	9384.0
2017-05-02 06:00:00	ES	Futures	2607.42	2607.7	2605.24	2606.33	5931.0
2017-05-02 07:00:00	ES	Futures	2606.33	2606.88	2605.78	2606.88	4910.0
2017-05-02 08:00:00	ES	Futures	2606.88	2608.24	2606.33	2608.24	13729.0
2017-05-02 09:00:00	ES	Futures	2608.24	2609.88	2602.78	2602.78	159738.0
2017-05-02 10:00:00	ES	Futures	2603.05	2605.78	2602.23	2603.87	127303.0
2017-05-02 11:00:00	ES	Futures	2603.87	2605.78	2603.05	2605.24	95848.0
2017-05-02 12:00:00	ES	Futures	2605.24	2609.06	2604.96	2607.97	101889.0
2017-05-02 13:00:00	ES	Futures	2607.97	2608.79	2605.78	2606.33	59409.0
2017-05-02 14:00:00	ES	Futures	2606.06	2607.7	2603.33	2604.15	89492.0
2017-05-02 15:00:00	ES	Futures	2604.15	2607.97	2603.05	2607.7	164150.0
2017-05-02 16:00:00	ES	Futures	2607.7	2608.24	2604.69	2605.51	59652.0
2017-05-02 18:00:00	ES	Futures	2604.69	2605.78	2602.78	2605.51	4656.0
2017-05-02 19:00:00	ES	Futures	2605.51	2606.06	2604.96	2605.51	1248.0
2017-05-02 20:00:00	ES	Futures	2605.24	2605.78	2604.96	2605.51	1853.0
2017-05-02 21:00:00	ES	Futures	2605.78	2605.78	2604.69	2604.96	1649.0
2017-05-02 22:00:00	ES	Futures	2604.96	2605.24	2603.6	2603.6	2738.0
2017-05-02 23:00:00	ES	Futures	2603.87	2603.87	2602.51	2603.33	4275.0
2017-05-02 00:00:00	NQ	Futures	6717.4	6717.69	6715.31	6717.1	410.0
2017-05-02 01:00:00	NQ	Futures	6716.5	6716.8	6713.22	6714.42	1119.0
2017-05-02 02:00:00	NQ	Futures	6714.42	6719.78	6714.42	6719.19	1868.0
2017-05-02 03:00:00	NQ	Futures	6719.48	6720.68	6715.61	6720.08	2080.0
2017-05-02 04:00:00	NQ	Futures	6719.78	6719.78	6716.5	6719.48	2026.0
2017-05-02 05:00:00	NQ	Futures	6719.19	6723.06	6717.69	6722.47	1647.0
2017-05-02 06:00:00	NQ	Futures	6722.76	6723.96	6717.99	6719.19	1823.0
2017-05-02 07:00:00	NQ	Futures	6718.89	6720.08	6717.99	6720.08	1199.0
2017-05-02 08:00:00	NQ	Futures	6720.08	6725.15	6719.48	6724.25	4019.0
2017-05-02 09:00:00	NQ	Futures	6724.25	6724.85	6707.56	6709.35	33917.0
2017-05-02 10:00:00	NQ	Futures	6709.35	6718.89	6705.17	6717.1	25130.0
2017-05-02 11:00:00	NQ	Futures	6717.1	6722.76	6714.71	6719.78	15657.0
2017-05-02 12:00:00	NQ	Futures	6720.08	6728.13	6720.08	6725.15	16871.0
2017-05-02 13:00:00	NQ	Futures	6725.45	6727.24	6717.4	6718.89	10912.0
2017-05-02 14:00:00	NQ	Futures	6718.89	6723.96	6714.71	6715.61	11888.0
2017-05-02 15:00:00	NQ	Futures	6715.31	6726.34	6714.71	6725.74	22074.0
2017-05-02 16:00:00	NQ	Futures	6726.34	6726.94	6705.17	6705.47	10096.0
2017-05-02 18:00:00	NQ	Futures	6703.38	6707.86	6697.72	6705.77	1984.0
2017-05-02 19:00:00	NQ	Futures	6705.77	6709.35	6705.47	6707.56	680.0
2017-05-02 20:00:00	NQ	Futures	6707.56	6710.24	6706.66	6709.35	916.0
2017-05-02 21:00:00	NQ	Futures	6709.35	6709.65	6707.26	6708.75	539.0
2017-05-02 22:00:00	NQ	Futures	6708.75	6709.94	6706.07	6706.37	828.0
2017-05-02 23:00:00	NQ	Futures	6706.37	6706.37	6702.19	6703.38	1253.0
2017-05-02 00:00:00	YM	Futures	22678.1	22680.2	22674.8	22679.2	248.0
2017-05-02 01:00:00	YM	Futures	22678.1	22682.4	22662.9	22665.0	727.0
2017-05-02 02:00:00	YM	Futures	22666.1	22686.8	22666.1	22685.7	1279.0
2017-05-02 03:00:00	YM	Futures	22686.8	22686.8	22666.1	22681.3	2011.0

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

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