PREVIEW / etf_daily / 2015-03-23

all etf daily files

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

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-23	SPY	ETF	210.42	211.11	210.0	210.0	71784500.0
2015-03-23	QQQ	ETF	108.47	108.77	108.28	108.32	17268507.0
2015-03-23	IWM	ETF	125.95	126.32	125.79	125.88	17132400.0
2015-03-23	DIA	ETF	181.05	181.75	180.84	180.85	3593900.0
2015-03-23	GLD	ETF	113.7	114.37	113.49	114.29	4240300.0
2015-03-23	TLT	ETF	131.7	131.75	130.99	131.35	5555500.0
2015-03-23	AADR	ETF	40.19	40.19	39.37	39.41	2800.0
2015-03-23	AAXJ	ETF	63.98	63.98	63.58	63.77	942700.0
2015-03-23	ACWI	ETF	61.26	61.37	61.16	61.18	846300.0
2015-03-23	ACWV	ETF	72.32	72.65	72.17	72.51	304600.0
2015-03-23	ACWX	ETF	45.44	45.61	45.38	45.55	261169.0
2015-03-23	ADRE	ETF	35.27	35.49	35.27	35.4	10088.0
2015-03-23	AFK	ETF	24.69	24.9399	24.67	24.8703	21583.0
2015-03-23	AFTY	ETF	19.41	19.41	19.26	19.27	38800.0
2015-03-23	AGG	ETF	111.37	111.4	111.23	111.34	1120900.0
2015-03-23	AGQ	ETF	42.84	44.05	42.43	43.79	316200.0
2015-03-23	AGZ	ETF	114.28	114.28	113.9	114.06	10739.0
2015-03-23	AGZD	ETF	24.45	24.5	24.36	24.435	12000.0
2015-03-23	AIA	ETF	50.08	50.1873	49.8317	49.94	18329.0
2015-03-23	AIQ	ETF	23.3	23.36	22.83	22.84	13961.0
2015-03-23	AIRR	ETF	18.598	18.78	18.598	18.76	7600.0
2015-03-23	AIVI	ETF	45.03	45.18	44.88	45.06	19700.0
2015-03-23	AMJ	ETF	42.28	43.32	42.28	43.21	821086.0
2015-03-23	AMLP	ETF	82.05	83.35	81.95	83.3	670020.0
2015-03-23	AMZA	ETF	211.5	215.3	211.4	215.3	190.0
2015-03-23	ANGL	ETF	27.37	27.47	27.28	27.42	2600.0
2015-03-23	AOA	ETF	48.15	48.29	48.09	48.21	70500.0
2015-03-23	AOK	ETF	33.15	33.28	33.08	33.16	60744.0
2015-03-23	AOM	ETF	35.89	36.04	35.88	35.97	71340.0
2015-03-23	AOR	ETF	41.15	41.513	41.15	41.36	95892.0
2015-03-23	ARGT	ETF	22.01	22.08	21.75	21.75	20300.0
2015-03-23	ARKG	ETF	23.99	23.99	23.48	23.515	25900.0
2015-03-23	ARKK	ETF	21.48	21.48	21.18	21.29	900.0
2015-03-23	ARKQ	ETF	20.319	20.37	20.319	20.37	1100.0
2015-03-23	ARKW	ETF	22.48	22.48	22.2	22.36	4600.0
2015-03-23	ASEA	ETF	15.71	15.71	15.57	15.61	4300.0
2015-03-23	ASHR	ETF	41.1	41.18	40.81	40.81	1229800.0
2015-03-23	ASHS	ETF	46.68	46.75	46.55	46.71	104200.0
2015-03-23	ATMP	ETF	29.14	29.42	29.0	29.4	63300.0
2015-03-23	AVIV	ETF	36.63	37.07	36.34	36.97	153991.0
2015-03-23	AWAY	ETF	31.17	31.36	30.78	31.3	892609.0
2015-03-23	BAB	ETF	30.37	30.37	30.27	30.35	71738.0
2015-03-23	BAL	ETF	43.07	43.92	43.012	43.22	11517.0
2015-03-23	BALT	ETF	1.4	1.518	1.4	1.45	446387.0
2015-03-23	BAR	ETF	2.78	2.78	2.65	2.716	69890.0
2015-03-23	BBC	ETF	35.04	35.25	33.7101	34.1	84643.0
2015-03-23	BBH	ETF	136.6	136.84	134.53	135.29	212100.0
2015-03-23	BBP	ETF	32.87	32.87	31.524	31.94	24100.0
2015-03-23	BCHP	ETF	19.71	19.71	19.71	19.71	203.0
2015-03-23	BCM	ETF	30.88	31.06	30.7915	31.04	73174.0

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

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