PREVIEW / etf_daily / 2016-03-23

all etf daily files

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

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-23	SPY	ETF	204.11	204.33	203.01	203.21	81052500.0
2016-03-23	QQQ	ETF	107.91	107.99	106.99	107.23	20912873.0
2016-03-23	IWM	ETF	108.54	108.59	106.8	106.88	39243300.0
2016-03-23	DIA	ETF	175.22	175.55	174.6	174.81	5039200.0
2016-03-23	GLD	ETF	116.74	117.12	116.16	116.61	15993700.0
2016-03-23	TLT	ETF	128.41	129.82	128.29	129.49	10628200.0
2016-03-23	AADR	ETF	37.85	38.09	37.42	37.42	26100.0
2016-03-23	AAXJ	ETF	54.0	54.0	53.51	53.55	405900.0
2016-03-23	ACTX	ETF	8.2601	8.2601	6.4901	7.6701	2244.0
2016-03-23	ACWF	ETF	22.98	22.98	22.88	22.88	211.0
2016-03-23	ACWI	ETF	55.72	55.75	55.32	55.35	2148000.0
2016-03-23	ACWV	ETF	72.6	72.68	72.36	72.47	491200.0
2016-03-23	ACWX	ETF	39.35	39.35	38.97	38.99	540263.0
2016-03-23	ADRE	ETF	30.65	30.65	30.1798	30.18	4968.0
2016-03-23	AFK	ETF	19.16	19.28	18.8	18.8	121753.0
2016-03-23	AFTY	ETF	12.93	12.93	12.83	12.835	9700.0
2016-03-23	AGG	ETF	109.96	110.14	109.86	110.1	2885000.0
2016-03-23	AGGY	ETF	50.02	50.16	50.02	50.16	4100.0
2016-03-23	AGQ	ETF	32.87	32.92	32.1	32.12	356400.0
2016-03-23	AGZ	ETF	114.22	114.52	114.018	114.46	16505.0
2016-03-23	AGZD	ETF	23.75	24.09	23.75	24.09	800.0
2016-03-23	AIA	ETF	42.83	42.83	42.49	42.49	12658.0
2016-03-23	AIQ	ETF	6.76	7.104	6.55	6.93	38037.0
2016-03-23	AIRR	ETF	17.267	17.3	17.21	17.258	2300.0
2016-03-23	AIVI	ETF	38.12	38.12	37.74	37.77	12300.0
2016-03-23	AMJ	ETF	26.99	27.09	26.19	26.26	1742381.0
2016-03-23	AMLP	ETF	53.75	54.55	52.7	53.0	1675140.0
2016-03-23	AMZA	ETF	90.0	90.6	86.7	87.5	12260.0
2016-03-23	ANGL	ETF	26.21	26.21	25.75	25.78	78800.0
2016-03-23	AOA	ETF	44.99	45.0	44.77	44.77	26500.0
2016-03-23	AOK	ETF	32.03	32.1068	32.0	32.0394	15355.0
2016-03-23	AOM	ETF	34.5	34.59	34.455	34.52	69907.0
2016-03-23	AOR	ETF	39.27	39.27	39.02	39.06	390457.0
2016-03-23	ARGT	ETF	19.2	19.2	18.91	18.93	59300.0
2016-03-23	ARKG	ETF	17.05	17.05	17.05	17.05	300.0
2016-03-23	ARKQ	ETF	18.38	18.38	18.38	18.38	100.0
2016-03-23	ARKW	ETF	20.19	20.28	20.19	20.223	300.0
2016-03-23	ASET	ETF	25.2	25.2	25.2	25.2	400.0
2016-03-23	ASHR	ETF	24.64	24.7	24.45	24.47	847700.0
2016-03-23	ASHS	ETF	34.41	34.41	34.16	34.28	22400.0
2016-03-23	ASHX	ETF	21.9	21.9	21.9	21.9	224.0
2016-03-23	ATMP	ETF	18.17	18.17	17.49	17.54	29200.0
2016-03-23	BAB	ETF	29.74	29.97	29.7301	29.915	190035.0
2016-03-23	BAL	ETF	37.92	38.24	37.9	38.11	12404.0
2016-03-23	BBC	ETF	19.0	19.28	17.77	17.77	10234.0
2016-03-23	BBH	ETF	103.7	104.55	101.3	101.38	70100.0
2016-03-23	BBP	ETF	24.8	24.8	23.75	23.79	1200.0
2016-03-23	BCM	ETF	24.6545	24.7	24.65	24.7	1051.0
2016-03-23	BFOR	ETF	7.4225	7.425	7.39	7.3975	70400.0
2016-03-23	BIB	ETF	41.43	42.0	38.84	38.87	1403606.0

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

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