PREVIEW / futures_1hour / 2017-03-09

all futures 1-hour files

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

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-09 00:00:00	ES	Futures	2578.76	2579.58	2578.21	2578.76	2295.0
2017-03-09 01:00:00	ES	Futures	2578.76	2579.58	2578.21	2579.03	1871.0
2017-03-09 02:00:00	ES	Futures	2579.03	2580.39	2578.76	2580.12	8044.0
2017-03-09 03:00:00	ES	Futures	2580.12	2582.3	2578.76	2581.76	13981.0
2017-03-09 04:00:00	ES	Futures	2581.49	2581.76	2579.58	2580.39	7037.0
2017-03-09 05:00:00	ES	Futures	2580.12	2580.39	2576.58	2576.58	16735.0
2017-03-09 06:00:00	ES	Futures	2576.3	2577.39	2574.39	2577.39	19107.0
2017-03-09 07:00:00	ES	Futures	2577.39	2577.67	2573.57	2574.39	20784.0
2017-03-09 08:00:00	ES	Futures	2574.39	2580.67	2574.39	2580.39	38681.0
2017-03-09 09:00:00	ES	Futures	2580.12	2582.85	2576.58	2580.94	158086.0
2017-03-09 10:00:00	ES	Futures	2580.94	2585.03	2578.76	2581.49	169518.0
2017-03-09 11:00:00	ES	Futures	2581.49	2583.39	2579.3	2580.94	107494.0
2017-03-09 12:00:00	ES	Futures	2580.94	2582.58	2579.03	2580.67	53506.0
2017-03-09 13:00:00	ES	Futures	2580.67	2582.03	2576.03	2576.58	77572.0
2017-03-09 14:00:00	ES	Futures	2576.58	2577.12	2568.39	2574.67	209578.0
2017-03-09 15:00:00	ES	Futures	2574.67	2581.76	2574.39	2580.12	258480.0
2017-03-09 16:00:00	ES	Futures	2580.12	2583.67	2579.58	2583.39	49731.0
2017-03-09 18:00:00	ES	Futures	2583.12	2586.4	2581.76	2585.58	8456.0
2017-03-09 19:00:00	ES	Futures	2585.3	2587.49	2584.76	2585.85	5032.0
2017-03-09 20:00:00	ES	Futures	2585.85	2588.3	2585.85	2587.76	5541.0
2017-03-09 21:00:00	ES	Futures	2587.76	2589.4	2587.76	2588.3	3891.0
2017-03-09 22:00:00	ES	Futures	2588.3	2589.12	2587.76	2588.3	2794.0
2017-03-09 23:00:00	ES	Futures	2588.58	2589.4	2587.76	2589.12	3938.0
2017-03-09 00:00:00	NQ	Futures	6396.87	6400.45	6396.28	6398.07	613.0
2017-03-09 01:00:00	NQ	Futures	6397.77	6399.56	6397.17	6398.36	485.0
2017-03-09 02:00:00	NQ	Futures	6398.36	6399.56	6395.38	6398.36	1607.0
2017-03-09 03:00:00	NQ	Futures	6398.36	6403.44	6392.99	6401.94	3177.0
2017-03-09 04:00:00	NQ	Futures	6401.65	6403.44	6397.77	6399.26	1600.0
2017-03-09 05:00:00	NQ	Futures	6398.96	6399.56	6393.29	6393.29	2496.0
2017-03-09 06:00:00	NQ	Futures	6393.29	6395.68	6389.41	6395.08	2981.0
2017-03-09 07:00:00	NQ	Futures	6395.38	6395.98	6388.22	6390.91	2708.0
2017-03-09 08:00:00	NQ	Futures	6390.91	6400.45	6390.91	6399.56	8013.0
2017-03-09 09:00:00	NQ	Futures	6399.56	6404.33	6380.76	6400.15	38130.0
2017-03-09 10:00:00	NQ	Futures	6400.15	6410.3	6393.29	6402.24	31071.0
2017-03-09 11:00:00	NQ	Futures	6402.54	6407.31	6395.68	6402.24	19995.0
2017-03-09 12:00:00	NQ	Futures	6402.24	6405.22	6396.87	6401.94	12721.0
2017-03-09 13:00:00	NQ	Futures	6401.94	6404.03	6388.22	6389.12	16263.0
2017-03-09 14:00:00	NQ	Futures	6389.12	6390.01	6366.74	6385.54	37859.0
2017-03-09 15:00:00	NQ	Futures	6385.24	6406.42	6384.94	6401.05	35267.0
2017-03-09 16:00:00	NQ	Futures	6400.75	6409.4	6399.26	6409.4	3917.0
2017-03-09 18:00:00	NQ	Futures	6407.91	6410.89	6403.73	6410.0	558.0
2017-03-09 19:00:00	NQ	Futures	6409.4	6415.96	6408.51	6413.28	865.0
2017-03-09 20:00:00	NQ	Futures	6413.88	6418.65	6412.38	6417.75	884.0
2017-03-09 21:00:00	NQ	Futures	6417.75	6420.44	6416.86	6418.35	579.0
2017-03-09 22:00:00	NQ	Futures	6418.05	6420.74	6417.46	6419.54	275.0
2017-03-09 23:00:00	NQ	Futures	6420.14	6421.93	6418.65	6421.63	416.0
2017-03-09 00:00:00	YM	Futures	22629.3	22634.7	22625.0	22633.6	769.0
2017-03-09 01:00:00	YM	Futures	22633.6	22640.1	22627.1	22633.6	599.0
2017-03-09 02:00:00	YM	Futures	22632.6	22641.2	22626.0	22635.8	1625.0
2017-03-09 03:00:00	YM	Futures	22635.8	22647.7	22621.7	22643.4	3024.0

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

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