PREVIEW / etf_daily / 2015-09-03

all etf daily files

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

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-03	SPY	ETF	196.26	198.05	194.96	195.55	152087800.0
2015-09-03	QQQ	ETF	104.31	105.02	103.1	103.39	45131794.0
2015-09-03	IWM	ETF	114.08	115.13	113.55	113.73	33334500.0
2015-09-03	DIA	ETF	164.33	165.49	163.13	163.67	8023700.0
2015-09-03	GLD	ETF	107.77	108.32	107.56	107.84	3913100.0
2015-09-03	TLT	ETF	121.38	121.67	120.71	121.57	7042500.0
2015-09-03	AAXJ	ETF	52.42	53.09	52.38	52.44	2037500.0
2015-09-03	ACTX	ETF	1.77	1.77	1.18	1.77	192.0
2015-09-03	ACWI	ETF	55.18	55.66	54.94	55.09	1280300.0
2015-09-03	ACWV	ETF	66.86	67.38	66.79	66.93	458000.0
2015-09-03	ACWX	ETF	40.06	40.4	39.98	40.06	897403.0
2015-09-03	ADRE	ETF	29.4737	29.665	29.445	29.445	2968.0
2015-09-03	AFK	ETF	20.11	20.379	20.09	20.15	6490.0
2015-09-03	AFTY	ETF	14.9	15.04	14.75	14.77	13200.0
2015-09-03	AGG	ETF	109.06	109.12	108.87	109.04	1935100.0
2015-09-03	AGGY	ETF	49.62	49.622	49.61	49.61	1800.0
2015-09-03	AGQ	ETF	31.23	32.5	31.03	31.33	212500.0
2015-09-03	AGZ	ETF	113.8	114.23	113.516	113.862	21562.0
2015-09-03	AGZD	ETF	24.065	24.065	23.955	24.025	4200.0
2015-09-03	AIA	ETF	41.57	42.05	41.57	41.65	16841.0
2015-09-03	AIQ	ETF	14.21	15.17	13.97	14.68	17191.0
2015-09-03	AIRR	ETF	16.408	16.45	16.38	16.38	1700.0
2015-09-03	AIVI	ETF	39.56	39.86	39.47	39.52	17800.0
2015-09-03	AMJ	ETF	35.44	35.95	35.12	35.24	1907129.0
2015-09-03	AMLP	ETF	72.15	72.6	71.55	71.75	1054320.0
2015-09-03	AMZA	ETF	166.16	169.5	163.71	166.1	3630.0
2015-09-03	ANGL	ETF	26.26	26.43	26.26	26.38	4500.0
2015-09-03	AOA	ETF	44.49	44.65	44.19	44.33	66800.0
2015-09-03	AOK	ETF	31.74	31.76	31.59	31.61	142095.0
2015-09-03	AOM	ETF	34.03	34.1799	34.01	34.01	72880.0
2015-09-03	AOR	ETF	38.69	38.78	38.502	38.63	281785.0
2015-09-03	ARGT	ETF	17.72	18.05	17.72	17.9	1700.0
2015-09-03	ARKG	ETF	20.78	20.78	20.78	20.78	200.0
2015-09-03	ARKK	ETF	19.81	19.81	19.81	19.81	100.0
2015-09-03	ARKQ	ETF	17.92	17.92	17.92	17.92	100.0
2015-09-03	ARKW	ETF	21.92	21.92	21.61	21.645	3300.0
2015-09-03	ASEA	ETF	12.64	12.77	12.63	12.63	16800.0
2015-09-03	ASHR	ETF	31.47	32.09	31.3	31.54	1608800.0
2015-09-03	ASHS	ETF	34.51	35.06	34.4	34.43	82400.0
2015-09-03	ATMP	ETF	23.81	24.31	23.81	23.93	152000.0
2015-09-03	AWAY	ETF	28.1	28.85	27.95	28.51	1459657.0
2015-09-03	BAB	ETF	28.93	29.03	28.85	28.91	60660.0
2015-09-03	BAL	ETF	41.8	42.0	41.8	42.0	2707.0
2015-09-03	BBC	ETF	32.49	32.49	30.91	30.91	21154.0
2015-09-03	BBH	ETF	128.03	128.73	124.79	125.0	184600.0
2015-09-03	BBP	ETF	32.91	33.2	31.87	31.9	25200.0
2015-09-03	BCM	ETF	27.477	27.477	27.24	27.24	553.0
2015-09-03	BFOR	ETF	7.685	7.7775	7.6775	7.7025	66800.0
2015-09-03	BIB	ETF	77.88	79.2	73.9001	74.33	888279.0
2015-09-03	BICK	ETF	19.22	19.4098	19.2	19.274	785.0

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

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