PREVIEW / etf_daily / 2015-09-14

all etf daily files

  file:    by_date/etf_daily/2015/2015-09-14.parquet
  size:    48 KB
  rows:    1,198

schema

  date         DATE
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

date	symbol	asset_type	open	high	low	close	volume
2015-09-14	SPY	ETF	196.95	197.01	195.43	196.01	79452000.0
2015-09-14	QQQ	ETF	105.96	105.98	104.85	105.25	19718804.0
2015-09-14	IWM	ETF	115.52	115.54	114.43	114.65	22365800.0
2015-09-14	DIA	ETF	164.46	164.58	163.37	163.77	4595600.0
2015-09-14	GLD	ETF	105.86	106.39	105.78	106.22	2350800.0
2015-09-14	TLT	ETF	121.95	122.15	121.28	121.58	4221700.0
2015-09-14	AAXJ	ETF	53.43	53.47	53.16	53.37	474800.0
2015-09-14	ACTX	ETF	2.95	2.95	2.36	2.95	331.0
2015-09-14	ACWI	ETF	55.19	55.23	54.94	55.15	1518100.0
2015-09-14	ACWV	ETF	67.13	67.19	66.83	66.95	89100.0
2015-09-14	ACWX	ETF	40.04	40.0999	39.87	40.09	1363309.0
2015-09-14	ADRE	ETF	29.08	29.1	28.96	29.0916	3640.0
2015-09-14	AFK	ETF	20.06	20.19	20.06	20.12	6577.0
2015-09-14	AFTY	ETF	15.04	15.24	15.0	15.17	117100.0
2015-09-14	AGG	ETF	109.18	109.2	109.04	109.09	1543600.0
2015-09-14	AGQ	ETF	30.25	30.28	29.9	30.25	74200.0
2015-09-14	AGZ	ETF	113.45	113.55	113.2901	113.38	11181.0
2015-09-14	AGZD	ETF	24.005	24.03	24.0	24.03	3200.0
2015-09-14	AIA	ETF	42.35	42.35	42.15	42.33	31748.0
2015-09-14	AIQ	ETF	14.822	15.77	14.822	15.61	10706.0
2015-09-14	AIRR	ETF	16.39	16.39	16.27	16.29	35200.0
2015-09-14	AIVI	ETF	39.49	39.53	39.36	39.5	59900.0
2015-09-14	AMJ	ETF	33.38	33.5611	33.12	33.23	2331768.0
2015-09-14	AMLP	ETF	69.05	69.5	68.55	68.65	1224420.0
2015-09-14	AMZA	ETF	155.0	158.1	152.6	152.6	1430.0
2015-09-14	ANGL	ETF	26.67	26.67	26.53	26.55	7500.0
2015-09-14	AOA	ETF	44.47	44.47	44.26	44.38	26200.0
2015-09-14	AOK	ETF	31.7799	31.7799	31.6038	31.7	26358.0
2015-09-14	AOM	ETF	34.23	34.23	34.03	34.11	126369.0
2015-09-14	AOR	ETF	38.81	38.81	38.54	38.59	62486.0
2015-09-14	ARGT	ETF	17.65	17.7	17.53	17.53	23500.0
2015-09-14	ARKG	ETF	21.63	21.65	21.52	21.65	800.0
2015-09-14	ARKK	ETF	19.97	20.11	19.97	20.07	900.0
2015-09-14	ARKQ	ETF	18.1	18.1	18.1	18.1	300.0
2015-09-14	ARKW	ETF	21.91	21.91	21.91	21.91	100.0
2015-09-14	ASEA	ETF	12.58	12.58	12.53	12.53	3500.0
2015-09-14	ASHR	ETF	31.99	32.0	31.65	31.68	3071700.0
2015-09-14	ASHS	ETF	35.78	35.78	34.0	34.38	68500.0
2015-09-14	ATMP	ETF	22.6	22.72	22.47	22.48	20600.0
2015-09-14	AWAY	ETF	28.47	28.53	28.03	28.14	574855.0
2015-09-14	BAB	ETF	28.92	28.92	28.8	28.85	72686.0
2015-09-14	BAL	ETF	42.06	42.06	41.72	41.81	4510.0
2015-09-14	BBC	ETF	33.34	33.67	33.14	33.58	11339.0
2015-09-14	BBH	ETF	132.32	132.32	129.85	131.25	68000.0
2015-09-14	BBP	ETF	33.72	33.72	32.65	33.02	34500.0
2015-09-14	BCM	ETF	26.76	26.76	26.724	26.724	6794.0
2015-09-14	BFOR	ETF	7.7375	7.7375	7.68	7.6925	238800.0
2015-09-14	BIB	ETF	81.15	81.8999	79.0	80.63	380332.0
2015-09-14	BICK	ETF	19.21	19.255	19.21	19.23	692.0
2015-09-14	BIL	ETF	91.38	91.4	91.38	91.4	457050.0

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

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