PREVIEW / futures_1hour / 2017-02-02

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-02-02.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-02 00:00:00	ES	Futures	2473.2	2473.74	2470.74	2471.01	6610.0
2017-02-02 01:00:00	ES	Futures	2471.01	2472.92	2470.74	2472.65	6137.0
2017-02-02 02:00:00	ES	Futures	2472.65	2472.92	2471.29	2472.65	7070.0
2017-02-02 03:00:00	ES	Futures	2472.65	2476.2	2471.83	2473.2	20345.0
2017-02-02 04:00:00	ES	Futures	2473.47	2474.29	2472.1	2472.92	9474.0
2017-02-02 05:00:00	ES	Futures	2472.92	2474.56	2471.56	2474.29	11551.0
2017-02-02 06:00:00	ES	Futures	2474.01	2476.47	2473.2	2475.11	12464.0
2017-02-02 07:00:00	ES	Futures	2475.11	2477.83	2474.56	2476.47	16388.0
2017-02-02 08:00:00	ES	Futures	2476.74	2477.01	2473.74	2474.56	26614.0
2017-02-02 09:00:00	ES	Futures	2474.56	2479.74	2473.2	2479.74	203564.0
2017-02-02 10:00:00	ES	Futures	2479.47	2486.29	2477.56	2486.02	203481.0
2017-02-02 11:00:00	ES	Futures	2486.02	2487.38	2477.01	2477.56	190296.0
2017-02-02 12:00:00	ES	Futures	2477.56	2483.83	2476.74	2482.74	117157.0
2017-02-02 13:00:00	ES	Futures	2482.74	2484.93	2478.92	2483.56	120102.0
2017-02-02 14:00:00	ES	Futures	2483.83	2483.83	2477.01	2478.92	151456.0
2017-02-02 15:00:00	ES	Futures	2478.92	2484.38	2478.11	2483.56	180277.0
2017-02-02 16:00:00	ES	Futures	2483.56	2484.38	2481.38	2481.38	85983.0
2017-02-02 18:00:00	ES	Futures	2481.11	2483.02	2481.11	2481.38	4067.0
2017-02-02 19:00:00	ES	Futures	2481.38	2482.2	2480.56	2481.92	2995.0
2017-02-02 20:00:00	ES	Futures	2481.65	2481.92	2479.74	2481.11	3677.0
2017-02-02 21:00:00	ES	Futures	2481.11	2481.11	2477.56	2477.56	6238.0
2017-02-02 22:00:00	ES	Futures	2477.56	2479.47	2477.29	2478.38	4654.0
2017-02-02 23:00:00	ES	Futures	2478.38	2478.92	2478.11	2478.65	1872.0
2017-02-02 00:00:00	NQ	Futures	6118.54	6118.84	6109.59	6110.19	2185.0
2017-02-02 01:00:00	NQ	Futures	6110.49	6115.56	6108.99	6114.96	1174.0
2017-02-02 02:00:00	NQ	Futures	6115.56	6117.94	6112.57	6117.35	1458.0
2017-02-02 03:00:00	NQ	Futures	6117.64	6123.91	6114.36	6118.24	3032.0
2017-02-02 04:00:00	NQ	Futures	6118.54	6120.93	6114.66	6117.35	1258.0
2017-02-02 05:00:00	NQ	Futures	6117.35	6120.93	6114.06	6120.33	1397.0
2017-02-02 06:00:00	NQ	Futures	6120.33	6126.89	6118.84	6123.61	1845.0
2017-02-02 07:00:00	NQ	Futures	6123.31	6132.86	6121.82	6128.09	2929.0
2017-02-02 08:00:00	NQ	Futures	6128.09	6132.56	6125.7	6128.09	4660.0
2017-02-02 09:00:00	NQ	Futures	6127.79	6148.37	6113.77	6148.07	42150.0
2017-02-02 10:00:00	NQ	Futures	6148.07	6152.25	6137.04	6151.35	32691.0
2017-02-02 11:00:00	NQ	Futures	6151.35	6154.34	6126.59	6127.19	26194.0
2017-02-02 12:00:00	NQ	Futures	6127.49	6139.72	6124.21	6133.75	19354.0
2017-02-02 13:00:00	NQ	Futures	6134.05	6139.72	6126.89	6135.84	12403.0
2017-02-02 14:00:00	NQ	Futures	6135.84	6136.44	6123.01	6128.98	16050.0
2017-02-02 15:00:00	NQ	Futures	6129.28	6139.42	6128.09	6135.84	19257.0
2017-02-02 16:00:00	NQ	Futures	6135.84	6136.74	6117.05	6120.93	11864.0
2017-02-02 18:00:00	NQ	Futures	6120.93	6124.21	6117.35	6120.33	1413.0
2017-02-02 19:00:00	NQ	Futures	6120.03	6122.42	6117.35	6122.12	654.0
2017-02-02 20:00:00	NQ	Futures	6121.82	6122.12	6116.75	6119.73	1026.0
2017-02-02 21:00:00	NQ	Futures	6119.43	6119.43	6109.89	6110.19	1277.0
2017-02-02 22:00:00	NQ	Futures	6109.89	6116.75	6109.29	6114.66	1360.0
2017-02-02 23:00:00	NQ	Futures	6114.66	6115.56	6112.27	6114.66	375.0
2017-02-02 00:00:00	YM	Futures	21430.6	21431.7	21407.9	21411.1	1337.0
2017-02-02 01:00:00	YM	Futures	21411.1	21431.7	21408.9	21430.6	1548.0
2017-02-02 02:00:00	YM	Futures	21430.6	21433.9	21418.7	21430.6	1745.0
2017-02-02 03:00:00	YM	Futures	21431.7	21452.3	21419.8	21428.5	3722.0

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

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