PREVIEW / futures_1hour / 2017-03-02

all futures 1-hour files

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

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-03-02 00:00:00	ES	Futures	2608.22	2610.13	2608.22	2609.85	2897.0
2017-03-02 01:00:00	ES	Futures	2609.85	2611.76	2609.58	2611.22	5102.0
2017-03-02 02:00:00	ES	Futures	2611.22	2611.49	2608.76	2610.13	7407.0
2017-03-02 03:00:00	ES	Futures	2610.4	2611.22	2608.76	2609.58	27006.0
2017-03-02 04:00:00	ES	Futures	2609.31	2609.85	2607.13	2608.49	18677.0
2017-03-02 05:00:00	ES	Futures	2608.22	2609.85	2607.4	2609.03	20317.0
2017-03-02 06:00:00	ES	Futures	2609.31	2609.31	2607.13	2608.49	12299.0
2017-03-02 07:00:00	ES	Futures	2608.76	2610.4	2608.49	2609.85	13228.0
2017-03-02 08:00:00	ES	Futures	2609.85	2612.31	2609.31	2611.49	34172.0
2017-03-02 09:00:00	ES	Futures	2611.22	2611.49	2605.22	2608.76	200821.0
2017-03-02 10:00:00	ES	Futures	2608.76	2608.76	2604.4	2604.94	202247.0
2017-03-02 11:00:00	ES	Futures	2604.94	2604.94	2599.49	2604.13	247264.0
2017-03-02 12:00:00	ES	Futures	2604.13	2604.4	2600.31	2603.03	128397.0
2017-03-02 13:00:00	ES	Futures	2602.76	2603.85	2601.12	2602.76	77322.0
2017-03-02 14:00:00	ES	Futures	2602.76	2605.49	2600.58	2604.4	138722.0
2017-03-02 15:00:00	ES	Futures	2604.4	2604.4	2595.94	2597.03	422926.0
2017-03-02 16:00:00	ES	Futures	2597.31	2599.49	2594.58	2597.58	128251.0
2017-03-02 18:00:00	ES	Futures	2596.49	2597.58	2594.85	2596.21	8640.0
2017-03-02 19:00:00	ES	Futures	2596.49	2597.03	2595.12	2595.12	4911.0
2017-03-02 20:00:00	ES	Futures	2595.4	2596.76	2594.58	2594.58	5096.0
2017-03-02 21:00:00	ES	Futures	2594.58	2595.67	2594.58	2594.85	2305.0
2017-03-02 22:00:00	ES	Futures	2594.85	2595.67	2591.58	2592.4	11463.0
2017-03-02 23:00:00	ES	Futures	2592.4	2592.94	2590.76	2591.3	6957.0
2017-03-02 00:00:00	NQ	Futures	6420.44	6425.51	6420.44	6425.21	878.0
2017-03-02 01:00:00	NQ	Futures	6424.91	6430.58	6424.32	6430.28	1177.0
2017-03-02 02:00:00	NQ	Futures	6429.99	6429.99	6421.93	6426.11	1959.0
2017-03-02 03:00:00	NQ	Futures	6426.11	6429.09	6423.12	6425.21	3102.0
2017-03-02 04:00:00	NQ	Futures	6424.91	6426.7	6420.44	6424.02	1804.0
2017-03-02 05:00:00	NQ	Futures	6423.72	6427.9	6421.04	6426.7	1722.0
2017-03-02 06:00:00	NQ	Futures	6426.7	6426.7	6420.74	6425.51	1592.0
2017-03-02 07:00:00	NQ	Futures	6425.51	6429.39	6425.21	6427.9	1555.0
2017-03-02 08:00:00	NQ	Futures	6427.6	6436.25	6427.6	6434.16	4782.0
2017-03-02 09:00:00	NQ	Futures	6434.16	6435.65	6417.46	6427.0	29954.0
2017-03-02 10:00:00	NQ	Futures	6427.3	6428.2	6412.68	6413.58	25619.0
2017-03-02 11:00:00	NQ	Futures	6413.28	6415.37	6401.35	6412.38	30099.0
2017-03-02 12:00:00	NQ	Futures	6412.09	6412.98	6401.05	6408.21	15949.0
2017-03-02 13:00:00	NQ	Futures	6408.21	6408.8	6401.65	6406.72	12404.0
2017-03-02 14:00:00	NQ	Futures	6407.01	6412.68	6403.44	6410.89	15764.0
2017-03-02 15:00:00	NQ	Futures	6410.59	6410.59	6391.5	6399.26	39793.0
2017-03-02 16:00:00	NQ	Futures	6399.26	6402.54	6392.4	6396.87	7123.0
2017-03-02 18:00:00	NQ	Futures	6394.49	6397.47	6392.4	6395.98	1245.0
2017-03-02 19:00:00	NQ	Futures	6395.98	6397.17	6392.1	6392.1	857.0
2017-03-02 20:00:00	NQ	Futures	6392.1	6396.57	6390.61	6391.5	1142.0
2017-03-02 21:00:00	NQ	Futures	6391.2	6394.78	6391.2	6391.8	645.0
2017-03-02 22:00:00	NQ	Futures	6391.8	6393.59	6380.46	6382.55	2114.0
2017-03-02 23:00:00	NQ	Futures	6382.55	6383.75	6378.38	6380.76	1509.0
2017-03-02 00:00:00	YM	Futures	22874.5	22890.7	22871.2	22889.6	955.0
2017-03-02 01:00:00	YM	Futures	22889.6	22909.2	22887.5	22908.1	1735.0
2017-03-02 02:00:00	YM	Futures	22905.9	22905.9	22883.1	22890.7	1916.0
2017-03-02 03:00:00	YM	Futures	22891.8	22902.7	22883.1	22889.6	3072.0

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

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