PREVIEW / etf_daily / 2012-03-05

all etf daily files

  file:    by_date/etf_daily/2012/2012-03-05.parquet
  size:    38 KB
  rows:    921

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-05	SPY	ETF	137.1	137.2	136.28	136.75	140765000.0
2012-03-05	QQQ	ETF	64.83	64.91	63.99	64.2	45788685.0
2012-03-05	IWM	ETF	79.99	80.4	79.42	80.34	44334800.0
2012-03-05	DIA	ETF	129.42	129.59	128.64	129.42	5286400.0
2012-03-05	GLD	ETF	165.77	165.91	164.55	165.65	12071400.0
2012-03-05	TLT	ETF	116.96	117.44	116.22	116.22	6921900.0
2012-03-05	AADR	ETF	30.2	30.2	30.2	30.2	600.0
2012-03-05	AAXJ	ETF	57.47	57.59	57.14	57.24	1122200.0
2012-03-05	ACTV	ETF	15.88	16.0508	15.84	15.86	310951.0
2012-03-05	ACWI	ETF	46.57	46.64	46.31	46.49	423600.0
2012-03-05	ACWX	ETF	41.04	41.06	40.72	40.89	154873.0
2012-03-05	ADRE	ETF	43.71	43.815	43.23	43.36	15260.0
2012-03-05	AFK	ETF	30.19	30.229	30.0	30.07	15387.0
2012-03-05	AGEM	ETF	24.15	24.15	24.15	24.15	300.0
2012-03-05	AGG	ETF	110.48	110.52	110.32	110.34	1098100.0
2012-03-05	AGQ	ETF	251.32	251.64	236.28	243.12	779400.0
2012-03-05	AGZ	ETF	112.85	112.85	112.65	112.7524	40263.0
2012-03-05	AIA	ETF	45.02	45.08	44.71	44.82	12693.0
2012-03-05	AIQ	ETF	6.7	6.7625	6.5	6.55	2300.0
2012-03-05	AIS	ETF	2.64	2.75	2.59	2.71	2157841.0
2012-03-05	AIVI	ETF	42.06	42.06	41.77	42.01	59300.0
2012-03-05	AMJ	ETF	40.65	40.8999	40.51	40.66	1275113.0
2012-03-05	AMLP	ETF	85.3	85.45	84.75	85.05	232080.0
2012-03-05	AOA	ETF	35.94	35.97	35.75	35.84	15600.0
2012-03-05	AOK	ETF	30.07	30.08	30.0201	30.05	37227.0
2012-03-05	AOM	ETF	31.13	31.13	31.025	31.04	5801.0
2012-03-05	AOR	ETF	33.02	33.02	32.889	32.91	31986.0
2012-03-05	ARB	ETF	33.09	33.86	33.0	33.65	193393.0
2012-03-05	ARGT	ETF	23.0	23.0	23.0	23.0	100.0
2012-03-05	ASEA	ETF	16.12	16.12	15.92	15.92	900.0
2012-03-05	AWAY	ETF	27.0	27.38	26.8	27.25	802230.0
2012-03-05	BAB	ETF	29.42	29.48	29.34	29.37	156958.0
2012-03-05	BAL	ETF	56.92	57.39	56.5	57.37	57565.0
2012-03-05	BALT	ETF	4.15	4.1899	4.0	4.08	175727.0
2012-03-05	BBH	ETF	42.48	42.48	41.94	42.11	11200.0
2012-03-05	BCM	ETF	46.34	46.43	46.322	46.322	38648.0
2012-03-05	BIB	ETF	11.3863	11.3863	11.0525	11.1438	58160.0
2012-03-05	BICK	ETF	27.72	27.72	27.33	27.39	5992.0
2012-03-05	BIL	ETF	91.62	91.64	91.62	91.64	248900.0
2012-03-05	BIS	ETF	3966.4	3983.04	3960.0	3960.0	7.5
2012-03-05	BITS	ETF	21.52	21.52	21.0	21.4	625.0
2012-03-05	BIV	ETF	87.88	87.91	87.71	87.73	184600.0
2012-03-05	BJK	ETF	34.94	34.94	34.35	34.42	12900.0
2012-03-05	BKF	ETF	43.88	43.88	43.3205	43.4	597043.0
2012-03-05	BKLN	ETF	24.56	24.56	24.51	24.54	215900.0
2012-03-05	BLNG	ETF	52.7899	52.7899	52.7899	52.7899	185.0
2012-03-05	BLV	ETF	91.59	91.75	91.03	91.06	43100.0
2012-03-05	BMVP	ETF	15.1	15.11	15.05	15.1	2779.0
2012-03-05	BND	ETF	83.73	83.77	83.54	83.57	1208500.0
2012-03-05	BNO	ETF	43.35	43.5	43.005	43.34	45600.0

> showing 50 of 921 rows — these rows as CSV

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