PREVIEW / futures_1hour / 2017-02-01

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-02-01.parquet
  size:    55 KB
  rows:    1,665

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-02-01 00:00:00	ES	Futures	2484.93	2485.47	2484.65	2484.93	2254.0
2017-02-01 01:00:00	ES	Futures	2484.93	2489.29	2484.65	2488.74	8537.0
2017-02-01 02:00:00	ES	Futures	2488.74	2488.74	2485.47	2487.11	9521.0
2017-02-01 03:00:00	ES	Futures	2486.83	2488.2	2485.2	2486.02	20590.0
2017-02-01 04:00:00	ES	Futures	2486.29	2487.65	2485.74	2487.11	8415.0
2017-02-01 05:00:00	ES	Futures	2487.38	2489.02	2486.83	2487.11	12241.0
2017-02-01 06:00:00	ES	Futures	2487.38	2487.65	2486.02	2486.56	6587.0
2017-02-01 07:00:00	ES	Futures	2486.29	2488.2	2486.29	2487.93	13509.0
2017-02-01 08:00:00	ES	Futures	2487.65	2489.83	2486.83	2488.47	27027.0
2017-02-01 09:00:00	ES	Futures	2488.47	2493.11	2487.65	2488.74	176832.0
2017-02-01 10:00:00	ES	Futures	2489.02	2490.65	2477.29	2478.38	287491.0
2017-02-01 11:00:00	ES	Futures	2478.65	2481.65	2474.83	2477.83	220655.0
2017-02-01 12:00:00	ES	Futures	2477.56	2481.11	2476.74	2479.74	130710.0
2017-02-01 13:00:00	ES	Futures	2480.02	2482.2	2476.47	2478.65	95166.0
2017-02-01 14:00:00	ES	Futures	2478.38	2485.2	2475.65	2479.2	222031.0
2017-02-01 15:00:00	ES	Futures	2479.47	2484.65	2479.2	2482.2	204142.0
2017-02-01 16:00:00	ES	Futures	2482.2	2483.29	2481.11	2481.92	79486.0
2017-02-01 18:00:00	ES	Futures	2482.2	2482.47	2478.38	2479.47	5905.0
2017-02-01 19:00:00	ES	Futures	2479.2	2479.47	2476.2	2476.74	6351.0
2017-02-01 20:00:00	ES	Futures	2476.47	2479.2	2476.47	2477.29	5262.0
2017-02-01 21:00:00	ES	Futures	2477.29	2478.11	2476.74	2477.01	2933.0
2017-02-01 22:00:00	ES	Futures	2477.01	2477.29	2471.56	2472.38	12467.0
2017-02-01 23:00:00	ES	Futures	2472.38	2473.74	2472.1	2473.2	5600.0
2017-02-01 00:00:00	NQ	Futures	6121.52	6123.31	6121.52	6122.12	527.0
2017-02-01 01:00:00	NQ	Futures	6122.12	6132.56	6121.82	6131.67	1630.0
2017-02-01 02:00:00	NQ	Futures	6131.67	6131.67	6123.91	6128.38	1560.0
2017-02-01 03:00:00	NQ	Futures	6128.38	6131.96	6125.7	6128.38	3702.0
2017-02-01 04:00:00	NQ	Futures	6128.38	6131.67	6127.79	6131.07	1315.0
2017-02-01 05:00:00	NQ	Futures	6131.37	6134.05	6129.28	6131.07	2466.0
2017-02-01 06:00:00	NQ	Futures	6131.37	6132.86	6129.88	6131.07	1291.0
2017-02-01 07:00:00	NQ	Futures	6131.07	6137.04	6131.07	6136.14	2677.0
2017-02-01 08:00:00	NQ	Futures	6136.14	6141.81	6135.54	6139.42	6664.0
2017-02-01 09:00:00	NQ	Futures	6139.12	6155.23	6137.63	6140.02	37000.0
2017-02-01 10:00:00	NQ	Futures	6140.32	6145.69	6116.15	6118.54	41278.0
2017-02-01 11:00:00	NQ	Futures	6118.24	6127.49	6113.77	6120.93	23534.0
2017-02-01 12:00:00	NQ	Futures	6121.22	6135.25	6120.93	6131.67	15777.0
2017-02-01 13:00:00	NQ	Futures	6131.67	6137.04	6123.01	6126.0	14699.0
2017-02-01 14:00:00	NQ	Futures	6126.3	6147.18	6122.72	6138.23	35628.0
2017-02-01 15:00:00	NQ	Futures	6138.23	6150.16	6137.93	6141.51	26886.0
2017-02-01 16:00:00	NQ	Futures	6141.51	6149.27	6139.72	6144.79	11520.0
2017-02-01 18:00:00	NQ	Futures	6142.7	6142.7	6131.67	6134.35	1436.0
2017-02-01 19:00:00	NQ	Futures	6134.35	6134.95	6123.61	6125.4	1647.0
2017-02-01 20:00:00	NQ	Futures	6126.0	6131.37	6125.4	6127.19	1589.0
2017-02-01 21:00:00	NQ	Futures	6126.89	6131.37	6124.51	6126.0	1135.0
2017-02-01 22:00:00	NQ	Futures	6125.7	6126.3	6115.85	6117.05	2446.0
2017-02-01 23:00:00	NQ	Futures	6117.05	6119.43	6116.75	6118.24	1219.0
2017-02-01 00:00:00	YM	Futures	21492.5	21500.1	21491.4	21499.0	542.0
2017-02-01 01:00:00	YM	Futures	21499.0	21532.6	21497.9	21530.4	1573.0
2017-02-01 02:00:00	YM	Futures	21529.3	21529.3	21502.2	21509.8	1934.0
2017-02-01 03:00:00	YM	Futures	21509.8	21522.8	21495.7	21504.4	3066.0

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

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