PREVIEW / etf_daily / 2015-04-21

all etf daily files

  file:    by_date/etf_daily/2015/2015-04-21.parquet
  size:    47 KB
  rows:    1,176

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-21	SPY	ETF	210.67	210.86	209.24	209.6	72559800.0
2015-04-21	QQQ	ETF	108.22	108.41	107.93	108.06	22759772.0
2015-04-21	IWM	ETF	126.05	126.25	125.42	125.52	13844600.0
2015-04-21	DIA	ETF	180.7	180.88	178.97	179.26	3596600.0
2015-04-21	GLD	ETF	114.72	115.56	114.65	115.38	3317700.0
2015-04-21	TLT	ETF	130.23	130.45	129.56	129.7	4563800.0
2015-04-21	AADR	ETF	40.29	40.29	40.22	40.23	1300.0
2015-04-21	AAXJ	ETF	68.6	68.76	68.38	68.43	1119400.0
2015-04-21	ACWI	ETF	62.16	62.22	61.89	61.93	2212200.0
2015-04-21	ACWV	ETF	73.56	73.74	73.36	73.37	117200.0
2015-04-21	ACWX	ETF	46.9	46.93	46.75	46.83	227147.0
2015-04-21	ADRE	ETF	37.19	37.3876	37.14	37.14	22407.0
2015-04-21	AFK	ETF	26.23	26.399	26.16	26.1767	8966.0
2015-04-21	AFTY	ETF	22.7	22.715	22.6	22.63	138600.0
2015-04-21	AGG	ETF	111.57	111.6	111.44	111.47	1522700.0
2015-04-21	AGQ	ETF	38.32	38.86	38.1	38.49	98800.0
2015-04-21	AGZ	ETF	114.47	114.47	114.0701	114.15	11012.0
2015-04-21	AGZD	ETF	24.55	24.55	24.47	24.51	9800.0
2015-04-21	AIA	ETF	53.72	54.16	53.72	53.832	64704.0
2015-04-21	AIQ	ETF	24.47	24.47	24.05	24.23	8170.0
2015-04-21	AIRR	ETF	18.72	18.85	18.72	18.82	9100.0
2015-04-21	AIVI	ETF	45.48	45.6	45.32	45.42	73500.0
2015-04-21	AMJ	ETF	44.42	44.59	44.18	44.23	1162449.0
2015-04-21	AMLP	ETF	85.7	85.7	84.55	84.55	625140.0
2015-04-21	AMZA	ETF	220.0	220.5	218.9	219.2	8940.0
2015-04-21	ANGL	ETF	27.73	27.73	27.6	27.6	14300.0
2015-04-21	AOA	ETF	48.43	48.67	48.37	48.37	37900.0
2015-04-21	AOK	ETF	33.21	33.31	33.2	33.24	61687.0
2015-04-21	AOM	ETF	36.04	36.0699	35.91	35.91	37366.0
2015-04-21	AOR	ETF	41.5	41.602	41.4201	41.48	116261.0
2015-04-21	ARGT	ETF	21.61	21.64	21.5	21.63	14600.0
2015-04-21	ARKG	ETF	23.626	23.626	23.586	23.586	1400.0
2015-04-21	ARKK	ETF	21.67	21.67	21.592	21.592	2200.0
2015-04-21	ARKQ	ETF	20.4	20.4	20.38	20.38	1200.0
2015-04-21	ARKW	ETF	22.84	22.84	22.795	22.795	700.0
2015-04-21	ASEA	ETF	16.23	16.25	16.2	16.2	7300.0
2015-04-21	ASHR	ETF	47.47	47.65	47.3	47.45	1991300.0
2015-04-21	ASHS	ETF	52.47	53.82	52.47	53.57	58900.0
2015-04-21	ATMP	ETF	30.31	30.31	30.08	30.09	16300.0
2015-04-21	AWAY	ETF	31.6	31.84	31.44	31.51	1120698.0
2015-04-21	BAB	ETF	30.42	30.42	30.3306	30.37	101820.0
2015-04-21	BAL	ETF	42.82	42.82	42.68	42.75	3904.0
2015-04-21	BALT	ETF	1.53	1.54	1.5	1.53	367415.0
2015-04-21	BAR	ETF	2.742	2.752	2.723	2.75	16530.0
2015-04-21	BBC	ETF	34.88	34.98	34.6697	34.764	14728.0
2015-04-21	BBH	ETF	133.91	135.27	133.18	135.04	105000.0
2015-04-21	BBP	ETF	33.47	33.47	33.0	33.19	22500.0
2015-04-21	BCHP	ETF	19.86	19.86	19.78	19.78	362.0
2015-04-21	BCM	ETF	31.6	31.6	31.53	31.5654	1460.0
2015-04-21	BFOR	ETF	8.4975	8.4975	8.4375	8.4375	77200.0

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

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