PREVIEW / etf_1hour / 2014-08-14

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-08-14.parquet
  size:    218 KB
  rows:    6,909

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
2014-08-14 04:00:00	SPY	ETF	194.9	195.01	194.86	194.96	1765.0
2014-08-14 05:00:00	SPY	ETF	194.89	194.93	194.87	194.87	6516.0
2014-08-14 06:00:00	SPY	ETF	194.98	195.4	194.98	195.28	66666.0
2014-08-14 07:00:00	SPY	ETF	195.36	195.36	195.2	195.29	132706.0
2014-08-14 08:00:00	SPY	ETF	195.26	195.33	194.81	194.98	755942.0
2014-08-14 09:00:00	SPY	ETF	194.98	195.33	194.96	195.2	8237373.0
2014-08-14 10:00:00	SPY	ETF	195.21	195.49	194.98	195.24	10315814.0
2014-08-14 11:00:00	SPY	ETF	195.25	195.55	195.23	195.49	5964899.0
2014-08-14 12:00:00	SPY	ETF	195.49	195.56	195.38	195.48	5186546.0
2014-08-14 13:00:00	SPY	ETF	195.49	195.72	195.4	195.48	6255756.0
2014-08-14 14:00:00	SPY	ETF	195.48	195.61	195.401	195.55	5380168.0
2014-08-14 15:00:00	SPY	ETF	195.55	195.75	195.54	195.74	9897915.0
2014-08-14 16:00:00	SPY	ETF	195.73	196.01	195.2433	195.95	4154140.0
2014-08-14 17:00:00	SPY	ETF	195.95	196.04	195.93	195.96	120103.0
2014-08-14 18:00:00	SPY	ETF	195.97	195.97	195.86	195.88	111021.0
2014-08-14 19:00:00	SPY	ETF	195.89	195.91	195.82	195.82	54598.0
2014-08-14 04:00:00	QQQ	ETF	96.35	96.44	96.26	96.44	10620.0
2014-08-14 05:00:00	QQQ	ETF	96.39	96.39	96.36	96.36	5120.0
2014-08-14 06:00:00	QQQ	ETF	96.5	96.67	96.48	96.55	43450.0
2014-08-14 07:00:00	QQQ	ETF	96.56	96.6	96.54	96.58	36569.0
2014-08-14 08:00:00	QQQ	ETF	96.58	96.61	96.4	96.46	180703.0
2014-08-14 09:00:00	QQQ	ETF	96.48	96.65	96.43	96.6	3744736.0
2014-08-14 10:00:00	QQQ	ETF	96.61	96.69	96.45	96.63	3583514.0
2014-08-14 11:00:00	QQQ	ETF	96.625	96.74	96.6	96.7299	1754010.0
2014-08-14 12:00:00	QQQ	ETF	96.73	96.75	96.65	96.701	1415587.0
2014-08-14 13:00:00	QQQ	ETF	96.7	96.85	96.67	96.79	2004593.0
2014-08-14 14:00:00	QQQ	ETF	96.79	96.86	96.75	96.845	2464895.0
2014-08-14 15:00:00	QQQ	ETF	96.8499	96.95	96.81	96.93	4797848.0
2014-08-14 16:00:00	QQQ	ETF	96.93	97.1	96.4513	97.07	2943061.0
2014-08-14 17:00:00	QQQ	ETF	97.07	97.13	97.05	97.09	29568.0
2014-08-14 18:00:00	QQQ	ETF	97.08	97.08	97.03	97.03	22520.0
2014-08-14 19:00:00	QQQ	ETF	97.06	97.06	97.01	97.01	15220.0
2014-08-14 06:00:00	IWM	ETF	113.6	113.61	113.6	113.61	10000.0
2014-08-14 07:00:00	IWM	ETF	113.51	113.55	113.5	113.52	6000.0
2014-08-14 08:00:00	IWM	ETF	113.57	113.6	113.25	113.38	168165.0
2014-08-14 09:00:00	IWM	ETF	113.4	113.73	113.32	113.51	2601467.0
2014-08-14 10:00:00	IWM	ETF	113.52	113.65	113.23	113.496	2813572.0
2014-08-14 11:00:00	IWM	ETF	113.5	113.65	113.38	113.57	1770514.0
2014-08-14 12:00:00	IWM	ETF	113.57	113.675	113.53	113.625	943977.0
2014-08-14 13:00:00	IWM	ETF	113.63	113.73	113.3333	113.42	2266306.0
2014-08-14 14:00:00	IWM	ETF	113.42	113.57	113.33	113.51	1748117.0
2014-08-14 15:00:00	IWM	ETF	113.52	113.6	113.49	113.59	2861457.0
2014-08-14 16:00:00	IWM	ETF	113.6	113.83	113.3351	113.79	902949.0
2014-08-14 17:00:00	IWM	ETF	113.8	113.86	113.8	113.84	13072.0
2014-08-14 18:00:00	IWM	ETF	113.73	113.73	113.71	113.71	400.0
2014-08-14 19:00:00	IWM	ETF	113.71	114.03	113.71	114.03	12668.0
2014-08-14 09:00:00	DIA	ETF	166.53	166.77	166.53	166.65	461468.0
2014-08-14 10:00:00	DIA	ETF	166.67	166.79	166.46	166.65	399183.0
2014-08-14 11:00:00	DIA	ETF	166.65	166.91	166.64	166.9	245343.0
2014-08-14 12:00:00	DIA	ETF	166.91	166.95	166.81	166.87	144618.0

> showing 50 of 6,909 rows — these rows as CSV

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