PREVIEW / etf_daily / 2014-12-18

all etf daily files

  file:    by_date/etf_daily/2014/2014-12-18.parquet
  size:    47 KB
  rows:    1,158

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
2014-12-18	SPY	ETF	204.74	212.97	203.92	206.78	257633900.0
2014-12-18	QQQ	ETF	103.26	104.26	102.98	104.25	49840942.0
2014-12-18	IWM	ETF	118.46	118.74	117.47	118.63	54315600.0
2014-12-18	DIA	ETF	175.98	177.83	175.37	177.79	9752400.0
2014-12-18	GLD	ETF	115.59	115.81	114.58	115.15	5258100.0
2014-12-18	TLT	ETF	124.93	125.1	124.2	124.2	12758200.0
2014-12-18	AADR	ETF	37.13	37.29	37.1	37.25	6400.0
2014-12-18	AAXJ	ETF	59.72	59.9	59.46	59.83	1264000.0
2014-12-18	ACWI	ETF	58.21	58.73	58.04	58.71	2985200.0
2014-12-18	ACWV	ETF	68.34	68.88	68.28	68.86	177200.0
2014-12-18	ACWX	ETF	43.05	43.35	42.879	43.35	1477316.0
2014-12-18	ADRE	ETF	35.57	36.1	35.57	35.8	10190.0
2014-12-18	AFK	ETF	25.3	25.82	25.3	25.57	43281.0
2014-12-18	AGG	ETF	110.17	110.22	110.06	110.1	1865800.0
2014-12-18	AGQ	ETF	39.73	40.13	38.82	39.14	151400.0
2014-12-18	AGZ	ETF	113.26	113.39	113.05	113.25	33531.0
2014-12-18	AGZD	ETF	24.655	24.685	24.575	24.68	17200.0
2014-12-18	AIA	ETF	46.49	46.56	46.21	46.53	197301.0
2014-12-18	AIQ	ETF	20.77	21.86	20.77	21.62	11705.0
2014-12-18	AIRR	ETF	17.75	17.94	17.654	17.89	57400.0
2014-12-18	AIVI	ETF	43.91	44.18	43.84	44.17	66100.0
2014-12-18	AMJ	ETF	45.76	46.97	44.49	45.33	3664440.0
2014-12-18	AMLP	ETF	88.4	89.1	85.35	87.05	2129720.0
2014-12-18	AMZA	ETF	227.5	227.9	219.99	222.5	290.0
2014-12-18	ANGL	ETF	26.61	26.61	26.44	26.55	5100.0
2014-12-18	AOA	ETF	46.25	46.56	46.14	46.56	62300.0
2014-12-18	AOK	ETF	32.68	32.68	32.59	32.66	103390.0
2014-12-18	AOM	ETF	35.25	35.29	35.128	35.26	217336.0
2014-12-18	AOR	ETF	40.15	40.21	39.98	40.21	205841.0
2014-12-18	ARGT	ETF	18.7	18.82	18.47	18.54	6700.0
2014-12-18	ARKG	ETF	20.87	21.16	20.87	21.14	5600.0
2014-12-18	ARKK	ETF	19.84	19.9	19.84	19.88	1100.0
2014-12-18	ARKQ	ETF	19.59	19.59	19.46	19.53	3500.0
2014-12-18	ARKW	ETF	20.29	20.31	20.17	20.195	1200.0
2014-12-18	ASEA	ETF	15.99	15.99	15.93	15.95	4400.0
2014-12-18	ASHR	ETF	35.78	35.87	35.23	35.55	1063500.0
2014-12-18	ASHS	ETF	37.43	37.5	37.31	37.39	20600.0
2014-12-18	ATMP	ETF	30.83	30.83	29.54	29.95	37400.0
2014-12-18	AVIV	ETF	34.31	34.355	33.57	33.61	316947.0
2014-12-18	AWAY	ETF	28.77	29.32	28.39	28.89	899908.0
2014-12-18	BAB	ETF	30.22	30.35	30.01	30.28	164287.0
2014-12-18	BAL	ETF	41.51	41.68	41.41	41.48	13589.0
2014-12-18	BALT	ETF	2.58	2.597	2.4	2.49	790819.0
2014-12-18	BAR	ETF	2.817	2.817	2.809	2.8155	18000.0
2014-12-18	BBC	ETF	27.77	27.94	27.18	27.6578	14115.0
2014-12-18	BBH	ETF	119.51	120.39	118.07	120.31	110100.0
2014-12-18	BBP	ETF	26.41	26.8	26.41	26.8	8200.0
2014-12-18	BCHP	ETF	18.17	18.17	18.05	18.16	1815.0
2014-12-18	BCM	ETF	33.02	33.02	32.48	32.57	280054.0
2014-12-18	BFOR	ETF	7.8475	7.88	7.82	7.8675	43200.0

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

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