PREVIEW / etf_daily / 2015-09-28

all etf daily files

  file:    by_date/etf_daily/2015/2015-09-28.parquet
  size:    49 KB
  rows:    1,213

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-09-28	SPY	ETF	191.78	191.91	187.64	188.01	178515900.0
2015-09-28	QQQ	ETF	102.48	102.55	99.69	99.99	44077490.0
2015-09-28	IWM	ETF	111.05	111.15	107.88	108.3	56765300.0
2015-09-28	DIA	ETF	162.04	162.06	159.58	159.79	10013100.0
2015-09-28	GLD	ETF	108.37	108.91	108.27	108.42	3809600.0
2015-09-28	TLT	ETF	122.2	123.77	122.2	123.62	9833400.0
2015-09-28	AAXJ	ETF	51.66	51.75	51.03	51.19	955600.0
2015-09-28	ACTX	ETF	10.6201	15.3401	10.6201	14.7501	4226.0
2015-09-28	ACWF	ETF	22.17	22.17	21.9699	21.97	2890.0
2015-09-28	ACWI	ETF	53.83	53.83	52.78	52.85	1339200.0
2015-09-28	ACWV	ETF	66.77	67.14	65.9	65.92	201000.0
2015-09-28	ACWX	ETF	38.76	38.76	38.2	38.27	1413103.0
2015-09-28	ADRE	ETF	27.44	27.44	26.97	26.97	14630.0
2015-09-28	AFK	ETF	19.6	19.64	19.44	19.44	38984.0
2015-09-28	AFTY	ETF	14.88	14.88	14.77	14.77	11000.0
2015-09-28	AGG	ETF	109.19	109.41	109.11	109.37	1884400.0
2015-09-28	AGGY	ETF	49.65	49.77	49.61	49.71	3600.0
2015-09-28	AGQ	ETF	30.91	31.08	30.42	30.8	201900.0
2015-09-28	AGZ	ETF	113.58	113.995	113.58	113.92	22769.0
2015-09-28	AGZD	ETF	24.01	24.03	24.01	24.03	3000.0
2015-09-28	AIA	ETF	40.69	40.75	40.52	40.65	14966.0
2015-09-28	AIQ	ETF	9.97	10.17	9.68	10.0	54695.0
2015-09-28	AIRR	ETF	15.3	15.3	15.19	15.19	13500.0
2015-09-28	AIVI	ETF	37.84	37.84	37.36	37.48	26700.0
2015-09-28	AMJ	ETF	31.14	31.17	29.32	29.63	4910279.0
2015-09-28	AMLP	ETF	64.35	64.5	60.5	61.45	3400420.0
2015-09-28	AMZA	ETF	139.0	139.0	129.5	131.0	2020.0
2015-09-28	ANGL	ETF	25.98	25.98	25.55	25.63	43500.0
2015-09-28	AOA	ETF	43.58	43.58	42.92	43.03	52600.0
2015-09-28	AOK	ETF	31.47	31.48	31.32	31.34	55893.0
2015-09-28	AOM	ETF	33.74	33.77	33.51	33.63	89912.0
2015-09-28	AOR	ETF	38.1	38.1	37.7	37.7799	50950.0
2015-09-28	ARGT	ETF	15.79	15.96	15.6	15.62	3700.0
2015-09-28	ARKG	ETF	19.7	19.7	18.41	18.58	2800.0
2015-09-28	ARKK	ETF	19.0	19.0	19.0	19.0	600.0
2015-09-28	ARKQ	ETF	17.75	17.75	17.53	17.53	1400.0
2015-09-28	ARKW	ETF	21.31	21.335	21.0	21.024	1900.0
2015-09-28	ASEA	ETF	11.87	11.87	11.69	11.69	2600.0
2015-09-28	ASHR	ETF	31.95	32.16	31.77	31.77	1024400.0
2015-09-28	ASHS	ETF	36.74	36.74	35.91	35.91	30100.0
2015-09-28	ATMP	ETF	20.79	20.79	20.08	20.23	266700.0
2015-09-28	AWAY	ETF	26.6	26.86	25.97	26.0	1174463.0
2015-09-28	BAB	ETF	28.94	29.29	28.8401	29.12	186471.0
2015-09-28	BAL	ETF	40.52	40.54	40.34	40.35	3295.0
2015-09-28	BBC	ETF	28.8	28.8	26.19	26.51	68541.0
2015-09-28	BBH	ETF	114.72	115.0	108.05	109.89	739600.0
2015-09-28	BBP	ETF	28.55	28.6	26.66	27.28	58300.0
2015-09-28	BCHP	ETF	16.94	16.95	16.94	16.94	889.0
2015-09-28	BCM	ETF	26.445	26.49	26.44	26.47	6168.0
2015-09-28	BFOR	ETF	7.48	7.48	7.295	7.32	111600.0

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

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