PREVIEW / etf_daily / 2013-08-28

all etf daily files

  file:    by_date/etf_daily/2013/2013-08-28.parquet
  size:    41 KB
  rows:    1,019

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-08-28	SPY	ETF	163.26	164.49	163.05	163.91	108113000.0
2013-08-28	QQQ	ETF	75.08	75.75	75.05	75.43	20490381.0
2013-08-28	IWM	ETF	100.62	101.36	100.5	100.96	28927500.0
2013-08-28	DIA	ETF	147.42	148.44	147.37	148.04	4842500.0
2013-08-28	GLD	ETF	137.21	137.46	136.66	136.71	13650400.0
2013-08-28	TLT	ETF	105.41	105.57	104.94	105.27	7497900.0
2013-08-28	AADR	ETF	33.11	33.22	32.92	33.09	9600.0
2013-08-28	AAXJ	ETF	53.34	53.97	53.19	53.6	732000.0
2013-08-28	ACTV	ETF	9.6	9.77	9.54	9.64	261652.0
2013-08-28	ACWI	ETF	51.19	51.49	51.05	51.28	740700.0
2013-08-28	ACWV	ETF	59.76	60.09	59.76	59.84	88500.0
2013-08-28	ACWX	ETF	41.97	42.3	41.92	42.14	279471.0
2013-08-28	ADRE	ETF	34.56	34.892	34.56	34.68	24154.0
2013-08-28	AFK	ETF	28.5	28.8	28.5	28.56	55863.0
2013-08-28	AGEM	ETF	20.24	20.6	20.24	20.6	1703.0
2013-08-28	AGG	ETF	106.32	106.32	106.13	106.17	648500.0
2013-08-28	AGQ	ETF	104.04	104.56	102.0	102.64	604625.0
2013-08-28	AGZ	ETF	110.67	110.71	110.56	110.62	20465.0
2013-08-28	AIA	ETF	43.44	43.81	43.4	43.58	22515.0
2013-08-28	AIQ	ETF	24.01	24.525	23.83	24.15	59920.0
2013-08-28	AIVI	ETF	42.36	42.63	42.36	42.49	17800.0
2013-08-28	AMJ	ETF	44.96	45.63	44.88	45.55	262002.0
2013-08-28	AMLP	ETF	87.2	87.55	86.85	87.4	415380.0
2013-08-28	ANGL	ETF	26.29	26.43	26.29	26.4	2400.0
2013-08-28	AOA	ETF	40.44	40.6	40.43	40.47	9000.0
2013-08-28	AOK	ETF	30.8	30.849	30.78	30.79	15157.0
2013-08-28	AOM	ETF	32.5	32.588	32.47	32.51	17692.0
2013-08-28	AOR	ETF	35.68	35.869	35.68	35.8	20587.0
2013-08-28	ARB	ETF	46.4	46.95	46.4	46.88	239162.0
2013-08-28	ARGT	ETF	18.44	18.69	18.41	18.41	16300.0
2013-08-28	ASEA	ETF	14.97	15.11	14.81	15.02	59400.0
2013-08-28	ATMP	ETF	25.85	26.05	25.85	25.96	45300.0
2013-08-28	AVIV	ETF	22.98	23.15	22.841	23.01	72248.0
2013-08-28	AWAY	ETF	30.37	31.24	30.18	30.93	725661.0
2013-08-28	BAB	ETF	27.2	27.3	27.1	27.12	194167.0
2013-08-28	BAL	ETF	54.2	54.2	53.48	53.5252	35762.0
2013-08-28	BALT	ETF	4.73	4.79	4.63	4.63	122027.0
2013-08-28	BBH	ETF	77.05	77.89	76.6	77.69	28500.0
2013-08-28	BCM	ETF	42.21	42.21	42.15	42.18	1000.0
2013-08-28	BFOR	ETF	6.4625	6.5025	6.4525	6.485	154800.0
2013-08-28	BIB	ETF	27.26	28.0	27.0	27.875	131832.0
2013-08-28	BICK	ETF	21.29	21.35	21.29	21.35	1200.0
2013-08-28	BIL	ETF	91.58	91.6	91.58	91.58	77950.0
2013-08-28	BIS	ETF	1230.4	1230.4	1204.0	1212.8	106.0
2013-08-28	BIV	ETF	82.5	82.58	82.33	82.46	202100.0
2013-08-28	BIZD	ETF	19.83	19.9	19.8	19.85	20500.0
2013-08-28	BJK	ETF	42.47	42.69	42.47	42.62	5700.0
2013-08-28	BKF	ETF	33.68	34.119	33.54	33.81	114929.0
2013-08-28	BKLN	ETF	24.66	24.69	24.62	24.66	2009400.0
2013-08-28	BLV	ETF	82.58	82.58	82.18	82.38	21200.0

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

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