PREVIEW / etf_daily / 2015-10-21

all etf daily files

  file:    by_date/etf_daily/2015/2015-10-21.parquet
  size:    48 KB
  rows:    1,207

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-10-21	SPY	ETF	203.61	203.79	201.65	201.85	102038000.0
2015-10-21	QQQ	ETF	108.73	108.84	107.48	107.52	30195241.0
2015-10-21	IWM	ETF	115.92	115.98	113.65	113.72	34060300.0
2015-10-21	DIA	ETF	172.44	172.95	171.33	171.48	5801400.0
2015-10-21	GLD	ETF	112.37	112.37	111.41	111.73	3908800.0
2015-10-21	TLT	ETF	123.61	124.22	123.47	124.05	6603800.0
2015-10-21	AADR	ETF	37.85	38.03	37.85	38.03	300.0
2015-10-21	AAXJ	ETF	57.56	57.59	57.03	57.09	1012600.0
2015-10-21	ACTX	ETF	10.0301	10.0301	7.0801	7.6701	2415.0
2015-10-21	ACWF	ETF	23.4499	23.4499	23.4499	23.4499	277.0
2015-10-21	ACWI	ETF	57.61	57.62	57.05	57.08	1307500.0
2015-10-21	ACWV	ETF	70.16	70.33	69.83	69.83	58300.0
2015-10-21	ACWX	ETF	41.86	41.893	41.5	41.5	593735.0
2015-10-21	ADRE	ETF	30.33	30.33	29.83	29.83	3582.0
2015-10-21	AFK	ETF	20.79	20.92	20.79	20.8	17990.0
2015-10-21	AFTY	ETF	15.891	15.91	15.82	15.82	13400.0
2015-10-21	AGG	ETF	109.73	109.95	109.73	109.92	1278200.0
2015-10-21	AGGY	ETF	50.12	50.18	50.12	50.17	400.0
2015-10-21	AGQ	ETF	35.54	35.56	35.06	35.35	95600.0
2015-10-21	AGZ	ETF	114.39	114.39	114.11	114.18	14742.0
2015-10-21	AGZD	ETF	23.95	23.95	23.93	23.935	1400.0
2015-10-21	AIA	ETF	45.88	45.97	45.61	45.61	31578.0
2015-10-21	AIQ	ETF	9.94	9.99	9.7	9.74	63224.0
2015-10-21	AIRR	ETF	16.35	16.35	16.07	16.07	23000.0
2015-10-21	AIVI	ETF	40.9	40.9	40.61	40.61	39600.0
2015-10-21	ALTY	ETF	14.67	14.67	14.67	14.67	100.0
2015-10-21	AMJ	ETF	33.59	34.04	33.22	33.27	2145653.0
2015-10-21	AMLP	ETF	69.25	69.75	68.1	68.1	1031800.0
2015-10-21	AMZA	ETF	149.9	149.9	145.2	145.4	90.0
2015-10-21	ANGL	ETF	26.1	26.1	26.02	26.04	8300.0
2015-10-21	AOA	ETF	45.79	45.9	45.52	45.52	28200.0
2015-10-21	AOK	ETF	32.17	32.2	32.07	32.106	166493.0
2015-10-21	AOM	ETF	34.64	34.75	34.574	34.6	50535.0
2015-10-21	AOR	ETF	39.63	39.63	39.4	39.405	36185.0
2015-10-21	ARGT	ETF	17.42	17.42	17.27	17.27	3400.0
2015-10-21	ARKG	ETF	18.86	18.99	18.86	18.99	300.0
2015-10-21	ARKK	ETF	19.66	19.66	19.66	19.66	100.0
2015-10-21	ARKQ	ETF	18.575	18.575	18.344	18.344	500.0
2015-10-21	ARKW	ETF	21.94	21.95	21.94	21.95	400.0
2015-10-21	ASEA	ETF	13.26	13.31	13.26	13.31	700.0
2015-10-21	ASHR	ETF	34.96	34.97	34.55	34.61	2699000.0
2015-10-21	ASHS	ETF	41.4	41.4	40.51	40.6	78400.0
2015-10-21	ASHX	ETF	24.4599	24.51	24.44	24.45	1035.0
2015-10-21	ATMP	ETF	22.9	23.22	22.82	22.82	58400.0
2015-10-21	AWAY	ETF	29.34	29.48	28.67	28.77	620251.0
2015-10-21	BAB	ETF	29.27	29.32	29.1901	29.27	122515.0
2015-10-21	BAL	ETF	43.0	43.23	42.9	42.9	7407.0
2015-10-21	BBC	ETF	26.8999	26.8999	25.52	26.84	32358.0
2015-10-21	BBH	ETF	118.08	118.48	113.46	116.26	244800.0
2015-10-21	BBP	ETF	29.27	29.28	27.98	28.82	24000.0

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

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