PREVIEW / futures_1hour / 2016-04-14

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-04-14.parquet
  size:    52 KB
  rows:    1,608

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
2016-04-14 00:00:00	ES	Futures	2238.67	2240.56	2238.67	2239.21	3370.0
2016-04-14 01:00:00	ES	Futures	2239.21	2241.64	2238.13	2240.83	7475.0
2016-04-14 02:00:00	ES	Futures	2240.56	2242.18	2237.05	2237.59	14413.0
2016-04-14 03:00:00	ES	Futures	2237.32	2238.13	2233.81	2235.97	42662.0
2016-04-14 04:00:00	ES	Futures	2235.97	2238.13	2234.35	2237.32	25878.0
2016-04-14 05:00:00	ES	Futures	2237.32	2241.1	2235.43	2240.29	25357.0
2016-04-14 06:00:00	ES	Futures	2240.29	2241.91	2238.67	2241.1	14674.0
2016-04-14 07:00:00	ES	Futures	2240.83	2241.91	2238.67	2241.37	20894.0
2016-04-14 08:00:00	ES	Futures	2241.37	2245.69	2240.29	2244.61	52101.0
2016-04-14 09:00:00	ES	Futures	2244.61	2244.88	2237.32	2238.13	193102.0
2016-04-14 10:00:00	ES	Futures	2238.13	2243.53	2237.32	2242.18	217983.0
2016-04-14 11:00:00	ES	Futures	2241.91	2245.69	2240.56	2245.15	141376.0
2016-04-14 12:00:00	ES	Futures	2245.15	2247.31	2243.26	2246.5	109094.0
2016-04-14 13:00:00	ES	Futures	2246.5	2248.12	2242.18	2242.45	105089.0
2016-04-14 14:00:00	ES	Futures	2242.18	2244.88	2240.29	2242.45	119866.0
2016-04-14 15:00:00	ES	Futures	2242.45	2244.61	2240.83	2241.91	164740.0
2016-04-14 16:00:00	ES	Futures	2241.64	2244.07	2241.1	2243.8	65933.0
2016-04-14 18:00:00	ES	Futures	2243.8	2243.8	2241.37	2242.45	4292.0
2016-04-14 19:00:00	ES	Futures	2242.45	2242.99	2242.18	2242.18	1598.0
2016-04-14 20:00:00	ES	Futures	2242.45	2246.23	2241.64	2242.99	9020.0
2016-04-14 21:00:00	ES	Futures	2242.99	2244.07	2241.91	2244.07	6422.0
2016-04-14 22:00:00	ES	Futures	2244.07	2245.42	2241.64	2243.26	5443.0
2016-04-14 23:00:00	ES	Futures	2243.53	2243.53	2241.1	2241.37	3064.0
2016-04-14 00:00:00	NQ	Futures	5407.01	5411.77	5406.41	5408.49	488.0
2016-04-14 01:00:00	NQ	Futures	5408.49	5411.77	5403.73	5410.28	779.0
2016-04-14 02:00:00	NQ	Futures	5409.98	5414.15	5400.46	5401.35	1630.0
2016-04-14 03:00:00	NQ	Futures	5401.06	5404.03	5391.83	5398.97	3910.0
2016-04-14 04:00:00	NQ	Futures	5398.68	5405.52	5396.0	5404.03	2675.0
2016-04-14 05:00:00	NQ	Futures	5403.73	5411.77	5398.68	5410.28	1488.0
2016-04-14 06:00:00	NQ	Futures	5409.69	5412.66	5404.92	5409.09	1322.0
2016-04-14 07:00:00	NQ	Futures	5408.79	5412.36	5404.63	5409.39	1553.0
2016-04-14 08:00:00	NQ	Futures	5409.39	5418.91	5407.3	5414.45	4774.0
2016-04-14 09:00:00	NQ	Futures	5414.45	5415.04	5396.59	5401.95	27983.0
2016-04-14 10:00:00	NQ	Futures	5401.95	5416.83	5398.38	5412.66	28552.0
2016-04-14 11:00:00	NQ	Futures	5412.36	5422.78	5402.54	5422.48	20200.0
2016-04-14 12:00:00	NQ	Futures	5422.48	5426.64	5414.15	5425.45	13893.0
2016-04-14 13:00:00	NQ	Futures	5425.45	5430.81	5409.39	5409.39	13222.0
2016-04-14 14:00:00	NQ	Futures	5409.39	5415.93	5403.44	5411.17	16659.0
2016-04-14 15:00:00	NQ	Futures	5411.17	5418.31	5408.79	5411.17	16552.0
2016-04-14 16:00:00	NQ	Futures	5410.88	5413.85	5409.39	5413.55	4578.0
2016-04-14 18:00:00	NQ	Futures	5413.55	5414.15	5408.2	5410.58	372.0
2016-04-14 19:00:00	NQ	Futures	5410.58	5412.36	5409.69	5409.69	260.0
2016-04-14 20:00:00	NQ	Futures	5410.28	5420.1	5407.9	5413.85	1290.0
2016-04-14 21:00:00	NQ	Futures	5413.55	5416.83	5410.58	5416.23	636.0
2016-04-14 22:00:00	NQ	Futures	5416.23	5420.4	5410.28	5414.74	565.0
2016-04-14 23:00:00	NQ	Futures	5414.74	5415.04	5407.01	5408.79	577.0
2016-04-14 00:00:00	YM	Futures	19062.6	19075.4	19059.4	19061.5	593.0
2016-04-14 01:00:00	YM	Futures	19062.6	19078.6	19050.8	19071.1	1054.0
2016-04-14 02:00:00	YM	Futures	19070.1	19082.9	19048.7	19048.7	1824.0
2016-04-14 03:00:00	YM	Futures	19049.7	19057.2	19025.1	19041.2	4905.0

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

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