PREVIEW / etf_daily / 2012-02-28

all etf daily files

  file:    by_date/etf_daily/2012/2012-02-28.parquet
  size:    38 KB
  rows:    923

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-02-28	SPY	ETF	137.2	137.72	136.93	137.56	129355900.0
2012-02-28	QQQ	ETF	64.1	64.7	64.03	64.7	43727286.0
2012-02-28	IWM	ETF	82.55	83.06	81.84	82.28	47680600.0
2012-02-28	DIA	ETF	129.64	130.04	129.34	129.86	4953700.0
2012-02-28	GLD	ETF	172.84	174.0	172.6	173.49	12413000.0
2012-02-28	TLT	ETF	118.87	119.14	117.94	118.15	6615700.0
2012-02-28	AADR	ETF	30.58	30.87	30.58	30.87	1200.0
2012-02-28	AAXJ	ETF	57.46	57.79	57.37	57.75	913700.0
2012-02-28	ACTV	ETF	15.83	16.12	15.78	15.8	293570.0
2012-02-28	ACWI	ETF	46.68	46.96	46.5	46.96	1064400.0
2012-02-28	ACWV	ETF	53.56	53.6	53.56	53.6	300.0
2012-02-28	ACWX	ETF	41.23	41.45	41.07	41.44	105752.0
2012-02-28	ADRE	ETF	43.74	44.18	43.7	44.18	33863.0
2012-02-28	AFK	ETF	30.05	30.44	30.05	30.232	22686.0
2012-02-28	AGEM	ETF	24.03	24.37	24.03	24.37	3806.0
2012-02-28	AGG	ETF	111.02	111.05	110.81	110.87	795300.0
2012-02-28	AGQ	ETF	276.32	294.12	274.6	289.32	992900.0
2012-02-28	AGZ	ETF	112.7399	112.8401	112.66	112.8	17609.0
2012-02-28	AIA	ETF	44.97	45.1692	44.944	45.16	9432.0
2012-02-28	AIQ	ETF	7.3	7.3	6.75	7.25	26069.0
2012-02-28	AIS	ETF	2.62	2.64	2.57	2.59	748717.0
2012-02-28	AIVI	ETF	42.44	42.67	42.29	42.66	41600.0
2012-02-28	AMJ	ETF	41.22	41.49	40.673	40.84	831020.0
2012-02-28	AMLP	ETF	85.8	85.85	85.1	85.45	446460.0
2012-02-28	AOA	ETF	36.08	36.19	36.06	36.18	13900.0
2012-02-28	AOK	ETF	30.21	30.24	30.1884	30.23	16677.0
2012-02-28	AOM	ETF	31.17	31.26	31.17	31.25	13492.0
2012-02-28	AOR	ETF	33.1	33.205	33.1	33.19	16120.0
2012-02-28	ARB	ETF	34.06	34.13	33.63	33.87	504784.0
2012-02-28	ARGT	ETF	23.12	23.2	23.12	23.2	250.0
2012-02-28	ASEA	ETF	15.81	15.91	15.74	15.91	10900.0
2012-02-28	AWAY	ETF	25.0	26.585	24.85	26.21	731418.0
2012-02-28	BAB	ETF	29.5	29.59	29.44	29.48	148010.0
2012-02-28	BAL	ETF	55.76	56.42	55.5	56.0	9460.0
2012-02-28	BALT	ETF	4.67	4.86	4.67	4.8	359802.0
2012-02-28	BBH	ETF	42.25	42.54	42.25	42.48	9800.0
2012-02-28	BCM	ETF	47.22	47.28	47.09	47.14	42524.0
2012-02-28	BIB	ETF	11.2775	11.4125	11.2219	11.3712	11920.0
2012-02-28	BICK	ETF	27.58	27.92	27.58	27.84	14739.0
2012-02-28	BIL	ETF	91.66	91.66	91.64	91.64	132050.0
2012-02-28	BIS	ETF	3953.6	3953.6	3894.4	3932.8	4.06
2012-02-28	BITS	ETF	20.6	21.6	20.6	21.6	2765.0
2012-02-28	BIV	ETF	88.25	88.29	88.12	88.13	234100.0
2012-02-28	BJK	ETF	34.01	34.33	34.01	34.29	6300.0
2012-02-28	BKF	ETF	43.8	44.22	43.634	44.22	969013.0
2012-02-28	BKLN	ETF	24.5	24.51	24.46	24.47	74200.0
2012-02-28	BLNG	ETF	55.68	55.68	55.5608	55.5608	800.0
2012-02-28	BLV	ETF	92.41	92.55	91.96	92.09	21000.0
2012-02-28	BMVP	ETF	15.26	15.31	15.25	15.27	6480.0
2012-02-28	BND	ETF	84.07	84.09	83.95	83.98	1615700.0

> showing 50 of 923 rows — these rows as CSV

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