PREVIEW / etf_daily / 2013-09-03

all etf daily files

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

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-03	SPY	ETF	165.23	165.58	163.7	164.39	142375100.0
2013-09-03	QQQ	ETF	76.1	76.44	75.54	75.9	27241431.0
2013-09-03	IWM	ETF	101.86	102.37	100.13	101.06	37995800.0
2013-09-03	DIA	ETF	148.88	149.2	147.61	148.11	5430300.0
2013-09-03	GLD	ETF	135.46	136.79	135.03	136.42	8100700.0
2013-09-03	TLT	ETF	104.59	104.67	103.51	104.22	12084300.0
2013-09-03	AADR	ETF	33.58	33.72	33.38	33.39	14300.0
2013-09-03	AAXJ	ETF	55.58	55.72	55.14	55.21	1022600.0
2013-09-03	ACTV	ETF	9.91	10.02	9.48	9.62	568120.0
2013-09-03	ACWI	ETF	51.9	51.97	51.41	51.6	1299700.0
2013-09-03	ACWV	ETF	60.59	60.66	59.84	59.88	32700.0
2013-09-03	ACWX	ETF	42.76	42.768	42.3	42.48	299726.0
2013-09-03	ADRE	ETF	35.26	35.26	34.9401	35.1	20149.0
2013-09-03	AFK	ETF	28.9	29.31	28.73	28.99	38581.0
2013-09-03	AGEM	ETF	21.11	21.11	20.6925	20.88	2883.0
2013-09-03	AGG	ETF	105.63	105.96	105.53	105.75	1345200.0
2013-09-03	AGQ	ETF	103.44	103.6	101.84	101.92	423625.0
2013-09-03	AGZ	ETF	110.4	110.582	110.231	110.3099	10898.0
2013-09-03	AIA	ETF	44.96	45.25	44.87	44.87	21435.0
2013-09-03	AIQ	ETF	24.42	25.6	24.42	25.46	82518.0
2013-09-03	AIVI	ETF	42.88	42.94	42.6	42.75	46400.0
2013-09-03	ALTL	ETF	29.12	29.12	29.05	29.05	400.0
2013-09-03	AMJ	ETF	45.43	45.77	44.21	44.6	445834.0
2013-09-03	AMLP	ETF	86.9	87.45	85.95	86.55	638380.0
2013-09-03	ANGL	ETF	26.4	26.4	26.25	26.3	3200.0
2013-09-03	AOA	ETF	40.71	40.79	40.35	40.48	17600.0
2013-09-03	AOK	ETF	30.91	30.91	30.7704	30.814	3512.0
2013-09-03	AOM	ETF	32.67	32.73	32.48	32.54	7461.0
2013-09-03	AOR	ETF	35.92	36.01	35.718	35.8	21128.0
2013-09-03	ARB	ETF	47.06	47.27	47.006	47.27	357111.0
2013-09-03	ARGT	ETF	18.56	18.59	18.52	18.52	2100.0
2013-09-03	ASEA	ETF	15.31	15.42	15.26	15.26	151300.0
2013-09-03	ATMP	ETF	25.81	26.01	25.46	25.58	251600.0
2013-09-03	AVIV	ETF	22.86	23.11	21.31	21.8	292946.0
2013-09-03	AWAY	ETF	31.45	31.84	31.14	31.27	697487.0
2013-09-03	BAB	ETF	27.25	27.25	26.99	27.05	101834.0
2013-09-03	BAL	ETF	53.5	53.5	52.83	52.88	204394.0
2013-09-03	BALT	ETF	4.47	4.489	4.36	4.43	135003.0
2013-09-03	BBH	ETF	78.16	79.28	78.16	79.0	74700.0
2013-09-03	BCM	ETF	41.97	41.97	41.97	41.97	171.0
2013-09-03	BFOR	ETF	6.5825	6.6875	6.4575	6.495	168800.0
2013-09-03	BIB	ETF	28.585	29.31	28.585	29.1475	339520.0
2013-09-03	BICK	ETF	21.81	21.81	21.72	21.722	600.0
2013-09-03	BIL	ETF	91.58	91.6	91.58	91.6	370900.0
2013-09-03	BIS	ETF	1202.8	1202.8	1149.2	1152.4	868.0
2013-09-03	BIV	ETF	81.92	82.05	81.63	81.98	1236800.0
2013-09-03	BIZD	ETF	20.05	20.07	19.77	19.77	5000.0
2013-09-03	BJK	ETF	44.06	44.06	43.72	43.78	5400.0
2013-09-03	BKF	ETF	34.63	34.66	34.3255	34.39	99649.0
2013-09-03	BKLN	ETF	24.74	24.76	24.71	24.76	1334200.0

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

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