PREVIEW / etf_daily / 2015-03-24

all etf daily files

  file:    by_date/etf_daily/2015/2015-03-24.parquet
  size:    47 KB
  rows:    1,168

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-03-24	SPY	ETF	209.85	210.4	208.74	208.82	77805300.0
2015-03-24	QQQ	ETF	108.31	108.81	107.91	107.93	22445280.0
2015-03-24	IWM	ETF	125.77	126.31	125.66	125.85	30115600.0
2015-03-24	DIA	ETF	180.65	181.19	179.77	179.83	4692100.0
2015-03-24	GLD	ETF	114.35	114.65	113.82	114.57	2979300.0
2015-03-24	TLT	ETF	131.83	132.64	131.48	132.62	6713000.0
2015-03-24	AADR	ETF	40.01	40.01	39.3	39.59	7300.0
2015-03-24	AAXJ	ETF	63.74	63.86	63.66	63.85	1776700.0
2015-03-24	ACWI	ETF	61.2	61.35	61.0	61.0	585400.0
2015-03-24	ACWV	ETF	72.71	72.83	72.45	72.48	174500.0
2015-03-24	ACWX	ETF	45.6	45.69	45.53	45.57	117071.0
2015-03-24	ADRE	ETF	35.47	35.47	35.2378	35.2378	2306.0
2015-03-24	AFK	ETF	24.92	24.9799	24.8401	24.87	27895.0
2015-03-24	AFTY	ETF	19.2	19.2	19.0	19.093	36000.0
2015-03-24	AGG	ETF	111.48	111.67	111.37	111.64	2647300.0
2015-03-24	AGQ	ETF	43.33	43.62	42.64	43.61	122400.0
2015-03-24	AGZ	ETF	114.3	114.42	114.0	114.21	27845.0
2015-03-24	AGZD	ETF	24.4	24.505	24.4	24.495	5800.0
2015-03-24	AIA	ETF	49.9	49.9648	49.86	49.89	31819.0
2015-03-24	AIQ	ETF	22.78	22.95	22.57	22.6	13034.0
2015-03-24	AIRR	ETF	18.7	18.713	18.682	18.713	6100.0
2015-03-24	AIVI	ETF	45.16	45.16	44.93	44.93	10600.0
2015-03-24	AMJ	ETF	43.55	43.55	42.57	42.6	705881.0
2015-03-24	AMLP	ETF	83.45	83.5	82.3	82.35	752660.0
2015-03-24	AMZA	ETF	215.5	215.5	211.3	211.5	1740.0
2015-03-24	ANGL	ETF	27.18	27.32	27.18	27.32	700.0
2015-03-24	AOA	ETF	48.22	48.26	48.07	48.11	41900.0
2015-03-24	AOK	ETF	33.26	33.29	33.0901	33.29	40272.0
2015-03-24	AOM	ETF	35.92	36.07	35.845	36.07	48058.0
2015-03-24	AOR	ETF	41.43	41.43	41.3	41.3	31496.0
2015-03-24	ARGT	ETF	21.91	21.91	21.41	21.54	15500.0
2015-03-24	ARKG	ETF	23.68	23.68	23.31	23.34	6400.0
2015-03-24	ARKK	ETF	21.39	21.4	21.29	21.29	3900.0
2015-03-24	ARKQ	ETF	20.45	20.45	20.44	20.44	900.0
2015-03-24	ARKW	ETF	22.291	22.291	22.291	22.291	200.0
2015-03-24	ASEA	ETF	15.67	15.67	15.64	15.65	4100.0
2015-03-24	ASHR	ETF	40.64	40.84	40.58	40.77	666700.0
2015-03-24	ASHS	ETF	46.83	46.83	46.69	46.71	41400.0
2015-03-24	ATMP	ETF	29.32	29.32	29.01	29.01	45800.0
2015-03-24	AVIV	ETF	36.92	37.24	36.78	36.87	163921.0
2015-03-24	AWAY	ETF	31.35	31.72	31.18	31.6	627859.0
2015-03-24	BAB	ETF	30.35	30.48	30.307	30.43	67134.0
2015-03-24	BAL	ETF	43.72	43.72	43.3	43.49	13082.0
2015-03-24	BALT	ETF	1.45	1.52	1.43	1.49	208209.0
2015-03-24	BAR	ETF	2.7027	2.7027	2.691	2.691	8380.0
2015-03-24	BBC	ETF	34.1	34.9199	33.7	33.76	63781.0
2015-03-24	BBH	ETF	135.54	136.99	134.57	134.57	119400.0
2015-03-24	BBP	ETF	31.81	32.34	31.68	31.706	30400.0
2015-03-24	BCHP	ETF	19.56	19.57	19.56	19.57	501.0
2015-03-24	BCM	ETF	30.84	31.01	30.67	30.84	3469.0

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

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