PREVIEW / etf_daily / 2016-03-15

all etf daily files

  file:    by_date/etf_daily/2016/2016-03-15.parquet
  size:    50 KB
  rows:    1,250

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
2016-03-15	SPY	ETF	201.36	202.53	201.05	202.17	93169100.0
2016-03-15	QQQ	ETF	106.27	106.75	105.95	106.63	26524632.0
2016-03-15	IWM	ETF	107.21	107.28	106.03	106.24	34258400.0
2016-03-15	DIA	ETF	171.61	172.67	171.32	172.64	2431600.0
2016-03-15	GLD	ETF	117.78	118.04	117.36	117.96	9941800.0
2016-03-15	TLT	ETF	128.5	128.66	127.61	127.88	6413200.0
2016-03-15	AADR	ETF	37.27	37.27	37.15	37.16	5400.0
2016-03-15	AAXJ	ETF	52.34	52.5	52.16	52.48	378600.0
2016-03-15	ACTX	ETF	4.13	4.13	4.13	4.13	15.0
2016-03-15	ACWF	ETF	22.4399	22.4399	22.4	22.4	767.0
2016-03-15	ACWI	ETF	54.85	54.9	54.66	54.88	2216800.0
2016-03-15	ACWV	ETF	71.42	71.65	71.33	71.6	183100.0
2016-03-15	ACWX	ETF	38.73	38.74	38.58	38.72	658232.0
2016-03-15	ADRE	ETF	29.31	29.39	29.16	29.2499	7376.0
2016-03-15	AFK	ETF	18.3567	18.75	18.255	18.75	8788.0
2016-03-15	AFTY	ETF	12.39	12.47	12.36	12.41	32600.0
2016-03-15	AGG	ETF	109.68	109.7	109.38	109.38	1746100.0
2016-03-15	AGGY	ETF	49.82	49.902	49.76	49.76	10400.0
2016-03-15	AGQ	ETF	32.22	32.5	32.03	32.37	118100.0
2016-03-15	AGZ	ETF	113.92	114.0299	113.745	113.82	13482.0
2016-03-15	AGZD	ETF	24.025	24.025	24.025	24.025	800.0
2016-03-15	AIA	ETF	41.58	41.67	41.49	41.59	6910.0
2016-03-15	AIQ	ETF	7.14	7.22	6.88	7.01	9565.0
2016-03-15	AIRR	ETF	16.62	16.72	16.62	16.719	3400.0
2016-03-15	AIVI	ETF	37.68	37.7	37.53	37.7	19400.0
2016-03-15	AMJ	ETF	25.99	25.99	25.31	25.87	2403045.0
2016-03-15	AMLP	ETF	52.1	52.5	51.0	52.05	1090900.0
2016-03-15	AMUB	ETF	16.09	16.09	16.02	16.02	300.0
2016-03-15	AMZA	ETF	86.7	86.7	83.13	85.4	4880.0
2016-03-15	ANGL	ETF	25.49	25.56	25.43	25.45	54900.0
2016-03-15	AOA	ETF	44.37	44.41	44.23	44.39	49600.0
2016-03-15	AOK	ETF	31.74	31.9	31.72	31.7601	21261.0
2016-03-15	AOM	ETF	34.14	34.2882	34.14	34.23	35215.0
2016-03-15	AOR	ETF	38.67	38.7747	38.61	38.7	29100.0
2016-03-15	ARGT	ETF	18.7	18.7	18.51	18.7	29900.0
2016-03-15	ARKG	ETF	17.03	17.03	16.62	16.62	500.0
2016-03-15	ARKK	ETF	18.0	18.0	17.84	17.84	400.0
2016-03-15	ARKQ	ETF	17.78	17.78	17.68	17.71	1400.0
2016-03-15	ARKW	ETF	19.81	19.81	19.81	19.81	400.0
2016-03-15	ASEA	ETF	13.01	13.02	12.94	13.02	1300.0
2016-03-15	ASHR	ETF	23.15	23.29	23.03	23.2	1202500.0
2016-03-15	ASHS	ETF	31.27	31.31	31.08	31.22	53400.0
2016-03-15	ASHX	ETF	20.61	20.61	20.61	20.61	212.0
2016-03-15	ATMP	ETF	17.18	17.31	17.06	17.31	299900.0
2016-03-15	BAB	ETF	29.87	29.87	29.71	29.76	163682.0
2016-03-15	BAL	ETF	38.22	38.26	37.9584	38.049	12822.0
2016-03-15	BBC	ETF	18.57	18.57	17.5	17.5185	17903.0
2016-03-15	BBH	ETF	101.82	101.96	99.58	99.82	77400.0
2016-03-15	BBP	ETF	24.37	24.37	23.26	23.26	12000.0
2016-03-15	BCM	ETF	24.36	24.36	24.26	24.3263	6562.0

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

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