PREVIEW / etf_daily / 2015-04-13

all etf daily files

  file:    by_date/etf_daily/2015/2015-04-13.parquet
  size:    48 KB
  rows:    1,174

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-04-13	SPY	ETF	209.87	210.63	209.03	209.09	74436600.0
2015-04-13	QQQ	ETF	107.83	108.38	107.36	107.48	17783465.0
2015-04-13	IWM	ETF	125.69	126.39	125.58	125.7	22819200.0
2015-04-13	DIA	ETF	180.17	180.86	179.49	179.64	3358200.0
2015-04-13	GLD	ETF	115.35	115.39	114.8	115.14	3190100.0
2015-04-13	TLT	ETF	129.53	129.98	129.39	129.8	4010600.0
2015-04-13	AADR	ETF	40.28	40.28	40.28	40.28	300.0
2015-04-13	AAXJ	ETF	68.61	68.86	68.27	68.32	1542600.0
2015-04-13	ACWI	ETF	61.7	61.91	61.49	61.53	660300.0
2015-04-13	ACWV	ETF	73.44	73.44	72.93	72.96	168600.0
2015-04-13	ACWX	ETF	46.41	46.5361	46.24	46.285	114395.0
2015-04-13	ADRE	ETF	36.86	37.054	36.65	36.6825	6522.0
2015-04-13	AFK	ETF	26.12	26.305	26.12	26.23	29912.0
2015-04-13	AFTY	ETF	21.22	21.44	21.16	21.21	25500.0
2015-04-13	AGG	ETF	111.25	111.37	111.25	111.37	951000.0
2015-04-13	AGQ	ETF	40.19	40.23	39.83	39.87	110200.0
2015-04-13	AGZ	ETF	114.11	114.24	113.86	114.02	10124.0
2015-04-13	AGZD	ETF	24.52	24.595	24.47	24.48	62800.0
2015-04-13	AIA	ETF	53.83	54.51	53.53	53.58	34415.0
2015-04-13	AIQ	ETF	24.09	24.49	23.93	24.33	18177.0
2015-04-13	AIRR	ETF	19.04	19.09	19.0	19.012	3200.0
2015-04-13	AIVI	ETF	44.99	45.06	44.74	44.8	28200.0
2015-04-13	AMJ	ETF	43.55	43.8599	43.49	43.56	498492.0
2015-04-13	AMLP	ETF	84.1	84.25	83.65	83.65	456280.0
2015-04-13	AMZA	ETF	215.2	215.3	214.0	214.0	220.0
2015-04-13	ANGL	ETF	27.54	27.54	27.37	27.46	27400.0
2015-04-13	AOA	ETF	48.45	48.45	48.12	48.17	54200.0
2015-04-13	AOK	ETF	33.26	33.27	33.14	33.15	127535.0
2015-04-13	AOM	ETF	35.83	35.99	35.77	35.91	41735.0
2015-04-13	AOR	ETF	41.57	41.57	41.28	41.2949	94382.0
2015-04-13	ARGT	ETF	22.07	22.14	21.81	21.86	15400.0
2015-04-13	ARKG	ETF	23.4	23.6	23.4	23.412	6900.0
2015-04-13	ARKK	ETF	21.618	21.618	21.53	21.53	300.0
2015-04-13	ARKQ	ETF	20.64	20.64	20.6	20.6	600.0
2015-04-13	ARKW	ETF	22.72	22.72	22.665	22.665	800.0
2015-04-13	ASEA	ETF	15.91	15.91	15.82	15.82	1600.0
2015-04-13	ASHR	ETF	45.55	45.59	44.79	45.02	2150300.0
2015-04-13	ASHS	ETF	54.27	54.27	53.47	53.62	115200.0
2015-04-13	ATMP	ETF	29.76	29.87	29.63	29.65	54700.0
2015-04-13	AWAY	ETF	32.05	32.38	31.88	32.31	782674.0
2015-04-13	BAB	ETF	30.3	30.432	30.3	30.39	74883.0
2015-04-13	BAL	ETF	44.57	44.8	44.51	44.528	14291.0
2015-04-13	BALT	ETF	1.41	1.415	1.38	1.39	932005.0
2015-04-13	BAR	ETF	2.75	2.75	2.75	2.75	10430.0
2015-04-13	BBC	ETF	34.01	34.621	33.99	34.21	43204.0
2015-04-13	BBH	ETF	133.21	134.84	133.16	133.35	242700.0
2015-04-13	BBP	ETF	32.93	33.3	32.91	33.035	24600.0
2015-04-13	BCM	ETF	31.17	31.175	30.87	30.87	3298.0
2015-04-13	BFOR	ETF	8.44	8.4675	8.4225	8.4225	81600.0
2015-04-13	BIB	ETF	85.935	87.79	85.34	86.0	879856.0

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

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