PREVIEW / etf_daily / 2015-01-08

all etf daily files

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

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-08	SPY	ETF	204.01	206.16	203.99	205.9	147217800.0
2015-01-08	QQQ	ETF	102.22	103.5	102.111	103.3	40212640.0
2015-01-08	IWM	ETF	117.66	118.85	117.45	118.71	28361700.0
2015-01-08	DIA	ETF	177.26	178.96	177.21	178.76	7166700.0
2015-01-08	GLD	ETF	116.45	116.87	115.85	115.94	7033700.0
2015-01-08	TLT	ETF	130.36	130.37	129.42	129.65	8055300.0
2015-01-08	AADR	ETF	36.73	36.8	36.45	36.45	1100.0
2015-01-08	AAXJ	ETF	60.96	61.53	60.92	61.4	2053000.0
2015-01-08	ACWI	ETF	57.87	58.36	57.82	58.26	1926900.0
2015-01-08	ACWV	ETF	69.24	69.6	69.02	69.47	100400.0
2015-01-08	ACWX	ETF	42.24	42.61	42.2112	42.48	461368.0
2015-01-08	ADRE	ETF	35.44	35.88	35.44	35.75	12953.0
2015-01-08	AFK	ETF	25.84	26.1099	25.645	25.8	26351.0
2015-01-08	AGG	ETF	110.84	110.84	110.63	110.76	2212200.0
2015-01-08	AGQ	ETF	42.12	42.68	40.94	40.94	201400.0
2015-01-08	AGZ	ETF	113.9	114.54	113.43	114.25	58005.0
2015-01-08	AGZD	ETF	24.61	24.61	24.585	24.59	7200.0
2015-01-08	AIA	ETF	47.33	47.63	47.33	47.5074	48159.0
2015-01-08	AIQ	ETF	20.73	21.29	20.42	20.79	20589.0
2015-01-08	AIRR	ETF	17.7	17.86	17.64	17.807	20100.0
2015-01-08	AIVI	ETF	41.97	42.45	41.85	42.33	34000.0
2015-01-08	ALTL	ETF	37.9264	37.9264	37.9264	37.9264	1052.0
2015-01-08	AMJ	ETF	44.24	44.8	43.91	44.5	1537017.0
2015-01-08	AMLP	ETF	85.2	85.75	84.85	85.2	1389120.0
2015-01-08	AMZA	ETF	213.5	213.5	211.0	211.0	150.0
2015-01-08	ANGL	ETF	26.3	26.5	26.3	26.48	10400.0
2015-01-08	AOA	ETF	46.17	46.31	46.02	46.24	103300.0
2015-01-08	AOK	ETF	32.65	32.65	32.5	32.64	64292.0
2015-01-08	AOM	ETF	35.1	35.15	35.0295	35.13	69694.0
2015-01-08	AOR	ETF	40.05	40.15	39.945	40.12	74900.0
2015-01-08	ARGT	ETF	18.16	18.27	18.12	18.24	6500.0
2015-01-08	ARKG	ETF	21.59	21.6	21.59	21.6	300.0
2015-01-08	ARKK	ETF	19.94	20.14	19.94	20.14	700.0
2015-01-08	ARKQ	ETF	19.179	19.24	19.17	19.22	3900.0
2015-01-08	ARKW	ETF	20.5	20.5	20.449	20.449	400.0
2015-01-08	ASEA	ETF	15.51	15.64	15.51	15.59	21100.0
2015-01-08	ASHR	ETF	37.22	37.22	36.83	37.02	1488800.0
2015-01-08	ASHS	ETF	35.99	36.0	35.77	35.93	20500.0
2015-01-08	ATMP	ETF	29.4	29.58	29.23	29.37	76300.0
2015-01-08	AVIV	ETF	38.11	38.11	37.05	37.59	303771.0
2015-01-08	AWAY	ETF	27.11	28.23	26.71	28.07	1266637.0
2015-01-08	BAB	ETF	30.71	30.98	30.71	30.92	193187.0
2015-01-08	BAL	ETF	41.2401	41.3048	41.2401	41.3048	1062.0
2015-01-08	BALT	ETF	2.16	2.37	2.09	2.35	1301922.0
2015-01-08	BAR	ETF	2.893	2.893	2.893	2.893	4120.0
2015-01-08	BBC	ETF	29.52	29.52	28.7004	29.08	25042.0
2015-01-08	BBH	ETF	120.83	120.83	118.73	119.37	197800.0
2015-01-08	BBP	ETF	27.8	28.02	27.653	27.92	26700.0
2015-01-08	BCM	ETF	31.42	31.46	31.42	31.4393	932.0
2015-01-08	BFOR	ETF	7.7525	7.8375	7.74	7.8375	264000.0

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

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