PREVIEW / etf_daily / 2015-02-24

all etf daily files

  file:    by_date/etf_daily/2015/2015-02-24.parquet
  size:    48 KB
  rows:    1,170

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-02-24	SPY	ETF	211.12	212.05	210.76	211.81	72472300.0
2015-02-24	QQQ	ETF	108.38	108.73	108.05	108.6	19745011.0
2015-02-24	IWM	ETF	122.47	123.05	122.19	122.66	20023600.0
2015-02-24	DIA	ETF	181.03	182.06	180.89	181.91	4228700.0
2015-02-24	GLD	ETF	115.0	115.55	114.29	115.26	7612900.0
2015-02-24	TLT	ETF	127.65	129.79	127.18	129.67	11958300.0
2015-02-24	AADR	ETF	38.76	39.08	38.76	39.08	2000.0
2015-02-24	AAXJ	ETF	63.57	64.01	63.28	63.87	3455100.0
2015-02-24	ACWI	ETF	60.83	61.22	60.74	61.13	1046500.0
2015-02-24	ACWV	ETF	71.64	71.85	71.3	71.81	212300.0
2015-02-24	ACWX	ETF	45.01	45.39	44.95	45.33	156492.0
2015-02-24	ADRE	ETF	36.35	36.89	36.35	36.83	5384.0
2015-02-24	AFK	ETF	26.02	26.21	25.91	26.2	20742.0
2015-02-24	AGG	ETF	110.74	111.27	110.55	111.24	1736700.0
2015-02-24	AGQ	ETF	40.14	41.26	39.27	40.09	221600.0
2015-02-24	AGZ	ETF	114.06	114.63	113.9068	114.37	21516.0
2015-02-24	AGZD	ETF	24.565	24.655	24.54	24.545	6200.0
2015-02-24	AIA	ETF	49.3	49.56	49.2	49.49	7217.0
2015-02-24	AIQ	ETF	24.88	24.88	24.5	24.58	4459.0
2015-02-24	AIRR	ETF	18.25	18.34	18.17	18.24	20200.0
2015-02-24	AIVI	ETF	45.29	45.78	45.29	45.78	35500.0
2015-02-24	ALTL	ETF	38.01	38.01	38.01	38.01	448.0
2015-02-24	AMJ	ETF	45.49	45.76	45.2672	45.5	1004543.0
2015-02-24	AMLP	ETF	85.45	85.55	84.95	85.2	548280.0
2015-02-24	AMZA	ETF	221.8	223.6	221.8	223.1	750.0
2015-02-24	ANGL	ETF	27.36	27.38	27.27	27.32	8600.0
2015-02-24	AOA	ETF	47.85	48.04	47.74	47.89	69400.0
2015-02-24	AOK	ETF	32.76	33.04	32.76	32.98	76274.0
2015-02-24	AOM	ETF	35.5	35.79	35.5	35.73	72828.0
2015-02-24	AOR	ETF	41.09	41.1744	40.93	41.1	87809.0
2015-02-24	ARGT	ETF	20.17	20.34	19.84	20.34	20900.0
2015-02-24	ARKG	ETF	23.27	23.27	23.104	23.146	5900.0
2015-02-24	ARKK	ETF	21.51	21.51	21.422	21.422	900.0
2015-02-24	ARKQ	ETF	20.13	20.13	20.13	20.13	100.0
2015-02-24	ARKW	ETF	22.39	22.39	22.136	22.136	2900.0
2015-02-24	ASEA	ETF	15.8	15.8	15.8	15.8	500.0
2015-02-24	ASHR	ETF	36.18	36.58	36.05	36.41	793700.0
2015-02-24	ASHS	ETF	38.8	39.49	38.8	39.4	223200.0
2015-02-24	ATMP	ETF	30.71	30.71	30.2	30.33	28700.0
2015-02-24	AVIV	ETF	36.27	36.29	35.59	35.95	272712.0
2015-02-24	AWAY	ETF	30.94	31.67	30.82	31.38	2555965.0
2015-02-24	BAB	ETF	29.83	30.265	29.83	30.11	96495.0
2015-02-24	BAL	ETF	44.07	44.29	44.002	44.1344	9139.0
2015-02-24	BALT	ETF	1.62	1.82	1.61	1.69	950560.0
2015-02-24	BAR	ETF	2.75	2.803	2.738	2.8024	46890.0
2015-02-24	BBC	ETF	31.43	31.43	30.3	30.5199	8244.0
2015-02-24	BBH	ETF	128.09	128.99	126.13	127.11	181700.0
2015-02-24	BBP	ETF	29.81	29.81	29.152	29.34	7500.0
2015-02-24	BCHP	ETF	19.25	19.25	19.25	19.25	634.0
2015-02-24	BCM	ETF	31.709	31.722	31.46	31.46	22489.0

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

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