PREVIEW / etf_1hour / 2016-10-17

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-10-17.parquet
  size:    250 KB
  rows:    8,095

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-10-17 04:00:00	SPY	ETF	212.75	212.75	212.44	212.59	2807.0
2016-10-17 05:00:00	SPY	ETF	212.5	212.5	212.23	212.35	3776.0
2016-10-17 06:00:00	SPY	ETF	212.4	212.65	212.4	212.57	2964.0
2016-10-17 07:00:00	SPY	ETF	212.68	212.98	212.56	212.89	194145.0
2016-10-17 08:00:00	SPY	ETF	212.7	213.09	212.431	213.04	735540.0
2016-10-17 09:00:00	SPY	ETF	213.04	213.39	212.5	212.61	7916370.0
2016-10-17 10:00:00	SPY	ETF	212.62	213.28	212.47	212.82	9415927.0
2016-10-17 11:00:00	SPY	ETF	212.81	213.045	212.5689	212.93	5122837.0
2016-10-17 12:00:00	SPY	ETF	212.93	212.96	212.53	212.625	4411125.0
2016-10-17 13:00:00	SPY	ETF	212.62	212.74	212.17	212.22	5896282.0
2016-10-17 14:00:00	SPY	ETF	212.225	212.7	212.21	212.659	5968157.0
2016-10-17 15:00:00	SPY	ETF	212.65	212.66	212.27	212.4	12753547.0
2016-10-17 16:00:00	SPY	ETF	212.41	212.83	212.38	212.58	3156231.0
2016-10-17 17:00:00	SPY	ETF	212.38	212.68	212.38	212.68	303620.0
2016-10-17 18:00:00	SPY	ETF	212.63	212.64	212.45	212.61	68045.0
2016-10-17 19:00:00	SPY	ETF	212.62	212.79	212.54	212.76	20543.0
2016-10-17 04:00:00	QQQ	ETF	117.0	117.0	116.73	116.73	13799.0
2016-10-17 05:00:00	QQQ	ETF	116.7	116.7	116.68	116.68	400.0
2016-10-17 06:00:00	QQQ	ETF	116.74	116.79	116.74	116.79	200.0
2016-10-17 07:00:00	QQQ	ETF	116.83	116.95	116.83	116.92	22481.0
2016-10-17 08:00:00	QQQ	ETF	116.94	117.09	116.9	117.05	69352.0
2016-10-17 09:00:00	QQQ	ETF	117.08	117.17	116.672	116.71	2063953.0
2016-10-17 10:00:00	QQQ	ETF	116.71	117.3	116.7	117.07	1858417.0
2016-10-17 11:00:00	QQQ	ETF	117.07	117.17	116.92	117.081	1389139.0
2016-10-17 12:00:00	QQQ	ETF	117.08	117.14	116.87	116.94	867125.0
2016-10-17 13:00:00	QQQ	ETF	116.95	117.01	116.7	116.72	1295442.0
2016-10-17 14:00:00	QQQ	ETF	116.73	116.96	116.73	116.94	1334634.0
2016-10-17 15:00:00	QQQ	ETF	116.94	116.95	116.74	116.81	3613661.0
2016-10-17 16:00:00	QQQ	ETF	116.83	117.25	116.81	117.1	937132.0
2016-10-17 17:00:00	QQQ	ETF	117.15	117.15	117.11	117.15	4355.0
2016-10-17 18:00:00	QQQ	ETF	117.15	117.17	117.07	117.12	23566.0
2016-10-17 19:00:00	QQQ	ETF	117.16	117.26	117.15	117.25	14500.0
2016-10-17 04:00:00	IWM	ETF	120.14	120.14	120.14	120.14	475.0
2016-10-17 07:00:00	IWM	ETF	120.22	120.36	120.2	120.27	3201.0
2016-10-17 08:00:00	IWM	ETF	120.25	120.5	120.22	120.5	34410.0
2016-10-17 09:00:00	IWM	ETF	120.47	120.74	120.35	120.43	2364734.0
2016-10-17 10:00:00	IWM	ETF	120.44	120.83	120.23	120.42	2197932.0
2016-10-17 11:00:00	IWM	ETF	120.41	120.75	120.27	120.675	1392395.0
2016-10-17 12:00:00	IWM	ETF	120.68	120.85	120.59	120.69	1895570.0
2016-10-17 13:00:00	IWM	ETF	120.68	120.7295	120.16	120.19	2056714.0
2016-10-17 14:00:00	IWM	ETF	120.21	120.47	120.2	120.43	1076162.0
2016-10-17 15:00:00	IWM	ETF	120.43	120.43	120.2	120.29	2794320.0
2016-10-17 16:00:00	IWM	ETF	120.3	120.51	120.29	120.29	1387609.0
2016-10-17 17:00:00	IWM	ETF	120.42	120.5	120.29	120.4	377259.0
2016-10-17 18:00:00	IWM	ETF	120.45	120.5	120.44	120.49	11365.0
2016-10-17 19:00:00	IWM	ETF	120.48	120.49	120.44	120.49	8821.0
2016-10-17 08:00:00	DIA	ETF	181.18	181.19	180.98	181.19	1495.0
2016-10-17 09:00:00	DIA	ETF	181.16	181.51	180.7	180.82	320161.0
2016-10-17 10:00:00	DIA	ETF	180.83	181.378	180.74	181.0501	237887.0
2016-10-17 11:00:00	DIA	ETF	181.05	181.13	180.8001	181.02	274063.0

> showing 50 of 8,095 rows — these rows as CSV

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