PREVIEW / etf_daily / 2015-09-04

all etf daily files

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

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-04	SPY	ETF	192.85	193.86	191.61	192.59	207081000.0
2015-09-04	QQQ	ETF	101.97	102.845	101.59	102.16	49379643.0
2015-09-04	IWM	ETF	112.53	113.7	112.28	112.87	31154600.0
2015-09-04	DIA	ETF	161.42	161.95	160.24	160.97	8651100.0
2015-09-04	GLD	ETF	107.14	107.56	107.07	107.49	4025000.0
2015-09-04	TLT	ETF	122.45	122.93	121.82	122.68	7951300.0
2015-09-04	AADR	ETF	36.44	36.44	36.25	36.25	800.0
2015-09-04	AAXJ	ETF	51.33	51.57	50.73	50.94	1189500.0
2015-09-04	ACTX	ETF	1.77	1.77	1.475	1.77	2407.0
2015-09-04	ACWI	ETF	54.23	54.39	53.79	54.05	1891800.0
2015-09-04	ACWV	ETF	66.24	66.33	65.61	65.91	288200.0
2015-09-04	ACWX	ETF	39.23	39.42	38.98	39.1	927346.0
2015-09-04	ADRE	ETF	28.93	28.93	28.4201	28.47	20506.0
2015-09-04	AFK	ETF	20.051	20.051	19.75	19.88	6881.0
2015-09-04	AFTY	ETF	14.21	14.29	13.85	14.06	23100.0
2015-09-04	AGG	ETF	109.19	109.33	109.02	109.27	1748100.0
2015-09-04	AGGY	ETF	49.84	49.89	49.74	49.74	1700.0
2015-09-04	AGQ	ETF	30.76	31.05	30.65	30.83	96900.0
2015-09-04	AGZ	ETF	113.3762	114.02	113.3762	113.8412	27352.0
2015-09-04	AGZD	ETF	24.04	24.04	24.04	24.04	400.0
2015-09-04	AIA	ETF	40.84	40.96	40.39	40.67	43973.0
2015-09-04	AIQ	ETF	14.57	14.76	14.29	14.46	14454.0
2015-09-04	AIRR	ETF	16.32	16.326	16.27	16.27	8200.0
2015-09-04	AIVI	ETF	38.87	38.93	38.59	38.88	17500.0
2015-09-04	AMJ	ETF	34.9	35.39	34.78	35.0	1709615.0
2015-09-04	AMLP	ETF	71.2	71.95	71.15	71.45	1143300.0
2015-09-04	AMZA	ETF	168.0	168.0	164.5	165.2	700.0
2015-09-04	ANGL	ETF	26.43	26.43	26.14	26.38	8900.0
2015-09-04	AOA	ETF	43.71	43.87	43.54	43.74	31500.0
2015-09-04	AOK	ETF	31.5322	31.5322	31.468	31.51	13180.0
2015-09-04	AOM	ETF	33.78	33.9099	33.76	33.79	54360.0
2015-09-04	AOR	ETF	38.31	38.31	38.0501	38.17	39123.0
2015-09-04	ARGT	ETF	17.62	17.81	17.62	17.81	2600.0
2015-09-04	ARKG	ETF	20.496	20.61	20.496	20.61	700.0
2015-09-04	ARKK	ETF	19.42	19.42	19.42	19.42	200.0
2015-09-04	ARKQ	ETF	17.67	17.69	17.67	17.69	200.0
2015-09-04	ARKW	ETF	21.38	21.435	21.36	21.36	1300.0
2015-09-04	ASEA	ETF	12.5	12.5	12.31	12.33	3900.0
2015-09-04	ASHR	ETF	30.67	30.96	29.89	30.11	3285300.0
2015-09-04	ASHS	ETF	33.79	33.79	33.0	33.15	34400.0
2015-09-04	ATMP	ETF	23.85	23.9	23.67	23.83	20800.0
2015-09-04	AWAY	ETF	28.19	28.49	27.635	27.68	926111.0
2015-09-04	BAB	ETF	29.01	29.15	28.95	29.12	66617.0
2015-09-04	BAL	ETF	41.6859	41.75	41.6859	41.75	1688.0
2015-09-04	BBC	ETF	30.2	31.3015	30.0	31.16	31944.0
2015-09-04	BBH	ETF	123.75	125.66	122.8	124.54	138800.0
2015-09-04	BBP	ETF	31.34	32.136	31.34	32.08	7700.0
2015-09-04	BCHP	ETF	17.47	17.47	17.47	17.47	129.0
2015-09-04	BCM	ETF	27.107	27.107	26.935	26.935	745.0
2015-09-04	BFOR	ETF	7.605	7.6575	7.57	7.625	108000.0

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

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