PREVIEW / etf_daily / 2016-05-10

all etf daily files

  file:    by_date/etf_daily/2016/2016-05-10.parquet
  size:    51 KB
  rows:    1,269

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-05-10	SPY	ETF	206.72	208.47	206.64	208.45	77472200.0
2016-05-10	QQQ	ETF	106.26	107.38	106.07	107.33	21178851.0
2016-05-10	IWM	ETF	111.66	112.4	111.07	112.35	18635300.0
2016-05-10	DIA	ETF	177.72	179.27	177.64	179.2	2867200.0
2016-05-10	GLD	ETF	120.74	121.38	120.08	120.98	9845000.0
2016-05-10	TLT	ETF	130.85	131.12	130.65	130.87	4331900.0
2016-05-10	AADR	ETF	38.21	38.21	38.07	38.21	900.0
2016-05-10	AAXJ	ETF	52.09	52.53	52.09	52.51	672400.0
2016-05-10	ACTX	ETF	4.72	4.72	4.13	4.13	102.0
2016-05-10	ACWI	ETF	56.14	56.66	56.14	56.65	1593000.0
2016-05-10	ACWV	ETF	74.09	74.5	73.9	74.5	132300.0
2016-05-10	ACWX	ETF	39.57	39.91	39.57	39.9	344054.0
2016-05-10	ADRE	ETF	30.19	30.57	30.19	30.56	3442.0
2016-05-10	AFK	ETF	19.85	20.1499	19.85	20.02	47165.0
2016-05-10	AFTY	ETF	12.35	12.36	12.32	12.35	12700.0
2016-05-10	AGG	ETF	111.06	111.1	110.99	111.09	2103800.0
2016-05-10	AGGY	ETF	50.98	51.1	50.98	51.097	5100.0
2016-05-10	AGNG	ETF	15.39	15.39	15.39	15.39	336.0
2016-05-10	AGQ	ETF	39.87	40.26	39.6	40.08	125000.0
2016-05-10	AGZ	ETF	114.94	115.01	114.828	114.99	82357.0
2016-05-10	AIA	ETF	41.48	41.8001	41.48	41.8001	6876.0
2016-05-10	AIQ	ETF	6.6799	6.7599	6.34	6.69	71528.0
2016-05-10	AIRR	ETF	17.67	17.863	17.658	17.856	3300.0
2016-05-10	AIVI	ETF	38.31	38.63	38.31	38.57	21500.0
2016-05-10	ALTY	ETF	14.5	14.5	14.5	14.5	1200.0
2016-05-10	AMJ	ETF	29.39	29.73	29.14	29.29	2744030.0
2016-05-10	AMLP	ETF	60.0	60.7	59.3	59.45	2328800.0
2016-05-10	AMZA	ETF	102.4	104.0	100.0	101.5	6650.0
2016-05-10	ANGL	ETF	26.65	26.74	26.58	26.7	43400.0
2016-05-10	AOA	ETF	45.39	45.66	45.39	45.66	18500.0
2016-05-10	AOK	ETF	32.3887	32.49	32.354	32.49	32644.0
2016-05-10	AOM	ETF	34.88	35.0	34.85	34.98	76403.0
2016-05-10	AOR	ETF	39.52	39.65	39.34	39.63	42601.0
2016-05-10	ARGT	ETF	20.28	20.74	20.23	20.72	487200.0
2016-05-10	ARKG	ETF	17.012	17.012	17.012	17.012	500.0
2016-05-10	ARKK	ETF	18.442	18.442	18.442	18.442	100.0
2016-05-10	ARKQ	ETF	18.156	18.28	18.156	18.28	400.0
2016-05-10	ARKW	ETF	20.571	20.571	20.571	20.571	100.0
2016-05-10	ASEA	ETF	12.87	12.89	12.87	12.89	400.0
2016-05-10	ASET	ETF	26.239	26.239	26.239	26.239	200.0
2016-05-10	ASHR	ETF	22.92	23.22	22.92	23.22	1190300.0
2016-05-10	ASHS	ETF	31.79	31.95	31.79	31.95	26900.0
2016-05-10	ASHX	ETF	20.73	20.75	20.73	20.749	12500.0
2016-05-10	ATMP	ETF	20.39	20.39	20.17	20.22	163400.0
2016-05-10	BAB	ETF	30.49	30.49	30.35	30.35	128951.0
2016-05-10	BAL	ETF	40.67	40.67	40.08	40.45	1884.0
2016-05-10	BBC	ETF	18.6396	18.6396	18.0001	18.3701	12749.0
2016-05-10	BBH	ETF	105.92	106.54	104.74	106.46	80500.0
2016-05-10	BBP	ETF	24.936	25.31	24.936	25.31	4200.0
2016-05-10	BCM	ETF	25.71	26.04	25.71	26.04	5447.0

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

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