PREVIEW / etf_daily / 2013-12-23

all etf daily files

  file:    by_date/etf_daily/2013/2013-12-23.parquet
  size:    43 KB
  rows:    1,065

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
2013-12-23	SPY	ETF	182.45	182.64	182.07	182.53	85598000.0
2013-12-23	QQQ	ETF	87.19	87.41	86.95	87.41	28181764.0
2013-12-23	IWM	ETF	114.18	114.82	113.95	114.78	37049100.0
2013-12-23	DIA	ETF	162.57	162.85	162.33	162.62	4992800.0
2013-12-23	GLD	ETF	115.61	116.12	115.43	115.57	6237300.0
2013-12-23	TLT	ETF	104.05	104.41	103.66	103.66	6378600.0
2013-12-23	AADR	ETF	37.25	38.99	36.94	38.99	18500.0
2013-12-23	AAXJ	ETF	58.86	59.12	58.8	58.93	777300.0
2013-12-23	ACWI	ETF	56.71	56.75	56.56	56.68	582200.0
2013-12-23	ACWV	ETF	62.98	62.98	62.66	62.72	49700.0
2013-12-23	ACWX	ETF	45.53	45.77	45.53	45.71	149531.0
2013-12-23	ADRE	ETF	36.35	36.6448	36.35	36.58	35531.0
2013-12-23	AFK	ETF	30.35	30.35	30.03	30.04	27947.0
2013-12-23	AGG	ETF	106.86	106.97	106.77	106.81	1926700.0
2013-12-23	AGQ	ETF	62.96	63.56	62.68	63.04	203450.0
2013-12-23	AGZ	ETF	110.84	110.93	110.73	110.74	23352.0
2013-12-23	AGZD	ETF	24.91	25.0	24.91	25.0	30000.0
2013-12-23	AIA	ETF	47.1	47.249	47.0101	47.0996	14138.0
2013-12-23	AIQ	ETF	25.05	25.4	24.97	25.38	27702.0
2013-12-23	AIVI	ETF	46.72	46.99	46.72	46.88	52700.0
2013-12-23	ALTL	ETF	32.65	32.65	32.53	32.56	5100.0
2013-12-23	AMJ	ETF	44.53	45.31	44.53	45.24	1293048.0
2013-12-23	AMLP	ETF	86.6	87.4	86.1	87.25	600940.0
2013-12-23	ANGL	ETF	26.94	26.98	26.94	26.98	1200.0
2013-12-23	AOA	ETF	44.26	44.37	44.24	44.34	29700.0
2013-12-23	AOK	ETF	31.98	32.02	31.9536	31.99	29371.0
2013-12-23	AOM	ETF	34.23	34.3358	34.23	34.31	37836.0
2013-12-23	AOR	ETF	38.38	38.44	38.3601	38.42	23848.0
2013-12-23	ARGT	ETF	19.71	19.71	19.65	19.7	3400.0
2013-12-23	ASEA	ETF	15.78	15.8	15.72	15.73	9300.0
2013-12-23	ASHR	ETF	24.17	24.2	24.01	24.1	213100.0
2013-12-23	ATMP	ETF	26.57	26.72	26.45	26.68	50600.0
2013-12-23	AVIV	ETF	23.88	24.04	23.71	24.0	111999.0
2013-12-23	AWAY	ETF	40.5	41.74	40.3	40.93	1351948.0
2013-12-23	BAB	ETF	27.49	27.5599	27.45	27.45	88090.0
2013-12-23	BAL	ETF	51.38	51.78	51.14	51.7604	7966.0
2013-12-23	BALT	ETF	6.25	6.43	6.16	6.32	1657635.0
2013-12-23	BBH	ETF	88.34	88.9	88.04	88.48	125700.0
2013-12-23	BCM	ETF	39.61	39.67	39.5	39.52	200659.0
2013-12-23	BFOR	ETF	7.415	7.425	7.3925	7.4225	453200.0
2013-12-23	BIB	ETF	37.305	38.0	37.001	37.2125	320768.0
2013-12-23	BICK	ETF	24.35	24.3643	24.3191	24.3643	3527.0
2013-12-23	BIL	ETF	91.56	91.58	91.56	91.56	284700.0
2013-12-23	BIS	ETF	852.8	852.8	831.2	838.8	1349.0
2013-12-23	BIV	ETF	82.93	83.03	82.81	82.86	366600.0
2013-12-23	BIZD	ETF	21.39	21.39	21.18	21.18	4300.0
2013-12-23	BJK	ETF	51.72	52.09	51.38	52.05	24000.0
2013-12-23	BKF	ETF	37.02	37.201	36.93	37.02	39717.0
2013-12-23	BKLN	ETF	24.81	24.82	24.8	24.82	2179100.0
2013-12-23	BLV	ETF	83.06	83.27	82.86	82.86	62000.0

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

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