PREVIEW / etf_daily / 2015-12-14

all etf daily files

  file:    by_date/etf_daily/2015/2015-12-14.parquet
  size:    50 KB
  rows:    1,242

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-12-14	SPY	ETF	202.07	203.05	199.95	202.9	182385200.0
2015-12-14	QQQ	ETF	110.98	111.68	109.38	111.63	53098514.0
2015-12-14	IWM	ETF	111.87	112.38	110.28	111.11	53400400.0
2015-12-14	DIA	ETF	172.97	173.95	171.52	173.9	12321600.0
2015-12-14	GLD	ETF	102.58	102.72	101.74	101.79	5563800.0
2015-12-14	TLT	ETF	123.08	123.15	121.75	122.16	10661100.0
2015-12-14	AADR	ETF	38.45	38.45	37.56	37.74	1300.0
2015-12-14	AAXJ	ETF	52.88	53.14	52.47	53.1	1601300.0
2015-12-14	ACTX	ETF	7.6701	8.2601	5.9001	6.4901	1028.0
2015-12-14	ACWF	ETF	23.0	23.0	23.0	23.0	1000.0
2015-12-14	ACWI	ETF	55.58	55.68	54.93	55.62	3562800.0
2015-12-14	ACWV	ETF	68.74	69.07	68.36	69.03	218900.0
2015-12-14	ACWX	ETF	39.28	39.32	38.79	39.17	3262569.0
2015-12-14	ADRE	ETF	29.16	29.18	28.92	29.17	11952.0
2015-12-14	AFK	ETF	17.63	17.68	17.5101	17.68	13369.0
2015-12-14	AFTY	ETF	16.37	16.64	16.37	16.64	78900.0
2015-12-14	AGG	ETF	108.53	108.58	108.17	108.18	3351900.0
2015-12-14	AGGY	ETF	49.28	49.4	49.2	49.2	3200.0
2015-12-14	AGQ	ETF	27.24	27.24	26.64	26.67	187300.0
2015-12-14	AGZ	ETF	113.06	113.375	112.9201	112.94	47062.0
2015-12-14	AGZD	ETF	23.935	23.945	23.91	23.91	4200.0
2015-12-14	AIA	ETF	42.56	42.74	42.18	42.55	60564.0
2015-12-14	AIQ	ETF	8.32	8.44	7.86	8.03	39917.0
2015-12-14	AIRR	ETF	16.51	16.51	16.4	16.42	3300.0
2015-12-14	AIVI	ETF	37.62	37.62	37.19	37.56	53500.0
2015-12-14	ALTY	ETF	13.26	13.26	13.26	13.26	500.0
2015-12-14	AMJ	ETF	25.4	25.5	24.18	24.66	7617044.0
2015-12-14	AMLP	ETF	50.6	51.25	48.9	49.9	5338120.0
2015-12-14	AMZA	ETF	95.0	95.0	87.5	90.4	4530.0
2015-12-14	ANGL	ETF	24.22	24.55	24.07	24.17	41100.0
2015-12-14	AOA	ETF	44.61	44.75	44.29	44.6	241000.0
2015-12-14	AOK	ETF	31.73	31.82	31.53	31.61	217186.0
2015-12-14	AOM	ETF	34.18	34.27	33.98	34.04	547784.0
2015-12-14	AOR	ETF	38.91	38.91	38.5274	38.79	1020973.0
2015-12-14	ARGT	ETF	17.65	17.65	17.2	17.24	22400.0
2015-12-14	ARKG	ETF	19.25	19.25	19.25	19.25	100.0
2015-12-14	ARKK	ETF	20.27	20.41	19.99	20.21	900.0
2015-12-14	ARKQ	ETF	18.9	18.9	18.9	18.9	100.0
2015-12-14	ARKW	ETF	23.38	23.38	23.09	23.09	4600.0
2015-12-14	ASEA	ETF	12.2	12.21	12.19	12.19	3200.0
2015-12-14	ASHR	ETF	36.13	36.28	35.98	36.26	2160000.0
2015-12-14	ASHS	ETF	43.97	44.43	43.78	43.86	110500.0
2015-12-14	ASHX	ETF	25.915	25.976	25.915	25.976	840.0
2015-12-14	ATMP	ETF	16.63	16.67	16.02	16.3	255200.0
2015-12-14	AWAY	ETF	35.47	36.1801	35.46	35.77	5989037.0
2015-12-14	BAB	ETF	29.45	29.45	29.2107	29.3	50231.0
2015-12-14	BAL	ETF	42.15	42.3355	41.86	42.08	6741.0
2015-12-14	BBC	ETF	27.55	28.26	27.36	27.53	8763.0
2015-12-14	BBH	ETF	120.31	121.37	118.5	120.81	54300.0
2015-12-14	BBP	ETF	29.23	29.507	28.7	29.06	13200.0

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

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