PREVIEW / etf_daily / 2015-01-22

all etf daily files

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

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-22	SPY	ETF	203.99	206.26	202.33	206.1	174356000.0
2015-01-22	QQQ	ETF	102.54	104.14	101.64	104.03	40887168.0
2015-01-22	IWM	ETF	116.56	118.24	115.1	118.2	37877000.0
2015-01-22	DIA	ETF	175.92	178.14	174.51	177.92	9565100.0
2015-01-22	GLD	ETF	125.07	125.58	124.15	125.23	10518400.0
2015-01-22	TLT	ETF	134.0	134.18	132.28	132.92	10200000.0
2015-01-22	AADR	ETF	36.75	37.23	36.75	37.23	1700.0
2015-01-22	AAXJ	ETF	63.28	64.02	62.96	63.9	3442800.0
2015-01-22	ACWI	ETF	58.59	59.19	58.27	59.12	2468700.0
2015-01-22	ACWV	ETF	70.72	71.22	70.24	71.2	133700.0
2015-01-22	ACWX	ETF	43.28	43.66	43.17	43.55	682490.0
2015-01-22	ADRE	ETF	37.14	37.56	37.0	37.56	5888.0
2015-01-22	AFK	ETF	25.9	26.18	25.79	26.09	27724.0
2015-01-22	AGG	ETF	111.72	111.72	111.29	111.43	2030400.0
2015-01-22	AGQ	ETF	51.56	52.19	50.67	51.71	471700.0
2015-01-22	AGZ	ETF	114.1501	114.7199	114.1101	114.521	30597.0
2015-01-22	AGZD	ETF	24.425	24.495	24.42	24.425	8800.0
2015-01-22	AIA	ETF	48.81	49.49	48.77	49.38	31831.0
2015-01-22	AIQ	ETF	21.9	23.095	21.74	22.89	29882.0
2015-01-22	AIRR	ETF	16.75	17.05	16.64	17.02	254400.0
2015-01-22	AIVI	ETF	43.4	43.84	43.34	43.76	26600.0
2015-01-22	ALTL	ETF	38.29	38.54	38.29	38.54	1371.0
2015-01-22	AMJ	ETF	45.42	45.67	44.69	45.0199	1805121.0
2015-01-22	AMLP	ETF	86.75	87.25	86.0	86.45	1065140.0
2015-01-22	AMZA	ETF	218.1	220.0	215.5	216.2	560.0
2015-01-22	ANGL	ETF	26.42	26.6	26.41	26.51	9200.0
2015-01-22	AOA	ETF	46.53	46.9	46.27	46.84	52200.0
2015-01-22	AOK	ETF	32.82	32.842	32.68	32.8201	22317.0
2015-01-22	AOM	ETF	35.29	35.476	35.2	35.44	270397.0
2015-01-22	AOR	ETF	40.24	40.518	40.11	40.5099	775881.0
2015-01-22	ARGT	ETF	18.61	18.7	18.41	18.62	10300.0
2015-01-22	ARKG	ETF	21.98	22.44	21.98	22.4	4100.0
2015-01-22	ARKK	ETF	20.26	20.528	20.26	20.528	2900.0
2015-01-22	ARKQ	ETF	18.99	19.19	18.99	19.17	2400.0
2015-01-22	ARKW	ETF	20.5	20.764	20.35	20.764	4600.0
2015-01-22	ASEA	ETF	15.72	15.89	15.72	15.89	16900.0
2015-01-22	ASHR	ETF	36.65	37.01	36.61	37.0	718000.0
2015-01-22	ASHS	ETF	37.4	37.68	37.35	37.58	16100.0
2015-01-22	ATMP	ETF	30.0	30.12	29.69	29.88	15300.0
2015-01-22	AVIV	ETF	39.35	40.13	39.22	40.1	148029.0
2015-01-22	AWAY	ETF	26.4	26.53	25.87	26.07	1590559.0
2015-01-22	BAB	ETF	31.0	31.0899	30.81	30.85	298111.0
2015-01-22	BAL	ETF	39.32	39.33	39.123	39.29	7244.0
2015-01-22	BALT	ETF	1.79	1.8084	1.73	1.75	958115.0
2015-01-22	BAR	ETF	3.634	3.656	3.55	3.615	54680.0
2015-01-22	BBC	ETF	28.42	28.8	27.1	28.23	9530.0
2015-01-22	BBH	ETF	122.91	123.35	119.94	123.34	146000.0
2015-01-22	BBP	ETF	27.01	27.91	27.01	27.91	1400.0
2015-01-22	BCHP	ETF	18.1924	18.2746	18.186	18.25	10409.0
2015-01-22	BCM	ETF	31.019	31.019	30.85	30.85	2176.0

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

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