PREVIEW / etf_daily / 2015-03-31

all etf daily files

  file:    by_date/etf_daily/2015/2015-03-31.parquet
  size:    48 KB
  rows:    1,183

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-31	SPY	ETF	207.26	208.1	206.36	206.43	126768700.0
2015-03-31	QQQ	ETF	106.43	106.65	105.57	105.6	30488101.0
2015-03-31	IWM	ETF	124.28	124.71	123.9	124.37	24507800.0
2015-03-31	DIA	ETF	178.52	179.08	177.43	177.58	4633800.0
2015-03-31	GLD	ETF	113.84	114.28	113.41	113.66	4383300.0
2015-03-31	TLT	ETF	130.24	130.96	129.91	130.69	6844300.0
2015-03-31	AAXJ	ETF	63.94	64.12	63.77	64.0	419000.0
2015-03-31	ACWI	ETF	60.01	60.37	59.99	60.02	1373700.0
2015-03-31	ACWV	ETF	71.68	72.06	71.64	71.69	65300.0
2015-03-31	ACWX	ETF	44.59	44.88	44.59	44.7	754844.0
2015-03-31	ADRE	ETF	34.69	34.8708	34.67	34.8	7088.0
2015-03-31	AFK	ETF	24.84	25.082	24.81	25.01	18487.0
2015-03-31	AFTY	ETF	19.61	19.61	19.36	19.42	106900.0
2015-03-31	AGG	ETF	111.27	111.45	111.18	111.43	2958100.0
2015-03-31	AGQ	ETF	41.84	42.6	41.25	41.69	87500.0
2015-03-31	AGZ	ETF	114.27	114.52	114.1201	114.184	21444.0
2015-03-31	AGZD	ETF	24.51	24.53	24.45	24.53	2400.0
2015-03-31	AIA	ETF	49.86	50.0199	49.8599	49.9799	12546.0
2015-03-31	AIQ	ETF	21.99	22.47	21.86	22.18	20909.0
2015-03-31	AIRR	ETF	18.83	18.994	18.83	18.99	4100.0
2015-03-31	AIVI	ETF	44.0	44.11	43.84	43.87	47500.0
2015-03-31	ALTL	ETF	37.75	37.75	37.75	37.75	648.0
2015-03-31	AMJ	ETF	42.84	43.34	42.76	42.8	1377156.0
2015-03-31	AMLP	ETF	82.8	83.6	82.5	82.85	907380.0
2015-03-31	AMZA	ETF	215.0	217.1	215.0	215.1	1720.0
2015-03-31	ANGL	ETF	27.39	27.39	27.36	27.38	2100.0
2015-03-31	AOA	ETF	47.69	47.7	47.39	47.5	46400.0
2015-03-31	AOK	ETF	32.9	33.08	32.9	33.02	21339.0
2015-03-31	AOM	ETF	35.74	35.8099	35.64	35.64	43316.0
2015-03-31	AOR	ETF	41.08	41.08	40.82	40.82	53734.0
2015-03-31	ARGT	ETF	21.05	21.06	20.92	20.96	8100.0
2015-03-31	ARKG	ETF	22.76	22.83	22.742	22.764	4200.0
2015-03-31	ARKK	ETF	20.82	20.88	20.8	20.835	1100.0
2015-03-31	ARKQ	ETF	20.16	20.16	19.88	19.92	800.0
2015-03-31	ARKW	ETF	22.01	22.01	22.01	22.01	200.0
2015-03-31	ASEA	ETF	15.72	15.72	15.71	15.71	600.0
2015-03-31	ASHR	ETF	41.59	41.75	41.32	41.64	1417200.0
2015-03-31	ASHS	ETF	48.8	48.8	47.48	48.25	94200.0
2015-03-31	ATMP	ETF	29.34	29.48	29.17	29.18	26000.0
2015-03-31	AVIV	ETF	36.83	37.05	36.24	36.5	344459.0
2015-03-31	AWAY	ETF	30.06	30.37	29.87	30.17	865249.0
2015-03-31	BAB	ETF	30.31	30.48	30.21	30.37	144682.0
2015-03-31	BAL	ETF	42.3	43.37	42.3	42.902	1181.0
2015-03-31	BALT	ETF	1.48	1.555	1.43	1.49	315370.0
2015-03-31	BAR	ETF	2.65	2.6786	2.6481	2.6786	19900.0
2015-03-31	BBC	ETF	33.86	33.86	32.8	32.8342	63745.0
2015-03-31	BBH	ETF	132.15	132.15	129.55	129.58	210000.0
2015-03-31	BBP	ETF	31.61	31.61	31.04	31.04	10500.0
2015-03-31	BCHP	ETF	19.11	19.11	19.11	19.11	226.0
2015-03-31	BCM	ETF	30.54	30.768	30.4	30.4	33625.0

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

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