PREVIEW / etf_daily / 2015-08-04

all etf daily files

  file:    by_date/etf_daily/2015/2015-08-04.parquet
  size:    48 KB
  rows:    1,187

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-08-04	SPY	ETF	209.7	210.25	208.8	209.38	81820800.0
2015-08-04	QQQ	ETF	111.55	111.745	110.93	111.39	22132319.0
2015-08-04	IWM	ETF	122.39	122.96	121.61	122.06	21728900.0
2015-08-04	DIA	ETF	175.79	176.13	174.83	175.32	4055700.0
2015-08-04	GLD	ETF	104.56	104.75	103.95	104.31	3241000.0
2015-08-04	TLT	ETF	123.16	123.32	122.46	122.57	6448800.0
2015-08-04	AAXJ	ETF	58.8	58.97	58.46	58.62	1297300.0
2015-08-04	ACWF	ETF	24.5	24.5	24.5	24.5	1041.0
2015-08-04	ACWI	ETF	59.79	59.93	59.58	59.69	1095400.0
2015-08-04	ACWV	ETF	71.35	71.49	71.18	71.36	84100.0
2015-08-04	ACWX	ETF	43.98	44.0682	43.8	43.89	189148.0
2015-08-04	ADRE	ETF	32.45	32.491	32.3194	32.44	4755.0
2015-08-04	AFK	ETF	22.33	22.4	22.19	22.2203	18106.0
2015-08-04	AFTY	ETF	18.69	18.71	18.67	18.69	23700.0
2015-08-04	AGG	ETF	109.35	109.43	109.07	109.08	1659900.0
2015-08-04	AGQ	ETF	31.2	31.49	30.97	31.18	80700.0
2015-08-04	AGZ	ETF	113.272	113.5999	113.16	113.27	8514.0
2015-08-04	AGZD	ETF	24.23	24.35	24.23	24.255	10400.0
2015-08-04	AIA	ETF	46.65	46.81	46.4501	46.56	13688.0
2015-08-04	AIQ	ETF	15.5	15.5	14.8	14.98	11123.0
2015-08-04	AIRR	ETF	17.21	17.235	17.04	17.11	24400.0
2015-08-04	AIVI	ETF	43.16	43.26	42.95	43.0	32200.0
2015-08-04	AMJ	ETF	37.55	37.79	36.935	37.01	1010698.0
2015-08-04	AMLP	ETF	75.9	76.45	75.1	75.15	590780.0
2015-08-04	AMZA	ETF	180.34	180.37	176.15	176.15	1790.0
2015-08-04	ANGL	ETF	26.92	26.92	26.83	26.87	18600.0
2015-08-04	AOA	ETF	47.26	47.37	47.05	47.17	62600.0
2015-08-04	AOK	ETF	32.499	32.53	32.39	32.4	41998.0
2015-08-04	AOM	ETF	35.15	35.25	35.1039	35.15	26387.0
2015-08-04	AOR	ETF	40.51	40.577	40.4	40.48	49196.0
2015-08-04	ARGT	ETF	18.28	18.28	18.21	18.28	600.0
2015-08-04	ARKG	ETF	22.67	22.67	22.67	22.67	200.0
2015-08-04	ARKK	ETF	21.08	21.08	21.05	21.05	400.0
2015-08-04	ARKQ	ETF	19.05	19.05	19.05	19.05	200.0
2015-08-04	ARKW	ETF	23.48	23.52	23.47	23.47	1300.0
2015-08-04	ASEA	ETF	14.51	14.51	14.39	14.4	3800.0
2015-08-04	ASHR	ETF	40.84	41.12	40.67	41.07	2634600.0
2015-08-04	ASHS	ETF	48.91	50.0	48.84	49.7	62900.0
2015-08-04	ATMP	ETF	25.87	25.87	25.4	25.45	38000.0
2015-08-04	AWAY	ETF	28.75	29.03	28.24	28.48	4437088.0
2015-08-04	BAB	ETF	29.25	29.3	29.2	29.23	71736.0
2015-08-04	BAL	ETF	42.68	42.68	42.39	42.39	10718.0
2015-08-04	BBC	ETF	36.37	36.7	36.17	36.4	16871.0
2015-08-04	BBH	ETF	140.51	141.48	140.05	140.62	82400.0
2015-08-04	BBP	ETF	36.07	36.54	36.07	36.29	12400.0
2015-08-04	BCHP	ETF	18.9332	18.9332	18.8915	18.8915	878.0
2015-08-04	BCM	ETF	27.598	27.5999	27.5	27.5	1164.0
2015-08-04	BFOR	ETF	8.195	8.225	8.1625	8.18	73600.0
2015-08-04	BIB	ETF	96.87	98.48	96.25	97.13	600184.0
2015-08-04	BIL	ETF	91.4	91.42	91.4	91.4	2544550.0

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

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