PREVIEW / etf_daily / 2016-03-09

all etf daily files

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

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-09	SPY	ETF	199.36	199.79	198.43	199.38	94801200.0
2016-03-09	QQQ	ETF	104.57	104.84	103.96	104.82	31047351.0
2016-03-09	IWM	ETF	106.62	107.01	106.07	106.8	25627200.0
2016-03-09	DIA	ETF	170.41	170.59	169.54	170.02	3584000.0
2016-03-09	GLD	ETF	119.2	120.39	118.84	119.58	8672900.0
2016-03-09	TLT	ETF	129.08	129.69	128.81	129.19	7194700.0
2016-03-09	AADR	ETF	37.57	37.57	37.57	37.57	100.0
2016-03-09	AAXJ	ETF	51.87	52.14	51.77	51.84	838800.0
2016-03-09	ACTX	ETF	4.13	4.13	3.54	3.54	1020.0
2016-03-09	ACWI	ETF	54.22	54.4	54.09	54.3	921300.0
2016-03-09	ACWV	ETF	70.81	70.99	70.74	70.89	310200.0
2016-03-09	ACWX	ETF	38.36	38.51	38.29	38.39	626602.0
2016-03-09	ADRE	ETF	29.4	29.4516	29.28	29.32	3485.0
2016-03-09	AFK	ETF	18.33	18.52	18.27	18.475	44116.0
2016-03-09	AFTY	ETF	12.4	12.42	12.29	12.41	23300.0
2016-03-09	AGG	ETF	109.56	109.66	109.45	109.57	1468700.0
2016-03-09	AGGY	ETF	49.73	49.85	49.73	49.85	11300.0
2016-03-09	AGQ	ETF	32.3	33.07	32.05	32.38	167400.0
2016-03-09	AGZ	ETF	114.96	114.96	114.06	114.0701	15866.0
2016-03-09	AIA	ETF	40.79	41.0632	40.79	40.81	17207.0
2016-03-09	AIQ	ETF	8.13	8.13	7.96	8.07	9643.0
2016-03-09	AIRR	ETF	16.66	16.77	16.66	16.73	3300.0
2016-03-09	AIVI	ETF	37.45	37.58	37.39	37.47	13900.0
2016-03-09	ALTY	ETF	13.694	13.694	13.694	13.694	100.0
2016-03-09	AMJ	ETF	25.82	26.22	25.68	25.93	5600710.0
2016-03-09	AMLP	ETF	52.8	53.15	51.7	52.4	2347120.0
2016-03-09	AMZA	ETF	88.4	90.15	86.0	86.9	2860.0
2016-03-09	ANGL	ETF	25.14	25.25	25.08	25.16	127000.0
2016-03-09	AOA	ETF	43.96	44.05	43.89	43.98	60900.0
2016-03-09	AOK	ETF	31.71	31.728	31.64	31.68	43356.0
2016-03-09	AOM	ETF	34.04	34.11	33.97	34.03	56573.0
2016-03-09	AOR	ETF	38.4	38.5	38.36	38.42	109823.0
2016-03-09	ARGT	ETF	18.87	18.97	18.74	18.89	135600.0
2016-03-09	ARKG	ETF	17.3	17.3	17.03	17.06	4200.0
2016-03-09	ARKK	ETF	18.04	18.04	17.98	17.98	1100.0
2016-03-09	ARKQ	ETF	17.86	17.86	17.85	17.85	700.0
2016-03-09	ARKW	ETF	19.54	19.61	19.54	19.61	3100.0
2016-03-09	ASEA	ETF	12.93	12.99	12.93	12.99	700.0
2016-03-09	ASHR	ETF	23.08	23.16	22.96	23.08	2130200.0
2016-03-09	ASHS	ETF	30.94	31.18	30.78	30.78	40100.0
2016-03-09	ATMP	ETF	17.51	17.64	17.33	17.49	67800.0
2016-03-09	BAB	ETF	29.9	29.9799	29.88	29.89	126051.0
2016-03-09	BAL	ETF	36.83	37.0999	36.63	37.0999	7759.0
2016-03-09	BBC	ETF	18.5	18.5236	18.09	18.3996	10784.0
2016-03-09	BBH	ETF	102.82	102.82	100.39	101.25	95500.0
2016-03-09	BBP	ETF	24.56	24.56	24.02	24.323	2500.0
2016-03-09	BCM	ETF	24.765	24.765	24.722	24.722	1094.0
2016-03-09	BDCZ	ETF	19.44	19.44	19.38	19.38	300.0
2016-03-09	BFOR	ETF	7.285	7.31	7.275	7.2825	124800.0
2016-03-09	BIB	ETF	41.51	41.51	38.92	40.04	842423.0

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

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