PREVIEW / etf_daily / 2013-03-01

all etf daily files

  file:    by_date/etf_daily/2013/2013-03-01.parquet
  size:    40 KB
  rows:    978

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-03-01	SPY	ETF	151.09	152.34	150.41	152.11	170634800.0
2013-03-01	QQQ	ETF	66.86	67.5	66.54	67.38	31617692.0
2013-03-01	IWM	ETF	89.88	91.06	89.21	90.89	49278200.0
2013-03-01	DIA	ETF	139.89	140.9	139.17	140.74	6506400.0
2013-03-01	GLD	ETF	153.16	153.61	152.14	152.44	11178800.0
2013-03-01	TLT	ETF	118.84	119.21	118.54	118.9	7786800.0
2013-03-01	AADR	ETF	33.23	33.23	33.23	33.23	300.0
2013-03-01	AAXJ	ETF	59.88	60.22	59.73	60.13	729800.0
2013-03-01	ACTV	ETF	4.65	4.7	4.45	4.53	1334757.0
2013-03-01	ACWI	ETF	49.61	49.92	49.41	49.89	605300.0
2013-03-01	ACWV	ETF	59.3	59.58	59.19	59.54	671100.0
2013-03-01	ACWX	ETF	42.38	42.59	42.16	42.58	100164.0
2013-03-01	ADRE	ETF	38.99	39.23	38.95	39.22	12457.0
2013-03-01	AFK	ETF	30.55	30.684	30.2725	30.62	16443.0
2013-03-01	AGEM	ETF	22.6043	22.81	22.6043	22.8	512.0
2013-03-01	AGG	ETF	110.64	110.72	110.57	110.66	1076800.0
2013-03-01	AGQ	ETF	154.36	155.6	152.32	153.76	266175.0
2013-03-01	AGZ	ETF	113.3	113.4	113.2701	113.36	28030.0
2013-03-01	AIA	ETF	47.15	47.39	47.09	47.39	5368.0
2013-03-01	AIQ	ETF	6.99	7.0	6.95	7.0	1100.0
2013-03-01	AIVI	ETF	41.48	41.72	41.35	41.72	23500.0
2013-03-01	AMJ	ETF	43.09	43.27	42.88	43.15	855404.0
2013-03-01	AMLP	ETF	85.25	85.5	85.0	85.15	533200.0
2013-03-01	ANGL	ETF	26.91	26.94	26.91	26.94	500.0
2013-03-01	AOA	ETF	38.73	38.85	38.5	38.82	53500.0
2013-03-01	AOK	ETF	30.87	30.99	30.8501	30.98	19984.0
2013-03-01	AOM	ETF	32.35	32.46	32.2807	32.46	20259.0
2013-03-01	AOR	ETF	34.96	35.09	34.85	35.09	61196.0
2013-03-01	ARB	ETF	46.8	46.94	46.75	46.76	432462.0
2013-03-01	ARGT	ETF	16.68	16.94	16.64	16.94	4650.0
2013-03-01	ASEA	ETF	17.31	17.4	17.21	17.35	57400.0
2013-03-01	AWAY	ETF	28.87	29.8125	28.76	29.72	1156952.0
2013-03-01	BAB	ETF	30.6	30.62	30.56	30.62	146825.0
2013-03-01	BAL	ETF	55.09	55.35	54.74	55.13	112362.0
2013-03-01	BALT	ETF	3.67	3.78	3.65	3.78	103788.0
2013-03-01	BBH	ETF	59.1	60.07	58.83	60.05	21900.0
2013-03-01	BCM	ETF	42.694	42.694	42.694	42.694	1305.0
2013-03-01	BIB	ETF	16.48	17.14	16.46	17.14	76960.0
2013-03-01	BICK	ETF	24.79	24.94	24.7501	24.94	2960.0
2013-03-01	BIL	ETF	91.62	91.62	91.6	91.62	67500.0
2013-03-01	BIS	ETF	2260.0	2260.0	2202.4	2222.24	47.5
2013-03-01	BIV	ETF	87.77	87.9	87.74	87.9	208600.0
2013-03-01	BIZD	ETF	20.2	20.38	20.15	20.36	3400.0
2013-03-01	BJK	ETF	38.29	38.5	38.29	38.47	4000.0
2013-03-01	BKF	ETF	39.56	39.83	39.5048	39.75	198103.0
2013-03-01	BKLN	ETF	24.98	25.0	24.98	24.98	1531900.0
2013-03-01	BLV	ETF	92.4	92.46	92.1	92.45	40800.0
2013-03-01	BMVP	ETF	17.6467	17.7998	17.63	17.7867	8243.0
2013-03-01	BND	ETF	83.62	83.67	83.54	83.62	839700.0
2013-03-01	BNO	ETF	41.315	41.535	41.24	41.495	106000.0

> showing 50 of 978 rows — these rows as CSV

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