PREVIEW / etf_daily / 2014-12-10

all etf daily files

  file:    by_date/etf_daily/2014/2014-12-10.parquet
  size:    46 KB
  rows:    1,151

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-10	SPY	ETF	205.91	205.98	202.93	203.16	159856400.0
2014-12-10	QQQ	ETF	104.77	105.03	103.12	103.31	39330116.0
2014-12-10	IWM	ETF	117.74	118.16	115.56	115.66	45413600.0
2014-12-10	DIA	ETF	177.5	177.5	175.01	175.29	7622000.0
2014-12-10	GLD	ETF	118.15	118.47	117.81	117.96	4277400.0
2014-12-10	TLT	ETF	123.18	124.4	123.08	124.1	6439200.0
2014-12-10	AADR	ETF	37.27	37.27	37.0	37.0	900.0
2014-12-10	AAXJ	ETF	61.49	61.49	60.71	60.75	847100.0
2014-12-10	ACWI	ETF	59.39	59.53	58.65	58.74	1562300.0
2014-12-10	ACWV	ETF	69.51	69.51	68.75	68.87	65800.0
2014-12-10	ACWX	ETF	44.24	44.24	43.69	43.77	678703.0
2014-12-10	ADRE	ETF	36.37	36.37	35.75	35.87	10969.0
2014-12-10	AFK	ETF	26.71	26.71	26.35	26.44	34317.0
2014-12-10	AGG	ETF	110.0	110.31	109.98	110.25	1208000.0
2014-12-10	AGQ	ETF	45.5	45.88	45.03	45.31	246900.0
2014-12-10	AGZ	ETF	112.95	113.236	112.85	113.1524	7394.0
2014-12-10	AGZD	ETF	24.795	24.795	24.615	24.66	8200.0
2014-12-10	AIA	ETF	47.15	47.3	46.8101	46.88	25779.0
2014-12-10	AIQ	ETF	21.29	21.29	20.43	20.6	24392.0
2014-12-10	AIRR	ETF	17.89	18.18	17.59	17.62	36100.0
2014-12-10	AIVI	ETF	44.62	44.65	44.19	44.26	18000.0
2014-12-10	AMJ	ETF	44.84	45.21	43.89	44.28	2871005.0
2014-12-10	AMLP	ETF	86.15	86.3	84.3	84.55	2022580.0
2014-12-10	AMZA	ETF	214.6	216.0	213.0	213.0	1180.0
2014-12-10	ANGL	ETF	27.2	27.2	26.7	26.89	30200.0
2014-12-10	AOA	ETF	46.52	46.52	46.0	46.05	107700.0
2014-12-10	AOK	ETF	32.76	32.76	32.57	32.571	22024.0
2014-12-10	AOM	ETF	35.37	35.37	35.109	35.11	82908.0
2014-12-10	AOR	ETF	40.17	40.2162	39.8866	39.89	155453.0
2014-12-10	ARGT	ETF	19.91	19.91	19.13	19.23	4600.0
2014-12-10	ARKG	ETF	20.86	20.86	20.68	20.68	1000.0
2014-12-10	ARKK	ETF	20.04	20.04	19.73	19.73	900.0
2014-12-10	ARKQ	ETF	19.82	19.82	19.82	19.82	300.0
2014-12-10	ARKW	ETF	20.02	20.02	20.02	20.02	300.0
2014-12-10	ASEA	ETF	16.2	16.27	16.15	16.15	12100.0
2014-12-10	ASHR	ETF	33.59	33.97	33.01	33.29	1326100.0
2014-12-10	ASHS	ETF	36.08	36.08	35.51	35.54	16000.0
2014-12-10	ATMP	ETF	29.57	29.57	28.84	29.1	45200.0
2014-12-10	AVIV	ETF	33.68	33.98	33.27	33.39	269270.0
2014-12-10	AWAY	ETF	30.5	30.91	29.8	30.02	1459014.0
2014-12-10	BAB	ETF	30.15	30.28	30.0535	30.28	127509.0
2014-12-10	BAL	ETF	40.82	41.44	40.59	40.59	5131.0
2014-12-10	BALT	ETF	2.58	2.6	2.4349	2.44	764960.0
2014-12-10	BBH	ETF	121.15	121.57	118.84	119.05	135200.0
2014-12-10	BCHP	ETF	18.07	18.07	18.03	18.03	2416.0
2014-12-10	BCM	ETF	33.665	33.665	33.4701	33.4701	1499.0
2014-12-10	BFOR	ETF	7.85	7.8575	7.7225	7.735	99200.0
2014-12-10	BIB	ETF	68.4	68.4	65.105	65.235	514848.0
2014-12-10	BICK	ETF	23.9	23.9	23.9	23.9	518.0
2014-12-10	BIL	ETF	91.48	91.5	91.48	91.48	1242800.0

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

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