PREVIEW / etf_daily / 2015-01-23

all etf daily files

  file:    by_date/etf_daily/2015/2015-01-23.parquet
  size:    47 KB
  rows:    1,167

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-01-23	SPY	ETF	205.79	206.1	204.81	204.97	117516800.0
2015-01-23	QQQ	ETF	104.02	104.58	103.72	104.26	34782992.0
2015-01-23	IWM	ETF	118.24	118.77	117.55	118.12	28173400.0
2015-01-23	DIA	ETF	177.71	177.82	176.39	176.41	4795300.0
2015-01-23	GLD	ETF	124.43	124.5	123.35	124.23	6270900.0
2015-01-23	TLT	ETF	134.3	135.12	134.15	134.77	7334600.0
2015-01-23	AAXJ	ETF	63.87	64.04	63.81	63.83	870900.0
2015-01-23	ACWI	ETF	58.9	59.11	58.76	58.76	2648400.0
2015-01-23	ACWV	ETF	71.1	71.27	70.77	70.87	142800.0
2015-01-23	ACWX	ETF	43.43	43.6	43.34	43.35	666147.0
2015-01-23	ADRE	ETF	37.32	37.5391	37.32	37.34	26893.0
2015-01-23	AFK	ETF	25.83	25.988	25.49	25.67	36973.0
2015-01-23	AGG	ETF	111.65	111.81	111.54	111.71	1535000.0
2015-01-23	AGQ	ETF	51.02	51.49	50.15	51.18	337700.0
2015-01-23	AGZ	ETF	114.45	115.4	114.38	115.3	21877.0
2015-01-23	AGZD	ETF	24.44	24.575	24.42	24.42	17400.0
2015-01-23	AIA	ETF	49.54	49.64	49.41	49.47	28169.0
2015-01-23	AIQ	ETF	23.1699	23.6799	22.86	23.51	19494.0
2015-01-23	AIRR	ETF	17.0	17.09	16.91	17.02	69900.0
2015-01-23	AIVI	ETF	43.48	43.63	43.37	43.37	28700.0
2015-01-23	AMJ	ETF	44.79	45.62	44.7	45.09	1716147.0
2015-01-23	AMLP	ETF	86.15	87.2	85.95	86.5	932020.0
2015-01-23	AMZA	ETF	220.0	220.1	218.1	218.1	320.0
2015-01-23	ANGL	ETF	26.55	26.65	26.49	26.65	1000.0
2015-01-23	AOA	ETF	46.88	46.88	46.63	46.63	134300.0
2015-01-23	AOK	ETF	32.91	32.91	32.82	32.83	55205.0
2015-01-23	AOM	ETF	35.39	35.47	35.38	35.38	128410.0
2015-01-23	AOR	ETF	40.42	40.5156	40.4	40.41	146201.0
2015-01-23	ARGT	ETF	18.59	18.59	18.41	18.41	800.0
2015-01-23	ARKG	ETF	22.376	22.56	22.376	22.5	2400.0
2015-01-23	ARKK	ETF	20.71	20.73	20.63	20.63	5000.0
2015-01-23	ARKQ	ETF	19.29	19.29	19.21	19.25	1500.0
2015-01-23	ARKW	ETF	20.96	21.03	20.942	20.942	1300.0
2015-01-23	ASEA	ETF	15.92	15.98	15.9	15.9	2800.0
2015-01-23	ASHR	ETF	36.92	36.98	36.83	36.88	688000.0
2015-01-23	ASHS	ETF	37.21	37.21	37.12	37.16	2000.0
2015-01-23	ATMP	ETF	29.68	30.17	29.68	29.9	48500.0
2015-01-23	AVIV	ETF	40.13	40.33	39.47	39.61	79031.0
2015-01-23	AWAY	ETF	25.96	27.31	25.96	27.13	1389191.0
2015-01-23	BAB	ETF	30.9	31.0199	30.8258	30.99	234443.0
2015-01-23	BAL	ETF	39.12	39.12	38.8	39.0198	12728.0
2015-01-23	BALT	ETF	1.77	1.78	1.7	1.77	302908.0
2015-01-23	BAR	ETF	3.576	3.576	3.458	3.513	95840.0
2015-01-23	BBC	ETF	28.28	28.64	28.16	28.5399	12401.0
2015-01-23	BBH	ETF	123.18	124.34	122.99	124.16	103300.0
2015-01-23	BBP	ETF	27.88	27.98	27.67	27.94	5000.0
2015-01-23	BCHP	ETF	18.3412	18.3412	18.25	18.25	1134.0
2015-01-23	BCM	ETF	30.759	30.77	30.59	30.59	6723.0
2015-01-23	BFOR	ETF	7.845	7.8525	7.8125	7.815	68800.0
2015-01-23	BIB	ETF	69.175	70.705	69.07	70.52	478242.0

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

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