PREVIEW / etf_daily / 2016-04-26

all etf daily files

  file:    by_date/etf_daily/2016/2016-04-26.parquet
  size:    50 KB
  rows:    1,255

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
2016-04-26	SPY	ETF	209.04	209.52	208.36	208.92	75864200.0
2016-04-26	QQQ	ETF	109.2	109.39	108.12	108.45	19118334.0
2016-04-26	IWM	ETF	113.67	114.53	113.17	114.41	30564100.0
2016-04-26	DIA	ETF	179.84	180.26	179.11	179.64	2241000.0
2016-04-26	GLD	ETF	118.79	118.89	118.45	118.7	9906800.0
2016-04-26	TLT	ETF	127.76	127.76	127.12	127.25	7840000.0
2016-04-26	AADR	ETF	38.53	38.62	38.47	38.57	1100.0
2016-04-26	AAXJ	ETF	54.96	55.08	54.84	55.04	268900.0
2016-04-26	ACTX	ETF	4.72	4.72	4.13	4.72	1155.0
2016-04-26	ACWF	ETF	23.451	23.52	23.451	23.52	12552.0
2016-04-26	ACWI	ETF	57.47	57.58	57.31	57.5	1287000.0
2016-04-26	ACWV	ETF	73.98	74.16	73.78	73.96	156400.0
2016-04-26	ACWX	ETF	40.9	40.9432	40.77	40.9	346966.0
2016-04-26	ADRE	ETF	31.74	31.7899	31.6691	31.67	3882.0
2016-04-26	AFK	ETF	20.11	20.42	19.9699	20.16	21677.0
2016-04-26	AFTY	ETF	12.89	12.9	12.82	12.84	20000.0
2016-04-26	AGG	ETF	110.48	110.48	110.23	110.35	2326100.0
2016-04-26	AGGY	ETF	50.65	50.65	50.48	50.6	4600.0
2016-04-26	AGQ	ETF	40.0	40.4	39.64	40.21	145100.0
2016-04-26	AGZ	ETF	114.3	114.51	114.155	114.34	19867.0
2016-04-26	AIA	ETF	43.91	43.99	43.82	43.9001	20642.0
2016-04-26	AIQ	ETF	6.99	7.14	6.94	7.03	11960.0
2016-04-26	AIVI	ETF	39.54	39.63	39.4	39.51	4600.0
2016-04-26	ALTY	ETF	14.58	14.58	14.58	14.58	2100.0
2016-04-26	AMJ	ETF	29.77	30.02	29.3301	29.55	2237085.0
2016-04-26	AMLP	ETF	60.4	60.85	59.5	59.8	2901240.0
2016-04-26	AMZA	ETF	102.9	102.9	100.51	101.2	4850.0
2016-04-26	ANGL	ETF	26.98	27.1	26.97	27.03	36400.0
2016-04-26	AOA	ETF	45.98	46.08	45.93	46.08	22000.0
2016-04-26	AOK	ETF	32.46	32.51	32.4001	32.48	30745.0
2016-04-26	AOM	ETF	34.94	35.02	34.9	35.01	54959.0
2016-04-26	AOR	ETF	39.95	39.95	39.73	39.87	89417.0
2016-04-26	ARGT	ETF	20.62	20.74	20.39	20.69	285600.0
2016-04-26	ARKG	ETF	18.59	18.59	18.59	18.59	100.0
2016-04-26	ARKK	ETF	19.56	19.571	19.56	19.571	3300.0
2016-04-26	ARKQ	ETF	19.56	19.6	19.43	19.58	2200.0
2016-04-26	ARKW	ETF	21.22	21.22	21.13	21.13	3300.0
2016-04-26	ASEA	ETF	13.54	13.54	13.43	13.49	2400.0
2016-04-26	ASHR	ETF	24.09	24.21	24.08	24.2	1204800.0
2016-04-26	ASHS	ETF	33.79	33.93	33.79	33.93	60200.0
2016-04-26	ATMP	ETF	20.0	20.31	20.0	20.13	55200.0
2016-04-26	BAB	ETF	29.99	29.99	29.85	29.86	310403.0
2016-04-26	BAL	ETF	42.6812	42.74	42.3	42.38	1835.0
2016-04-26	BBC	ETF	21.27	21.2924	20.42	20.72	3885.0
2016-04-26	BBH	ETF	112.87	112.87	110.7	111.3	45200.0
2016-04-26	BBP	ETF	27.294	27.3	26.54	26.85	7500.0
2016-04-26	BCM	ETF	25.85	25.946	25.85	25.946	244.0
2016-04-26	BFOR	ETF	7.695	7.745	7.675	7.745	94400.0
2016-04-26	BIB	ETF	49.06	49.06	46.48	47.28	573402.0
2016-04-26	BICK	ETF	20.56	20.59	20.56	20.57	732.0

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

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