PREVIEW / etf_daily / 2016-03-29

all etf daily files

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

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-29	SPY	ETF	202.76	205.25	202.4	205.12	92922900.0
2016-03-29	QQQ	ETF	106.93	108.9	106.73	108.83	29963923.0
2016-03-29	IWM	ETF	107.04	110.34	106.77	110.31	46761100.0
2016-03-29	DIA	ETF	174.49	176.18	174.06	176.07	5584100.0
2016-03-29	GLD	ETF	117.36	118.81	116.8	118.76	14472400.0
2016-03-29	TLT	ETF	130.38	131.09	130.02	131.07	9396700.0
2016-03-29	AADR	ETF	37.61	38.22	37.61	37.94	6700.0
2016-03-29	AAXJ	ETF	53.29	54.12	53.19	54.12	341500.0
2016-03-29	ACTX	ETF	6.4901	7.6701	5.9001	5.9001	1313.0
2016-03-29	ACWI	ETF	55.16	56.0	55.07	55.98	2960000.0
2016-03-29	ACWV	ETF	72.62	73.5	72.62	73.43	167400.0
2016-03-29	ACWX	ETF	38.8	39.445	38.73	39.44	602248.0
2016-03-29	ADRE	ETF	30.1375	30.77	30.1375	30.77	29249.0
2016-03-29	AFK	ETF	19.3	19.37	18.6301	19.37	65976.0
2016-03-29	AFTY	ETF	12.61	12.745	12.6	12.705	22200.0
2016-03-29	AGG	ETF	110.35	110.57	110.21	110.52	1885900.0
2016-03-29	AGGY	ETF	50.2	50.416	50.19	50.39	7000.0
2016-03-29	AGQ	ETF	32.14	32.58	31.58	32.54	179000.0
2016-03-29	AGZ	ETF	114.47	114.745	114.398	114.745	15187.0
2016-03-29	AGZD	ETF	23.91	23.955	23.91	23.955	600.0
2016-03-29	AIA	ETF	42.33	43.05	42.31	42.99	10966.0
2016-03-29	AIQ	ETF	7.0	7.19	6.93	7.16	27023.0
2016-03-29	AIRR	ETF	17.16	17.57	17.16	17.56	2200.0
2016-03-29	AIVI	ETF	37.58	38.16	37.5	38.14	29900.0
2016-03-29	AMJ	ETF	25.75	26.21	25.3	26.09	2488208.0
2016-03-29	AMLP	ETF	51.15	52.6	50.75	52.35	1672380.0
2016-03-29	AMZA	ETF	86.0	87.4	83.65	86.7	3800.0
2016-03-29	ANGL	ETF	25.68	25.75	25.51	25.66	65800.0
2016-03-29	AOA	ETF	44.76	45.24	44.63	45.2	66300.0
2016-03-29	AOK	ETF	32.1	32.2604	32.0007	32.26	23145.0
2016-03-29	AOM	ETF	34.5	34.74	34.42	34.7	81185.0
2016-03-29	AOR	ETF	38.99	39.36	38.9015	39.36	125064.0
2016-03-29	ARGT	ETF	18.89	19.21	18.74	19.02	26100.0
2016-03-29	ARKG	ETF	17.0	17.0	17.0	17.0	500.0
2016-03-29	ARKK	ETF	18.835	18.835	18.835	18.835	300.0
2016-03-29	ARKQ	ETF	18.43	18.83	18.32	18.83	700.0
2016-03-29	ARKW	ETF	20.06	20.52	20.06	20.52	1500.0
2016-03-29	ASHR	ETF	23.69	24.14	23.65	23.91	2304300.0
2016-03-29	ASHS	ETF	33.43	33.8	33.1	33.54	24900.0
2016-03-29	ATMP	ETF	16.99	17.52	16.89	17.33	328000.0
2016-03-29	BAB	ETF	30.0	30.15	29.91	30.08	116078.0
2016-03-29	BAL	ETF	37.47	37.5	37.3994	37.4	5632.0
2016-03-29	BBC	ETF	17.8268	18.8005	17.3377	18.8005	17301.0
2016-03-29	BBH	ETF	100.34	101.81	98.93	101.78	161200.0
2016-03-29	BBP	ETF	23.26	23.94	23.102	23.94	2400.0
2016-03-29	BCM	ETF	24.41	24.52	24.41	24.52	7279.0
2016-03-29	BFOR	ETF	7.3575	7.5225	7.3575	7.5175	60000.0
2016-03-29	BIB	ETF	37.86	39.7	36.76	39.67	975938.0
2016-03-29	BICK	ETF	19.62	19.83	19.6101	19.83	674.0
2016-03-29	BIL	ETF	91.38	91.4	91.38	91.38	631250.0

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

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