PREVIEW / etf_daily / 2012-03-21

all etf daily files

  file:    by_date/etf_daily/2012/2012-03-21.parquet
  size:    38 KB
  rows:    925

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
2012-03-21	SPY	ETF	140.52	140.65	139.92	140.21	122388400.0
2012-03-21	QQQ	ETF	67.13	67.49	67.03	67.12	39648089.0
2012-03-21	IWM	ETF	83.2	83.43	82.64	82.93	40504700.0
2012-03-21	DIA	ETF	131.53	131.61	130.81	130.99	5031900.0
2012-03-21	GLD	ETF	160.63	161.48	160.15	160.21	6672700.0
2012-03-21	TLT	ETF	110.86	111.89	110.81	111.79	10242000.0
2012-03-21	AADR	ETF	31.01	31.01	30.98	30.98	400.0
2012-03-21	AAXJ	ETF	56.77	56.93	56.55	56.83	171600.0
2012-03-21	ACTV	ETF	16.82	16.82	16.66	16.7	235430.0
2012-03-21	ACWI	ETF	47.3	47.32	46.91	47.11	635200.0
2012-03-21	ACWV	ETF	53.6	53.79	53.6	53.7	1400.0
2012-03-21	ACWX	ETF	40.99	41.02	40.76	40.9	206796.0
2012-03-21	ADRE	ETF	42.64	42.755	42.4412	42.67	13546.0
2012-03-21	AFK	ETF	30.0	30.13	29.572	29.7	8217.0
2012-03-21	AGEM	ETF	23.51	23.66	23.3999	23.65	17100.0
2012-03-21	AGG	ETF	109.23	109.39	109.13	109.35	590700.0
2012-03-21	AGQ	ETF	215.76	220.04	213.64	216.24	327875.0
2012-03-21	AGZ	ETF	112.15	112.22	111.971	112.14	11650.0
2012-03-21	AIA	ETF	44.55	44.74	44.37	44.74	56346.0
2012-03-21	AIQ	ETF	8.05	8.2	7.55	7.65	15442.0
2012-03-21	AIS	ETF	3.17	3.2299	3.07	3.08	1982182.0
2012-03-21	AIVI	ETF	42.09	42.16	41.93	42.08	26000.0
2012-03-21	AMJ	ETF	39.92	40.21	39.91	40.08	681205.0
2012-03-21	AMLP	ETF	84.35	84.45	83.95	84.45	400640.0
2012-03-21	AOA	ETF	36.51	36.53	36.36	36.46	4300.0
2012-03-21	AOK	ETF	30.11	30.12	30.05	30.09	12235.0
2012-03-21	AOM	ETF	31.26	31.26	31.18	31.21	28410.0
2012-03-21	AOR	ETF	33.37	33.38	33.2401	33.3001	9484.0
2012-03-21	ARB	ETF	35.49	36.12	35.07	35.89	177455.0
2012-03-21	ARGT	ETF	21.82	21.82	21.82	21.82	50.0
2012-03-21	ASEA	ETF	16.07	16.07	15.93	16.05	13600.0
2012-03-21	AWAY	ETF	25.12	25.56	24.8312	25.04	302231.0
2012-03-21	BAB	ETF	28.57	28.75	28.53	28.71	107291.0
2012-03-21	BAL	ETF	53.74	54.33	53.32	53.4	58601.0
2012-03-21	BALT	ETF	4.05	4.05	3.96	3.97	111096.0
2012-03-21	BBH	ETF	43.01	43.12	42.86	42.86	5700.0
2012-03-21	BCM	ETF	45.82	45.82	45.82	45.82	214.0
2012-03-21	BIB	ETF	11.4625	11.6888	11.4625	11.59	5896.0
2012-03-21	BICK	ETF	26.73	26.939	26.72	26.88	6420.0
2012-03-21	BIL	ETF	91.64	91.66	91.64	91.66	65800.0
2012-03-21	BIS	ETF	3824.0	3824.0	3772.8	3800.0	12.65
2012-03-21	BIV	ETF	86.25	86.46	86.25	86.45	177300.0
2012-03-21	BJK	ETF	35.67	35.82	35.58	35.66	11100.0
2012-03-21	BKF	ETF	41.79	41.87	41.45	41.75	251648.0
2012-03-21	BKLN	ETF	24.51	24.53	24.49	24.5	303200.0
2012-03-21	BLNG	ETF	50.63	50.63	50.35	50.35	300.0
2012-03-21	BLV	ETF	87.91	88.6	87.88	88.54	54100.0
2012-03-21	BMVP	ETF	15.397	15.47	15.397	15.469	4938.0
2012-03-21	BND	ETF	82.84	82.97	82.76	82.89	1520500.0
2012-03-21	BNO	ETF	43.66	43.82	43.5	43.52	126000.0

> showing 50 of 925 rows — these rows as CSV

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