PREVIEW / etf_daily / 2013-08-29

all etf daily files

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

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-29	SPY	ETF	163.55	165.04	163.4	164.17	119200500.0
2013-08-29	QQQ	ETF	75.4	76.34	75.3	75.96	27287901.0
2013-08-29	IWM	ETF	100.89	102.36	100.81	101.97	27628600.0
2013-08-29	DIA	ETF	148.02	148.98	147.82	148.25	4695500.0
2013-08-29	GLD	ETF	136.12	136.55	135.42	135.87	7939400.0
2013-08-29	TLT	ETF	104.88	106.31	104.79	106.11	6672400.0
2013-08-29	AADR	ETF	33.23	33.33	33.15	33.25	9100.0
2013-08-29	AAXJ	ETF	54.2	54.66	54.17	54.26	574100.0
2013-08-29	ACTV	ETF	9.63	10.13	9.63	10.08	275501.0
2013-08-29	ACWI	ETF	51.36	51.6	51.21	51.37	784700.0
2013-08-29	ACWV	ETF	59.95	60.17	59.87	59.96	22900.0
2013-08-29	ACWX	ETF	42.07	42.36	42.07	42.12	296097.0
2013-08-29	ADRE	ETF	34.81	35.0	34.66	34.7	30083.0
2013-08-29	AFK	ETF	28.56	28.7879	28.5	28.55	44812.0
2013-08-29	AGEM	ETF	20.6424	20.6424	20.47	20.47	2859.0
2013-08-29	AGG	ETF	106.08	106.43	106.0	106.38	476200.0
2013-08-29	AGQ	ETF	100.28	101.08	97.72	98.76	732550.0
2013-08-29	AGZ	ETF	110.41	110.71	110.2	110.6	16798.0
2013-08-29	AIA	ETF	43.9	44.29	43.9	44.04	18669.0
2013-08-29	AIQ	ETF	24.5	24.918	23.9401	24.66	79776.0
2013-08-29	AIVI	ETF	42.39	42.6	42.38	42.48	32700.0
2013-08-29	AMJ	ETF	45.12	45.385	45.0	45.2	289912.0
2013-08-29	AMLP	ETF	87.5	87.5	87.15	87.3	376720.0
2013-08-29	ANGL	ETF	26.41	26.42	26.32	26.38	800.0
2013-08-29	AOA	ETF	40.54	40.7	40.53	40.53	13300.0
2013-08-29	AOK	ETF	30.79	30.879	30.79	30.83	27477.0
2013-08-29	AOM	ETF	32.51	32.639	32.51	32.55	21242.0
2013-08-29	AOR	ETF	35.891	35.93	35.82	35.82	32004.0
2013-08-29	ARB	ETF	46.76	47.08	46.76	47.03	295893.0
2013-08-29	ARGT	ETF	18.44	18.69	18.44	18.66	25300.0
2013-08-29	ASEA	ETF	15.15	15.28	15.11	15.11	34700.0
2013-08-29	ATMP	ETF	25.99	25.99	25.91	25.97	34800.0
2013-08-29	AVIV	ETF	23.1	23.24	23.01	23.12	36187.0
2013-08-29	AWAY	ETF	30.85	31.5425	30.59	31.44	490971.0
2013-08-29	BAB	ETF	27.07	27.24	27.021	27.2	128936.0
2013-08-29	BAL	ETF	53.67	53.67	53.31	53.35	8142.0
2013-08-29	BALT	ETF	4.62	4.69	4.49	4.57	87228.0
2013-08-29	BBH	ETF	77.7	78.93	77.7	78.37	71500.0
2013-08-29	BCM	ETF	41.931	41.931	41.931	41.931	220.0
2013-08-29	BFOR	ETF	6.4725	6.5475	6.4725	6.525	127600.0
2013-08-29	BIB	ETF	28.0	28.985	28.0	28.5975	87032.0
2013-08-29	BICK	ETF	21.59	21.62	21.428	21.428	2849.0
2013-08-29	BIL	ETF	91.6	91.6	91.58	91.6	133950.0
2013-08-29	BIS	ETF	1180.0	1180.4	1160.0	1180.0	58.5
2013-08-29	BIV	ETF	82.32	82.6	82.21	82.53	323500.0
2013-08-29	BIZD	ETF	19.9	20.06	19.88	19.97	15800.0
2013-08-29	BJK	ETF	42.88	43.13	42.8	42.91	4900.0
2013-08-29	BKF	ETF	34.0	34.279	33.82	33.87	100271.0
2013-08-29	BKLN	ETF	24.69	24.74	24.67	24.72	5219200.0
2013-08-29	BLV	ETF	82.26	82.85	82.04	82.62	127000.0

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

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