PREVIEW / etf_daily / 2015-03-17

all etf daily files

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

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-17	SPY	ETF	207.69	208.42	206.98	207.96	94510400.0
2015-03-17	QQQ	ETF	106.405	107.04	106.16	106.87	19603813.0
2015-03-17	IWM	ETF	122.97	123.78	122.77	123.66	23142600.0
2015-03-17	DIA	ETF	178.79	178.97	177.86	178.5	5392900.0
2015-03-17	GLD	ETF	109.92	111.35	109.77	110.21	8923300.0
2015-03-17	TLT	ETF	128.55	129.11	128.28	129.0	6314000.0
2015-03-17	AAXJ	ETF	62.16	62.63	62.07	62.59	1148400.0
2015-03-17	ACWI	ETF	59.65	59.85	59.46	59.77	1089800.0
2015-03-17	ACWV	ETF	70.86	71.03	70.62	70.92	162100.0
2015-03-17	ACWX	ETF	43.91	44.1	43.7768	44.07	417916.0
2015-03-17	ADRE	ETF	34.12	34.5	34.12	34.5	5432.0
2015-03-17	AFK	ETF	24.33	24.45	24.16	24.44	52857.0
2015-03-17	AFTY	ETF	18.4	18.42	18.3	18.36	79100.0
2015-03-17	AGG	ETF	110.64	110.68	110.54	110.56	1423700.0
2015-03-17	AGQ	ETF	35.98	37.45	35.93	36.65	124100.0
2015-03-17	AGZ	ETF	113.71	113.9499	113.6401	113.74	9320.0
2015-03-17	AGZD	ETF	24.57	24.57	24.52	24.54	9800.0
2015-03-17	AIA	ETF	48.72	48.949	48.6663	48.949	14700.0
2015-03-17	AIQ	ETF	24.5	24.5	22.55	23.7	20895.0
2015-03-17	AIRR	ETF	18.23	18.32	18.19	18.32	6200.0
2015-03-17	AIVI	ETF	43.27	43.5	43.18	43.43	37600.0
2015-03-17	ALTL	ETF	37.4999	37.4999	37.38	37.38	350.0
2015-03-17	AMJ	ETF	41.23	41.9599	41.071	41.61	1192851.0
2015-03-17	AMLP	ETF	80.75	81.55	80.65	81.25	707780.0
2015-03-17	AMZA	ETF	204.89	207.06	204.89	207.06	60.0
2015-03-17	ANGL	ETF	27.21	27.21	27.11	27.17	7600.0
2015-03-17	AOA	ETF	47.11	47.23	46.97	47.2	26000.0
2015-03-17	AOK	ETF	32.72	32.74	32.615	32.74	25286.0
2015-03-17	AOM	ETF	35.36	35.48	35.29	35.42	43559.0
2015-03-17	AOR	ETF	40.57	40.61	40.4682	40.6	70285.0
2015-03-17	ARGT	ETF	20.99	21.51	20.99	21.51	46600.0
2015-03-17	ARKG	ETF	23.13	23.349	23.13	23.32	3200.0
2015-03-17	ARKK	ETF	20.87	20.87	20.87	20.87	200.0
2015-03-17	ARKQ	ETF	20.02	20.12	20.02	20.11	1000.0
2015-03-17	ARKW	ETF	23.0	23.0	21.64	21.64	900.0
2015-03-17	ASEA	ETF	15.23	15.25	15.21	15.25	2500.0
2015-03-17	ASHR	ETF	38.48	38.86	38.45	38.82	1073500.0
2015-03-17	ASHS	ETF	43.85	44.13	43.75	44.03	29000.0
2015-03-17	ATMP	ETF	28.14	28.63	28.14	28.55	444700.0
2015-03-17	AVIV	ETF	35.43	35.57	35.2	35.41	88546.0
2015-03-17	AWAY	ETF	30.82	30.948	30.43	30.75	640267.0
2015-03-17	BAB	ETF	29.87	29.96	29.783	29.93	236962.0
2015-03-17	BAL	ETF	40.94	40.94	40.75	40.75	3305.0
2015-03-17	BALT	ETF	1.35	1.36	1.27	1.32	427854.0
2015-03-17	BAR	ETF	2.382	2.492	2.382	2.4	15970.0
2015-03-17	BBC	ETF	34.22	34.45	33.7	34.43	36632.0
2015-03-17	BBH	ETF	133.38	135.1	133.03	134.55	87100.0
2015-03-17	BBP	ETF	32.01	32.12	31.76	32.1	21100.0
2015-03-17	BCM	ETF	29.719	29.7976	29.719	29.73	20736.0
2015-03-17	BFOR	ETF	8.2	8.2125	8.1625	8.2075	45600.0

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

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