PREVIEW / etf_daily / 2015-01-12

all etf daily files

  file:    by_date/etf_daily/2015/2015-01-12.parquet
  size:    46 KB
  rows:    1,148

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-12	SPY	ETF	204.41	204.6	201.92	202.65	144396100.0
2015-01-12	QQQ	ETF	102.82	102.93	101.285	101.55	34129751.0
2015-01-12	IWM	ETF	117.7	118.01	116.23	117.18	27316800.0
2015-01-12	DIA	ETF	177.44	177.63	175.46	176.24	4305300.0
2015-01-12	GLD	ETF	117.46	118.71	117.32	118.56	8318200.0
2015-01-12	TLT	ETF	131.0	132.31	130.92	131.82	6658100.0
2015-01-12	AADR	ETF	36.39	36.39	36.39	36.39	100.0
2015-01-12	AAXJ	ETF	61.4	61.58	61.11	61.18	684400.0
2015-01-12	ACWI	ETF	58.03	58.03	57.35	57.57	3101800.0
2015-01-12	ACWV	ETF	69.29	69.34	68.79	68.83	457500.0
2015-01-12	ACWX	ETF	42.22	42.28	41.89	42.08	822495.0
2015-01-12	ADRE	ETF	35.45	35.48	35.1001	35.22	16318.0
2015-01-12	AFK	ETF	25.72	25.79	25.34	25.42	20404.0
2015-01-12	AGG	ETF	111.16	111.26	111.08	111.12	2185700.0
2015-01-12	AGQ	ETF	42.09	42.57	41.68	42.28	179200.0
2015-01-12	AGZ	ETF	114.028	114.545	113.9	114.39	31502.0
2015-01-12	AGZD	ETF	24.575	24.605	24.465	24.53	39400.0
2015-01-12	AIA	ETF	47.75	47.75	47.29	47.34	32117.0
2015-01-12	AIQ	ETF	20.02	20.53	19.76	20.39	16676.0
2015-01-12	AIRR	ETF	17.58	17.73	17.124	17.17	39100.0
2015-01-12	AIVI	ETF	42.31	42.31	41.92	42.02	9300.0
2015-01-12	ALTL	ETF	37.5499	37.597	37.54	37.597	1444.0
2015-01-12	AMJ	ETF	43.32	43.86	42.25	42.68	3491038.0
2015-01-12	AMLP	ETF	84.75	84.9	82.45	83.25	1542200.0
2015-01-12	AMZA	ETF	211.0	221.0	199.5	199.5	1010.0
2015-01-12	ANGL	ETF	26.2	26.46	26.2	26.46	1300.0
2015-01-12	AOA	ETF	46.15	46.16	45.72	45.85	200000.0
2015-01-12	AOK	ETF	32.5399	32.5599	32.5	32.52	16203.0
2015-01-12	AOM	ETF	35.04	35.13	34.9301	35.01	187981.0
2015-01-12	AOR	ETF	39.92	40.01	39.78	39.86	41382.0
2015-01-12	ARGT	ETF	18.13	18.13	17.92	18.0	23000.0
2015-01-12	ARKG	ETF	23.17	23.17	22.58	22.585	8900.0
2015-01-12	ARKK	ETF	20.73	20.73	20.15	20.15	1500.0
2015-01-12	ARKQ	ETF	19.19	19.19	18.78	18.91	30500.0
2015-01-12	ARKW	ETF	20.3	20.3	20.132	20.14	700.0
2015-01-12	ASEA	ETF	15.48	15.48	15.34	15.37	17700.0
2015-01-12	ASHR	ETF	36.73	36.8	36.32	36.39	1080900.0
2015-01-12	ASHS	ETF	35.43	35.43	35.18	35.21	5200.0
2015-01-12	ATMP	ETF	29.54	29.54	28.34	28.64	71400.0
2015-01-12	AVIV	ETF	37.22	37.745	37.22	37.71	161353.0
2015-01-12	AWAY	ETF	28.5	28.515	26.905	27.02	1301552.0
2015-01-12	BAB	ETF	30.71	30.93	30.65	30.8401	155346.0
2015-01-12	BAL	ETF	41.23	41.23	40.63	40.71	11168.0
2015-01-12	BALT	ETF	2.14	2.16	2.03	2.06	429064.0
2015-01-12	BAR	ETF	2.9747	3.0311	2.9747	3.0311	30750.0
2015-01-12	BBC	ETF	29.98	29.98	29.01	29.34	16765.0
2015-01-12	BBH	ETF	119.89	120.46	118.47	119.45	128400.0
2015-01-12	BBP	ETF	28.26	28.26	27.55	27.68	4100.0
2015-01-12	BCM	ETF	31.03	31.03	30.8912	30.8912	116994.0
2015-01-12	BFOR	ETF	7.7625	7.7625	7.665	7.71	49600.0

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

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