PREVIEW / etf_daily / 2015-01-15

all etf daily files

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

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-15	SPY	ETF	201.63	202.01	198.88	199.02	176613900.0
2015-01-15	QQQ	ETF	101.43	101.59	99.525	99.65	51005416.0
2015-01-15	IWM	ETF	117.23	117.38	114.48	114.83	46199400.0
2015-01-15	DIA	ETF	174.74	175.08	172.81	173.06	9293700.0
2015-01-15	GLD	ETF	120.41	121.7	120.34	120.94	17692500.0
2015-01-15	TLT	ETF	132.85	135.03	132.68	134.91	11454200.0
2015-01-15	AAXJ	ETF	62.26	62.44	61.94	61.96	2208900.0
2015-01-15	ACWI	ETF	57.66	57.86	57.17	57.21	2808500.0
2015-01-15	ACWV	ETF	69.76	69.95	69.48	69.63	210800.0
2015-01-15	ACWX	ETF	42.59	42.59	42.24	42.31	837672.0
2015-01-15	ADRE	ETF	35.8	35.87	35.55	35.55	9847.0
2015-01-15	AFK	ETF	25.25	25.25	25.0	25.03	30940.0
2015-01-15	AGG	ETF	111.49	111.94	111.49	111.93	2084000.0
2015-01-15	AGQ	ETF	44.62	45.38	43.47	43.72	327600.0
2015-01-15	AGZ	ETF	114.42	114.91	114.4	114.83	39028.0
2015-01-15	AGZD	ETF	24.5	24.5	24.4	24.425	7000.0
2015-01-15	AIA	ETF	48.25	48.282	47.98	48.03	26108.0
2015-01-15	AIQ	ETF	21.17	21.37	20.64	21.01	23243.0
2015-01-15	AIRR	ETF	16.99	16.99	16.57	16.59	87800.0
2015-01-15	AIVI	ETF	42.48	42.56	42.28	42.33	19600.0
2015-01-15	ALTL	ETF	38.01	38.01	37.58	37.59	342.0
2015-01-15	AMJ	ETF	42.49	42.96	42.005	42.36	2165618.0
2015-01-15	AMLP	ETF	83.05	83.6	82.35	82.85	1594820.0
2015-01-15	AMZA	ETF	200.4	202.9	200.1	200.5	540.0
2015-01-15	ANGL	ETF	26.49	26.66	26.49	26.62	2100.0
2015-01-15	AOA	ETF	45.93	45.93	45.54	45.54	285600.0
2015-01-15	AOK	ETF	32.6	32.6	32.5132	32.5132	41290.0
2015-01-15	AOM	ETF	35.08	35.09	34.93	34.96	105552.0
2015-01-15	AOR	ETF	40.0	40.0	39.689	39.69	35488.0
2015-01-15	ARGT	ETF	18.07	18.07	17.86	17.86	800.0
2015-01-15	ARKG	ETF	22.57	22.57	22.01	22.03	5100.0
2015-01-15	ARKK	ETF	19.91	19.91	19.48	19.48	2900.0
2015-01-15	ARKQ	ETF	18.75	18.75	18.459	18.47	2000.0
2015-01-15	ARKW	ETF	19.945	19.945	19.86	19.86	400.0
2015-01-15	ASEA	ETF	15.41	15.42	15.39	15.39	1400.0
2015-01-15	ASHR	ETF	37.43	37.58	37.16	37.31	1597700.0
2015-01-15	ASHS	ETF	36.13	36.13	35.84	35.89	4200.0
2015-01-15	ATMP	ETF	28.25	28.49	28.0	28.26	81200.0
2015-01-15	AVIV	ETF	38.56	38.92	38.46	38.63	178691.0
2015-01-15	AWAY	ETF	26.5	26.744	25.76	26.18	1388321.0
2015-01-15	BAB	ETF	31.01	31.12	30.8534	31.12	264263.0
2015-01-15	BAL	ETF	40.52	40.52	40.4799	40.4799	644.0
2015-01-15	BALT	ETF	1.97	1.99	1.75	1.79	544470.0
2015-01-15	BAR	ETF	3.184	3.324	3.0	3.286	106310.0
2015-01-15	BBC	ETF	29.3899	29.3899	27.8	27.899	10510.0
2015-01-15	BBH	ETF	120.63	121.07	117.76	117.8	318100.0
2015-01-15	BBP	ETF	27.75	27.75	26.93	27.0	5600.0
2015-01-15	BCHP	ETF	17.63	17.69	17.59	17.66	8000.0
2015-01-15	BCM	ETF	30.71	30.71	30.59	30.59	1308.0
2015-01-15	BFOR	ETF	7.6725	7.6725	7.545	7.545	41200.0

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

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