PREVIEW / etf_daily / 2015-01-26

all etf daily files

  file:    by_date/etf_daily/2015/2015-01-26.parquet
  size:    47 KB
  rows:    1,166

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-01-26	SPY	ETF	204.71	205.56	203.85	205.45	92009700.0
2015-01-26	QQQ	ETF	104.14	104.33	103.61	104.14	19960870.0
2015-01-26	IWM	ETF	117.88	119.27	117.07	119.26	23006800.0
2015-01-26	DIA	ETF	176.16	176.71	175.38	176.5	3730400.0
2015-01-26	GLD	ETF	123.33	123.34	122.52	122.99	6768600.0
2015-01-26	TLT	ETF	134.84	135.19	134.05	134.36	5966500.0
2015-01-26	AADR	ETF	37.27	37.43	37.27	37.4	800.0
2015-01-26	AAXJ	ETF	63.88	64.08	63.65	64.0	1185500.0
2015-01-26	ACWI	ETF	58.87	59.23	58.7	59.16	2029700.0
2015-01-26	ACWV	ETF	70.85	71.08	70.53	71.0	50600.0
2015-01-26	ACWX	ETF	43.46	43.8401	43.4501	43.77	1209819.0
2015-01-26	ADRE	ETF	37.24	37.39	37.22	37.2879	4203.0
2015-01-26	AFK	ETF	25.5	25.69	25.4436	25.61	17977.0
2015-01-26	AGG	ETF	111.79	111.79	111.45	111.66	2705200.0
2015-01-26	AGQ	ETF	50.19	50.41	48.84	48.88	310300.0
2015-01-26	AGZ	ETF	114.39	115.3999	114.06	114.3024	640882.0
2015-01-26	AGZD	ETF	24.49	24.525	24.39	24.51	24000.0
2015-01-26	AIA	ETF	49.37	49.68	49.37	49.56	42258.0
2015-01-26	AIQ	ETF	23.27	24.525	23.27	23.91	43588.0
2015-01-26	AIRR	ETF	17.12	17.31	16.951	17.27	53600.0
2015-01-26	AIVI	ETF	43.6	44.04	43.42	43.96	22000.0
2015-01-26	ALTL	ETF	38.1448	38.325	38.1448	38.325	1022.0
2015-01-26	AMJ	ETF	45.16	45.44	44.84	45.18	610840.0
2015-01-26	AMLP	ETF	87.0	87.4	86.25	86.75	829980.0
2015-01-26	AMZA	ETF	219.9	219.9	219.1	219.1	110.0
2015-01-26	ANGL	ETF	26.8	27.04	26.63	27.04	1700.0
2015-01-26	AOA	ETF	46.8	46.95	46.66	46.94	69800.0
2015-01-26	AOK	ETF	32.79	32.9	32.79	32.86	59378.0
2015-01-26	AOM	ETF	35.54	35.54	35.37	35.49	179730.0
2015-01-26	AOR	ETF	40.53	40.59	40.344	40.59	197560.0
2015-01-26	ARGT	ETF	18.51	18.66	18.43	18.6	5600.0
2015-01-26	ARKG	ETF	22.46	22.72	22.46	22.648	2300.0
2015-01-26	ARKK	ETF	20.75	20.75	20.75	20.75	200.0
2015-01-26	ARKQ	ETF	19.22	19.37	19.22	19.32	2900.0
2015-01-26	ARKW	ETF	21.28	21.28	20.94	21.01	1900.0
2015-01-26	ASEA	ETF	15.82	15.83	15.77	15.81	9300.0
2015-01-26	ASHR	ETF	37.0	37.27	36.93	37.16	773700.0
2015-01-26	ASHS	ETF	37.73	37.88	37.73	37.88	7900.0
2015-01-26	ATMP	ETF	30.1	30.1	29.7	29.9	30400.0
2015-01-26	AVIV	ETF	39.58	39.735	39.305	39.7	127073.0
2015-01-26	AWAY	ETF	27.1	27.57	26.65	27.105	1193189.0
2015-01-26	BAB	ETF	31.01	31.072	30.8501	30.98	712667.0
2015-01-26	BAL	ETF	39.37	40.05	39.15	39.9764	11955.0
2015-01-26	BALT	ETF	1.76	1.76	1.7	1.71	289549.0
2015-01-26	BAR	ETF	3.445	3.46	3.382	3.391	34060.0
2015-01-26	BBC	ETF	29.15	29.46	28.44	29.46	7342.0
2015-01-26	BBH	ETF	124.27	126.09	123.99	125.64	133500.0
2015-01-26	BBP	ETF	28.58	28.58	28.36	28.42	10800.0
2015-01-26	BCHP	ETF	18.39	18.4056	18.34	18.34	2922.0
2015-01-26	BCM	ETF	30.58	30.78	30.58	30.583	4797.0

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

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