PREVIEW / etf_daily / 2013-07-08

all etf daily files

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

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-07-08	SPY	ETF	163.86	164.39	163.08	163.95	108092500.0
2013-07-08	QQQ	ETF	72.94	72.99	72.38	72.65	20563730.0
2013-07-08	IWM	ETF	100.13	100.44	99.89	100.07	30905300.0
2013-07-08	DIA	ETF	151.78	152.43	151.68	152.02	4915600.0
2013-07-08	GLD	ETF	119.09	119.66	118.93	119.51	8652200.0
2013-07-08	TLT	ETF	107.07	107.56	106.95	107.29	8044200.0
2013-07-08	AADR	ETF	33.27	33.27	33.02	33.02	800.0
2013-07-08	AAXJ	ETF	53.62	54.0	53.5	53.7	388500.0
2013-07-08	ACTV	ETF	8.1	8.4	7.97	8.3	467654.0
2013-07-08	ACWI	ETF	50.65	50.82	50.56	50.66	668800.0
2013-07-08	ACWV	ETF	60.21	60.37	60.08	60.22	48700.0
2013-07-08	ACWX	ETF	40.92	41.13	40.92	41.05	342208.0
2013-07-08	ADRE	ETF	33.57	33.67	33.4	33.4	36085.0
2013-07-08	AFK	ETF	27.8	27.8	27.39	27.42	41271.0
2013-07-08	AGG	ETF	106.11	106.44	106.11	106.39	641800.0
2013-07-08	AGQ	ETF	64.56	64.92	64.24	64.24	377575.0
2013-07-08	AGZ	ETF	110.34	110.703	110.34	110.48	11383.0
2013-07-08	AIA	ETF	41.66	41.97	41.66	41.75	64515.0
2013-07-08	AIQ	ETF	16.14	16.36	16.088	16.25	65008.0
2013-07-08	AIVI	ETF	40.21	40.36	40.17	40.29	31900.0
2013-07-08	AMJ	ETF	46.48	47.61	46.05	47.544	511252.0
2013-07-08	AMLP	ETF	89.85	90.4	89.15	89.55	442840.0
2013-07-08	ANGL	ETF	26.31	26.39	26.11	26.11	8300.0
2013-07-08	AOA	ETF	40.13	40.21	40.08	40.14	25000.0
2013-07-08	AOK	ETF	30.69	30.74	30.66	30.73	29523.0
2013-07-08	AOM	ETF	32.35	32.41	32.3101	32.39	24281.0
2013-07-08	AOR	ETF	35.55	35.63	35.53	35.59	31635.0
2013-07-08	ARB	ETF	46.35	46.36	46.23	46.31	206347.0
2013-07-08	ASEA	ETF	16.39	16.49	16.34	16.4	51900.0
2013-07-08	ATMP	ETF	26.02	26.21	26.0	26.21	13000.0
2013-07-08	AVIV	ETF	24.81	24.99	24.651	24.9	226180.0
2013-07-08	AWAY	ETF	31.57	32.15	31.57	32.14	583262.0
2013-07-08	BAB	ETF	27.86	27.914	27.8001	27.86	333842.0
2013-07-08	BAL	ETF	54.84	55.08	54.04	54.66	11821.0
2013-07-08	BALT	ETF	3.63	3.74	3.63	3.73	292916.0
2013-07-08	BBH	ETF	73.4	73.41	72.4	72.51	90300.0
2013-07-08	BCM	ETF	38.9	39.184	38.9	39.17	7226.0
2013-07-08	BFOR	ETF	6.36	6.3825	6.35	6.37	358400.0
2013-07-08	BIB	ETF	25.39	25.4375	24.595	24.7548	169432.0
2013-07-08	BICK	ETF	20.65	20.65	20.56	20.5799	1430.0
2013-07-08	BIL	ETF	91.6	91.62	91.58	91.58	152300.0
2013-07-08	BIS	ETF	1380.8	1406.4	1380.8	1406.4	192.5
2013-07-08	BIV	ETF	82.53	82.79	82.5	82.75	320300.0
2013-07-08	BIZD	ETF	19.77	19.84	19.73	19.84	3400.0
2013-07-08	BJK	ETF	40.6	40.65	40.4	40.46	13600.0
2013-07-08	BKF	ETF	33.15	33.43	33.09	33.18	87034.0
2013-07-08	BKLN	ETF	24.73	24.75	24.72	24.74	1467200.0
2013-07-08	BLV	ETF	83.25	83.97	83.25	83.8	104600.0
2013-07-08	BMVP	ETF	19.067	19.067	19.021	19.037	3204.0
2013-07-08	BND	ETF	80.06	80.33	80.06	80.27	1975500.0

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

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