PREVIEW / etf_daily / 2013-09-20

all etf daily files

  file:    by_date/etf_daily/2013/2013-09-20.parquet
  size:    41 KB
  rows:    1,014

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-09-20	SPY	ETF	172.33	172.33	170.58	170.72	132867100.0
2013-09-20	QQQ	ETF	79.47	79.54	78.95	78.985	26328830.0
2013-09-20	IWM	ETF	107.24	107.28	106.55	106.59	49522500.0
2013-09-20	DIA	ETF	156.16	156.19	154.3	154.3	9381000.0
2013-09-20	GLD	ETF	130.6	130.91	127.9	127.96	19558200.0
2013-09-20	TLT	ETF	104.69	105.18	104.45	104.92	8421000.0
2013-09-20	AADR	ETF	35.79	35.85	35.71	35.85	1000.0
2013-09-20	AAXJ	ETF	60.75	60.75	59.77	59.78	567800.0
2013-09-20	ACTV	ETF	10.89	10.89	10.51	10.64	824031.0
2013-09-20	ACWI	ETF	55.0	55.06	54.65	54.67	4902300.0
2013-09-20	ACWV	ETF	62.73	63.05	62.41	62.42	31700.0
2013-09-20	ACWX	ETF	45.72	45.72	45.34	45.35	148408.0
2013-09-20	ADRE	ETF	38.25	38.25	37.65	37.66	11047.0
2013-09-20	AFK	ETF	29.98	29.98	29.42	29.4698	34522.0
2013-09-20	AGEM	ETF	23.0215	23.0215	22.9999	22.9999	772.0
2013-09-20	AGG	ETF	106.84	106.87	106.69	106.77	482800.0
2013-09-20	AGQ	ETF	87.52	88.12	80.88	81.0	880450.0
2013-09-20	AGZ	ETF	110.02	110.85	110.02	110.7504	7525.0
2013-09-20	AIA	ETF	48.45	48.45	47.56	47.56	14411.0
2013-09-20	AIQ	ETF	24.8	25.49	24.51	24.65	137484.0
2013-09-20	AIVI	ETF	45.9	46.01	45.76	45.76	49600.0
2013-09-20	ALTL	ETF	30.82	30.82	30.65	30.65	800.0
2013-09-20	AMJ	ETF	44.77	44.898	44.55	44.75	895441.0
2013-09-20	AMLP	ETF	88.2	88.2	87.5	87.7	551660.0
2013-09-20	ANGL	ETF	27.35	27.35	26.62	26.62	1500.0
2013-09-20	AOA	ETF	42.63	42.65	42.38	42.38	12500.0
2013-09-20	AOK	ETF	31.55	31.5594	31.44	31.44	25927.0
2013-09-20	AOM	ETF	33.59	33.6	33.47	33.49	43406.0
2013-09-20	AOR	ETF	37.32	37.32	37.104	37.13	17791.0
2013-09-20	ARB	ETF	47.83	47.85	47.56	47.6	1484855.0
2013-09-20	ARGT	ETF	20.06	20.06	19.96	20.0	800.0
2013-09-20	ASEA	ETF	17.35	17.42	17.18	17.19	60300.0
2013-09-20	ATMP	ETF	26.49	26.49	26.09	26.14	10800.0
2013-09-20	AVIV	ETF	23.41	23.65	23.18	23.32	353222.0
2013-09-20	AWAY	ETF	31.8	31.87	31.3278	31.53	1847848.0
2013-09-20	BAB	ETF	27.15	27.25	27.078	27.1485	295095.0
2013-09-20	BAL	ETF	54.19	54.36	53.865	54.15	4475.0
2013-09-20	BALT	ETF	4.63	4.9	4.6	4.86	8586388.0
2013-09-20	BBH	ETF	83.84	83.84	82.89	83.13	32600.0
2013-09-20	BCM	ETF	40.4749	40.4749	40.44	40.44	2222.0
2013-09-20	BFOR	ETF	6.845	6.8525	6.8125	6.8175	62400.0
2013-09-20	BIB	ETF	33.465	33.5575	32.8425	32.975	107868.0
2013-09-20	BICK	ETF	24.08	24.08	24.03	24.03	312.0
2013-09-20	BIL	ETF	91.6	91.6	91.58	91.58	647550.0
2013-09-20	BIS	ETF	1007.2	1020.0	1005.2	1020.0	144.0
2013-09-20	BIV	ETF	82.93	83.08	82.88	82.95	128600.0
2013-09-20	BIZD	ETF	20.51	20.58	20.38	20.47	3800.0
2013-09-20	BJK	ETF	47.76	47.76	47.33	47.43	109600.0
2013-09-20	BKF	ETF	38.75	38.75	38.05	38.09	75857.0
2013-09-20	BKLN	ETF	24.81	24.83	24.79	24.82	2717900.0

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

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