PREVIEW / etf_daily / 2016-03-30

all etf daily files

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

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-30	SPY	ETF	206.3	206.87	205.59	206.02	86365300.0
2016-03-30	QQQ	ETF	109.48	110.04	109.13	109.36	23807235.0
2016-03-30	IWM	ETF	110.89	111.12	110.05	110.32	35683500.0
2016-03-30	DIA	ETF	177.11	177.65	176.51	176.89	3858000.0
2016-03-30	GLD	ETF	117.88	118.2	116.91	117.1	10769100.0
2016-03-30	TLT	ETF	130.03	130.07	128.98	129.69	8478700.0
2016-03-30	AAXJ	ETF	54.9	55.2	54.85	54.85	1050000.0
2016-03-30	ACTX	ETF	6.4901	7.0801	5.9001	6.4901	426.0
2016-03-30	ACWI	ETF	56.24	56.57	56.21	56.33	1170500.0
2016-03-30	ACWV	ETF	73.95	73.95	73.72	73.78	305800.0
2016-03-30	ACWX	ETF	39.79	40.03	39.75	39.8	1287960.0
2016-03-30	ADRE	ETF	31.11	31.3301	31.11	31.3301	5876.0
2016-03-30	AFK	ETF	18.65	19.2	18.65	19.06	80602.0
2016-03-30	AFTY	ETF	13.11	13.14	13.025	13.05	31500.0
2016-03-30	AGG	ETF	110.49	110.56	110.31	110.48	2764500.0
2016-03-30	AGGY	ETF	50.244	50.47	50.244	50.372	2500.0
2016-03-30	AGQ	ETF	32.56	32.84	31.86	31.98	157600.0
2016-03-30	AGZ	ETF	114.72	114.7789	114.41	114.6999	35800.0
2016-03-30	AGZD	ETF	23.955	23.955	23.745	23.825	3800.0
2016-03-30	AIA	ETF	43.71	43.8799	43.64	43.64	25868.0
2016-03-30	AIQ	ETF	7.36	7.36	7.1	7.13	16323.0
2016-03-30	AIRR	ETF	17.55	17.684	17.55	17.61	2700.0
2016-03-30	AIVI	ETF	38.58	38.76	38.52	38.61	8600.0
2016-03-30	ALTY	ETF	14.27	14.27	14.27	14.27	100.0
2016-03-30	AMJ	ETF	26.53	26.95	26.42	26.6	1393687.0
2016-03-30	AMLP	ETF	53.1	54.25	52.75	53.55	2560760.0
2016-03-30	AMUB	ETF	16.74	16.74	16.74	16.74	170.0
2016-03-30	AMZA	ETF	87.5	91.7	86.45	89.7	2550.0
2016-03-30	ANGL	ETF	25.68	25.73	25.58	25.73	32500.0
2016-03-30	AOA	ETF	45.45	45.61	45.3	45.44	44200.0
2016-03-30	AOK	ETF	32.29	32.34	32.259	32.2701	52652.0
2016-03-30	AOM	ETF	34.8	34.8799	34.73	34.83	89377.0
2016-03-30	AOR	ETF	39.55	39.61	39.45	39.5	104820.0
2016-03-30	ARGT	ETF	19.31	19.44	19.19	19.26	58800.0
2016-03-30	ARKG	ETF	17.5	17.5	17.5	17.5	100.0
2016-03-30	ARKK	ETF	19.1	19.1	18.9	18.9	1400.0
2016-03-30	ARKQ	ETF	18.99	18.99	18.884	18.9	1400.0
2016-03-30	ARKW	ETF	20.69	20.69	20.549	20.594	2400.0
2016-03-30	ASEA	ETF	13.46	13.51	13.46	13.5	4700.0
2016-03-30	ASET	ETF	25.7	25.7	25.7	25.7	1270.0
2016-03-30	ASHR	ETF	24.79	24.95	24.71	24.84	2419600.0
2016-03-30	ASHS	ETF	35.1	35.19	34.83	34.83	85600.0
2016-03-30	ASHX	ETF	22.04	22.12	22.04	22.11	2025.0
2016-03-30	ATMP	ETF	17.83	18.05	17.73	17.8	33400.0
2016-03-30	BAB	ETF	30.0	30.08	29.9	30.05	157404.0
2016-03-30	BAL	ETF	37.76	37.76	37.5654	37.63	4612.0
2016-03-30	BBC	ETF	19.23	19.24	18.32	18.53	20540.0
2016-03-30	BBH	ETF	102.29	103.88	100.87	101.08	56700.0
2016-03-30	BBP	ETF	23.97	24.77	23.85	23.99	17100.0
2016-03-30	BCM	ETF	24.67	24.67	24.411	24.4214	1912.0

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

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