PREVIEW / etf_daily / 2015-02-20

all etf daily files

  file:    by_date/etf_daily/2015/2015-02-20.parquet
  size:    47 KB
  rows:    1,166

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-02-20	SPY	ETF	209.48	211.33	208.73	211.24	140896400.0
2015-02-20	QQQ	ETF	107.62	108.47	107.28	108.41	28336710.0
2015-02-20	IWM	ETF	121.85	122.54	120.9	122.38	30331600.0
2015-02-20	DIA	ETF	179.15	181.2	178.5	181.14	8914600.0
2015-02-20	GLD	ETF	116.1	116.46	115.05	115.28	6681700.0
2015-02-20	TLT	ETF	127.05	128.01	126.0	126.54	12502500.0
2015-02-20	AADR	ETF	38.99	38.99	38.56	38.56	400.0
2015-02-20	AAXJ	ETF	63.35	63.75	63.13	63.66	1084700.0
2015-02-20	ACWI	ETF	60.52	61.06	60.28	61.01	969100.0
2015-02-20	ACWV	ETF	71.2	71.62	71.04	71.58	81900.0
2015-02-20	ACWX	ETF	44.85	45.32	44.7	45.21	300162.0
2015-02-20	ADRE	ETF	36.39	36.69	36.39	36.68	9507.0
2015-02-20	AFK	ETF	25.51	26.15	25.51	26.11	16325.0
2015-02-20	AGG	ETF	110.68	110.88	110.37	110.55	2280700.0
2015-02-20	AGQ	ETF	40.95	41.3	39.81	40.02	215400.0
2015-02-20	AGZ	ETF	113.91	114.4	113.3501	114.3	43910.0
2015-02-20	AGZD	ETF	24.56	24.63	24.545	24.575	11000.0
2015-02-20	AIA	ETF	49.06	49.2842	48.83	49.28	23018.0
2015-02-20	AIQ	ETF	25.03	25.23	24.78	25.08	11146.0
2015-02-20	AIRR	ETF	17.93	18.14	17.93	18.125	20900.0
2015-02-20	AIVI	ETF	44.91	45.69	44.86	45.57	49600.0
2015-02-20	ALTL	ETF	37.71	37.92	37.71	37.92	625.0
2015-02-20	AMJ	ETF	45.56	46.08	45.251	45.99	1326525.0
2015-02-20	AMLP	ETF	85.3	86.1	85.2	86.05	891100.0
2015-02-20	AMZA	ETF	222.6	225.0	222.6	225.0	310.0
2015-02-20	ANGL	ETF	27.4	27.5	27.29	27.34	5000.0
2015-02-20	AOA	ETF	47.56	47.88	47.35	47.88	39200.0
2015-02-20	AOK	ETF	32.8	32.89	32.74	32.87	38703.0
2015-02-20	AOM	ETF	35.5	35.63	35.415	35.63	43562.0
2015-02-20	AOR	ETF	40.62	41.01	40.48	41.01	72044.0
2015-02-20	ARGT	ETF	19.9	19.9	19.77	19.87	1600.0
2015-02-20	ARKG	ETF	23.39	23.39	23.27	23.39	2000.0
2015-02-20	ARKK	ETF	21.75	21.75	21.57	21.684	800.0
2015-02-20	ARKQ	ETF	20.12	20.3	20.12	20.28	2100.0
2015-02-20	ARKW	ETF	22.35	22.37	22.35	22.37	500.0
2015-02-20	ASEA	ETF	15.72	15.83	15.64	15.83	6100.0
2015-02-20	ASHR	ETF	35.85	36.08	35.8	36.05	288400.0
2015-02-20	ASHS	ETF	38.42	38.71	38.4	38.71	900.0
2015-02-20	ATMP	ETF	30.44	30.74	30.38	30.74	218000.0
2015-02-20	AVIV	ETF	35.82	36.34	35.81	36.25	122218.0
2015-02-20	AWAY	ETF	30.66	31.11	30.6	30.985	1968300.0
2015-02-20	BAB	ETF	29.95	30.18	29.65	29.66	196521.0
2015-02-20	BAL	ETF	43.78	44.145	43.607	44.01	10417.0
2015-02-20	BALT	ETF	1.7	1.72	1.63	1.69	675644.0
2015-02-20	BAR	ETF	2.858	2.858	2.8	2.816	28050.0
2015-02-20	BBC	ETF	30.9	30.9	30.38	30.661	61898.0
2015-02-20	BBH	ETF	125.07	127.18	125.07	127.17	93900.0
2015-02-20	BBP	ETF	30.11	30.11	29.5	29.749	15200.0
2015-02-20	BFOR	ETF	8.1475	8.2	8.1	8.1875	60400.0
2015-02-20	BIB	ETF	74.385	76.45	74.095	76.45	571574.0

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

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