PREVIEW / etf_daily / 2015-03-27

all etf daily files

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

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-27	SPY	ETF	205.13	205.95	204.9	205.74	118939000.0
2015-03-27	QQQ	ETF	105.08	105.77	104.92	105.52	33878385.0
2015-03-27	IWM	ETF	122.38	123.23	121.86	123.1	23066800.0
2015-03-27	DIA	ETF	176.33	176.97	175.97	176.81	3971800.0
2015-03-27	GLD	ETF	115.14	115.36	114.45	115.06	4921700.0
2015-03-27	TLT	ETF	130.03	131.13	129.98	131.06	7907900.0
2015-03-27	AADR	ETF	38.9	38.9	38.45	38.87	4800.0
2015-03-27	AAXJ	ETF	63.15	63.4	63.08	63.28	551900.0
2015-03-27	ACWI	ETF	60.04	60.2	59.94	60.12	775200.0
2015-03-27	ACWV	ETF	71.47	71.79	71.47	71.59	163200.0
2015-03-27	ACWX	ETF	44.88	45.0577	44.83	45.01	750486.0
2015-03-27	ADRE	ETF	34.34	34.3801	34.27	34.38	23582.0
2015-03-27	AFK	ETF	24.6	24.74	24.55	24.6273	13616.0
2015-03-27	AFTY	ETF	19.023	19.045	18.98	19.03	13100.0
2015-03-27	AGG	ETF	111.18	111.34	111.16	111.19	5610200.0
2015-03-27	AGQ	ETF	43.96	44.13	42.83	43.23	237400.0
2015-03-27	AGZ	ETF	114.1	114.31	114.0843	114.28	13562.0
2015-03-27	AGZD	ETF	24.425	24.505	24.38	24.43	7800.0
2015-03-27	AIA	ETF	49.51	49.5888	49.36	49.51	16426.0
2015-03-27	AIQ	ETF	21.46	21.54	20.775	20.85	13099.0
2015-03-27	AIRR	ETF	18.541	18.62	18.51	18.6	7000.0
2015-03-27	AIVI	ETF	44.6	44.63	44.4	44.59	102500.0
2015-03-27	ALTL	ETF	37.5446	37.5446	37.5446	37.5446	965.0
2015-03-27	AMJ	ETF	42.48	43.0	42.26	42.53	616089.0
2015-03-27	AMLP	ETF	82.75	83.0	82.15	82.4	525940.0
2015-03-27	AMZA	ETF	212.5	214.8	211.6	211.9	430.0
2015-03-27	ANGL	ETF	27.2	27.33	27.2	27.33	2800.0
2015-03-27	AOA	ETF	47.33	47.54	47.31	47.54	19600.0
2015-03-27	AOK	ETF	32.83	32.9892	32.83	32.94	28934.0
2015-03-27	AOM	ETF	35.53	35.7	35.53	35.69	24901.0
2015-03-27	AOR	ETF	40.89	40.92	40.7	40.9	74956.0
2015-03-27	ARGT	ETF	21.07	21.08	20.98	21.08	21100.0
2015-03-27	ARKG	ETF	22.636	22.7	22.63	22.63	1800.0
2015-03-27	ARKK	ETF	20.76	20.76	20.76	20.76	200.0
2015-03-27	ARKQ	ETF	19.7	19.7	19.7	19.7	200.0
2015-03-27	ARKW	ETF	21.743	21.86	21.743	21.86	300.0
2015-03-27	ASEA	ETF	15.64	15.66	15.62	15.64	10500.0
2015-03-27	ASHR	ETF	40.98	41.0	40.72	40.98	924500.0
2015-03-27	ASHS	ETF	47.32	47.71	47.32	47.68	33400.0
2015-03-27	ATMP	ETF	28.89	29.2	28.86	29.02	37700.0
2015-03-27	AVIV	ETF	35.96	36.2	35.82	36.1	477869.0
2015-03-27	AWAY	ETF	30.56	30.96	30.385	30.87	585273.0
2015-03-27	BAB	ETF	30.1	30.264	30.1	30.23	63041.0
2015-03-27	BAL	ETF	43.21	43.37	42.91	43.11	3127.0
2015-03-27	BALT	ETF	1.46	1.5	1.45	1.47	181951.0
2015-03-27	BAR	ETF	2.76	2.7794	2.717	2.7794	15440.0
2015-03-27	BBC	ETF	31.16	32.3499	31.16	32.16	24608.0
2015-03-27	BBH	ETF	129.87	132.73	129.83	131.94	108400.0
2015-03-27	BBP	ETF	30.84	31.09	30.71	30.994	23500.0
2015-03-27	BCHP	ETF	18.99	19.07	18.99	19.0339	1222.0

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

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