PREVIEW / etf_daily / 2015-09-25

all etf daily files

  file:    by_date/etf_daily/2015/2015-09-25.parquet
  size:    48 KB
  rows:    1,200

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-09-25	SPY	ETF	194.64	195.0	191.81	192.85	155054800.0
2015-09-25	QQQ	ETF	104.91	105.01	102.28	102.92	44700006.0
2015-09-25	IWM	ETF	113.82	113.91	110.93	111.42	43750300.0
2015-09-25	DIA	ETF	163.84	164.43	162.06	162.88	10474600.0
2015-09-25	GLD	ETF	109.87	110.03	109.55	109.81	5209500.0
2015-09-25	TLT	ETF	121.65	121.93	121.27	121.54	8383700.0
2015-09-25	AADR	ETF	36.43	36.43	36.43	36.43	100.0
2015-09-25	AAXJ	ETF	52.73	52.84	52.05	52.18	1220100.0
2015-09-25	ACTX	ETF	7.0801	12.3901	5.9001	10.6201	6374.0
2015-09-25	ACWI	ETF	54.57	54.67	53.89	54.13	2826200.0
2015-09-25	ACWV	ETF	67.48	67.77	66.86	67.15	210000.0
2015-09-25	ACWX	ETF	39.31	39.46	38.9499	39.1	1060969.0
2015-09-25	ADRE	ETF	28.09	28.09	27.7019	27.7019	3039.0
2015-09-25	AFK	ETF	20.0432	20.0432	19.62	19.62	4382.0
2015-09-25	AFTY	ETF	15.02	15.03	14.84	14.84	34800.0
2015-09-25	AGG	ETF	109.16	109.23	109.03	109.11	1225500.0
2015-09-25	AGQ	ETF	33.08	33.4	32.73	32.93	67900.0
2015-09-25	AGZ	ETF	113.716	113.717	113.43	113.62	11749.0
2015-09-25	AGZD	ETF	24.045	24.045	23.95	23.95	1000.0
2015-09-25	AIA	ETF	41.91	41.91	41.33	41.42	45683.0
2015-09-25	AIQ	ETF	10.97	10.97	10.01	10.06	54605.0
2015-09-25	AIRR	ETF	15.6	15.6	15.43	15.43	33800.0
2015-09-25	AIVI	ETF	38.41	38.45	38.03	38.13	19600.0
2015-09-25	AMJ	ETF	31.67	31.93	31.15	31.44	3053030.0
2015-09-25	AMLP	ETF	65.9	65.95	64.4	64.95	1342960.0
2015-09-25	AMZA	ETF	145.1	152.32	137.5	142.5	11910.0
2015-09-25	ANGL	ETF	26.2	26.27	26.09	26.09	82400.0
2015-09-25	AOA	ETF	44.08	44.08	43.62	43.78	24000.0
2015-09-25	AOK	ETF	31.59	31.5999	31.4	31.45	42700.0
2015-09-25	AOM	ETF	33.9	34.21	33.771	33.88	76950.0
2015-09-25	AOR	ETF	38.46	38.46	38.11	38.19	61394.0
2015-09-25	ARGT	ETF	16.31	16.37	16.31	16.31	1500.0
2015-09-25	ARKG	ETF	20.09	20.09	20.0	20.0	800.0
2015-09-25	ARKK	ETF	19.73	19.73	19.4	19.4	1500.0
2015-09-25	ARKQ	ETF	17.98	17.98	17.98	17.98	100.0
2015-09-25	ARKW	ETF	22.05	22.05	21.56	21.56	1100.0
2015-09-25	ASEA	ETF	12.1	12.1	12.02	12.04	1800.0
2015-09-25	ASHR	ETF	32.27	32.41	31.88	31.88	1878400.0
2015-09-25	ASHS	ETF	36.38	36.55	35.47	35.55	82800.0
2015-09-25	ATMP	ETF	21.68	21.88	21.41	21.51	50400.0
2015-09-25	AWAY	ETF	27.56	27.59	26.77	26.89	779393.0
2015-09-25	BAB	ETF	28.91	28.92	28.791	28.9	57926.0
2015-09-25	BAL	ETF	40.23	40.579	39.97	39.97	11711.0
2015-09-25	BBC	ETF	32.1	32.1	28.8401	29.22	10584.0
2015-09-25	BBH	ETF	122.58	122.58	114.0	115.93	425500.0
2015-09-25	BBP	ETF	30.713	30.713	28.64	29.01	8800.0
2015-09-25	BCM	ETF	26.985	26.985	26.89	26.9099	1891.0
2015-09-25	BFOR	ETF	7.605	7.6325	7.51	7.525	64400.0
2015-09-25	BIB	ETF	70.69	70.69	59.544	61.89	2127114.0
2015-09-25	BIL	ETF	91.38	91.4	91.38	91.38	554550.0

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

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