PREVIEW / etf_daily / 2016-02-24

all etf daily files

  file:    by_date/etf_daily/2016/2016-02-24.parquet
  size:    49 KB
  rows:    1,232

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-02-24	SPY	ETF	190.63	193.53	189.32	193.2	150812200.0
2016-02-24	QQQ	ETF	100.44	102.68	99.77	102.55	40739103.0
2016-02-24	IWM	ETF	99.62	101.82	98.97	101.61	36909600.0
2016-02-24	DIA	ETF	162.6	164.9	161.47	164.67	8003800.0
2016-02-24	GLD	ETF	119.0	119.86	117.35	117.61	17938800.0
2016-02-24	TLT	ETF	132.4	133.39	130.95	131.21	9091200.0
2016-02-24	AADR	ETF	35.55	35.55	35.55	35.55	800.0
2016-02-24	AAXJ	ETF	48.58	49.3	48.32	49.15	579200.0
2016-02-24	ACTX	ETF	5.31	5.31	4.13	4.13	373.0
2016-02-24	ACWI	ETF	51.45	52.12	51.02	52.05	1840400.0
2016-02-24	ACWV	ETF	68.96	69.71	68.82	69.65	222500.0
2016-02-24	ACWX	ETF	35.89	36.445	35.71	36.4	788822.0
2016-02-24	ADRE	ETF	26.5805	27.03	26.5805	27.03	1257.0
2016-02-24	AFK	ETF	16.72	16.78	16.54	16.74	25898.0
2016-02-24	AFTY	ETF	12.0	12.18	11.99	12.18	6700.0
2016-02-24	AGG	ETF	110.12	110.32	109.84	109.88	2473200.0
2016-02-24	AGGY	ETF	49.754	49.78	49.621	49.621	1800.0
2016-02-24	AGQ	ETF	33.38	33.98	32.14	32.39	228800.0
2016-02-24	AGZ	ETF	114.76	114.8487	114.5001	114.56	21160.0
2016-02-24	AGZD	ETF	23.66	23.66	23.465	23.48	3200.0
2016-02-24	AIA	ETF	38.55	39.05	38.37	38.99	22381.0
2016-02-24	AIQ	ETF	6.88	7.29	6.635	7.26	16332.0
2016-02-24	AIRR	ETF	14.8	14.95	14.71	14.95	1000.0
2016-02-24	AIVI	ETF	35.43	35.93	35.28	35.93	36000.0
2016-02-24	AMJ	ETF	24.18	25.23	23.71	25.14	4172705.0
2016-02-24	AMLP	ETF	46.9	49.7	46.4	49.45	3465240.0
2016-02-24	AMZA	ETF	76.4	82.0	75.0	81.9	3100.0
2016-02-24	ANGL	ETF	23.8	24.0	23.74	23.95	33500.0
2016-02-24	AOA	ETF	42.1	42.59	41.95	42.53	28500.0
2016-02-24	AOK	ETF	31.14	31.3017	31.14	31.29	26028.0
2016-02-24	AOM	ETF	33.25	33.475	33.24	33.46	153807.0
2016-02-24	AOR	ETF	37.17	37.49	37.09	37.47	330255.0
2016-02-24	ARGT	ETF	17.67	18.12	17.54	18.11	12800.0
2016-02-24	ARKG	ETF	16.34	16.35	16.332	16.332	600.0
2016-02-24	ARKK	ETF	16.39	16.44	16.37	16.44	900.0
2016-02-24	ARKQ	ETF	16.099	16.15	16.099	16.15	600.0
2016-02-24	ARKW	ETF	17.86	18.374	17.85	18.374	1500.0
2016-02-24	ASEA	ETF	12.0	12.1	11.93	12.1	2000.0
2016-02-24	ASHR	ETF	23.28	23.55	23.15	23.52	1474200.0
2016-02-24	ASHS	ETF	33.15	33.53	33.0	33.51	25700.0
2016-02-24	ASHX	ETF	20.79	20.94	20.79	20.94	285.0
2016-02-24	ATMP	ETF	16.2	16.92	15.79	16.81	255900.0
2016-02-24	BAB	ETF	30.24	30.3149	30.11	30.14	238679.0
2016-02-24	BAL	ETF	37.57	37.57	37.4701	37.549	1497.0
2016-02-24	BBC	ETF	17.2	17.81	16.9	17.81	14521.0
2016-02-24	BBH	ETF	99.35	101.31	98.25	101.18	70500.0
2016-02-24	BBP	ETF	22.17	22.89	21.9	22.89	4300.0
2016-02-24	BCM	ETF	23.13	23.39	23.08	23.38	5477.0
2016-02-24	BFOR	ETF	6.96	7.0125	6.86	7.0125	22800.0
2016-02-24	BIB	ETF	39.13	40.86	38.01	40.74	801032.0

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

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