PREVIEW / etf_daily / 2013-08-22

all etf daily files

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

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-22	SPY	ETF	164.9	166.3	164.89	166.06	101471400.0
2013-08-22	QQQ	ETF	75.73	76.21	75.71	76.16	17269464.0
2013-08-22	IWM	ETF	101.82	102.99	101.79	102.91	24006100.0
2013-08-22	DIA	ETF	148.86	149.61	148.77	149.4	4227000.0
2013-08-22	GLD	ETF	132.56	133.46	132.27	132.81	5741800.0
2013-08-22	TLT	ETF	102.46	103.23	102.24	103.17	8751200.0
2013-08-22	AADR	ETF	33.66	33.66	32.01	33.54	4900.0
2013-08-22	AAXJ	ETF	54.36	55.1	54.18	54.51	255500.0
2013-08-22	ACTV	ETF	9.35	9.81	9.3499	9.76	200265.0
2013-08-22	ACWI	ETF	51.86	52.09	51.76	52.02	982900.0
2013-08-22	ACWV	ETF	60.18	60.57	60.11	60.4	31700.0
2013-08-22	ACWX	ETF	42.66	43.05	42.64	42.81	288521.0
2013-08-22	ADRE	ETF	34.75	34.96	34.75	34.93	16014.0
2013-08-22	AFK	ETF	29.18	29.28	29.03	29.19	39922.0
2013-08-22	AGEM	ETF	21.0399	21.1737	20.931	20.931	431.0
2013-08-22	AGG	ETF	105.52	105.6	105.33	105.55	821600.0
2013-08-22	AGQ	ETF	93.44	94.88	92.24	92.72	255375.0
2013-08-22	AGZ	ETF	110.17	110.288	110.13	110.205	220083.0
2013-08-22	AIA	ETF	43.44	43.839	43.44	43.73	24216.0
2013-08-22	AIQ	ETF	23.57	24.5	23.4	23.79	63543.0
2013-08-22	AIVI	ETF	42.9	43.13	42.9	43.07	17600.0
2013-08-22	AMJ	ETF	45.78	46.36	45.01	46.0	769009.0
2013-08-22	AMLP	ETF	87.1	87.85	87.05	87.55	734640.0
2013-08-22	ANGL	ETF	26.34	26.34	26.24	26.25	1000.0
2013-08-22	AOA	ETF	40.81	41.0	40.76	40.93	6400.0
2013-08-22	AOK	ETF	30.78	31.0131	30.77	30.89	19369.0
2013-08-22	AOM	ETF	32.59	32.689	32.585	32.68	11213.0
2013-08-22	AOR	ETF	35.96	36.99	35.0	36.0799	20580.0
2013-08-22	ARB	ETF	46.73	46.81	46.6597	46.8	109182.0
2013-08-22	ARGT	ETF	18.85	19.2	18.85	19.2	2400.0
2013-08-22	ASEA	ETF	15.5	15.64	15.5	15.55	30300.0
2013-08-22	ATMP	ETF	26.18	26.31	26.18	26.22	10100.0
2013-08-22	AVIV	ETF	23.05	23.36	22.64	23.09	105967.0
2013-08-22	AWAY	ETF	29.43	30.07	29.305	30.0	538232.0
2013-08-22	BAB	ETF	27.01	27.12	26.9401	27.05	916059.0
2013-08-22	BAL	ETF	54.05	54.07	53.829	54.0	10050.0
2013-08-22	BALT	ETF	4.52	4.7	4.51	4.68	132095.0
2013-08-22	BBH	ETF	77.0	77.89	76.92	77.53	80200.0
2013-08-22	BCM	ETF	40.93	40.98	40.86	40.98	8242.0
2013-08-22	BFOR	ETF	6.55	6.74	6.5375	6.585	240800.0
2013-08-22	BIB	ETF	27.56	28.225	27.5388	27.92	80748.0
2013-08-22	BICK	ETF	21.38	21.38	21.38	21.38	50.0
2013-08-22	BIL	ETF	91.6	91.6	91.58	91.58	240850.0
2013-08-22	BIS	ETF	1220.84	1220.84	1213.6	1213.6	52.5
2013-08-22	BIV	ETF	81.77	81.96	81.65	81.74	300200.0
2013-08-22	BIZD	ETF	19.97	20.07	19.92	20.07	45700.0
2013-08-22	BJK	ETF	42.66	42.81	42.66	42.81	5000.0
2013-08-22	BKF	ETF	34.23	34.53	34.23	34.53	81844.0
2013-08-22	BKLN	ETF	24.68	24.71	24.63	24.71	2275300.0
2013-08-22	BLNG	ETF	39.57	39.57	39.51	39.51	301.0

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

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