PREVIEW / etf_daily / 2012-08-02

all etf daily files

  file:    by_date/etf_daily/2012/2012-08-02.parquet
  size:    38 KB
  rows:    940

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-08-02	SPY	ETF	136.55	137.57	135.58	136.64	199556600.0
2012-08-02	QQQ	ETF	64.1	65.02	63.91	64.38	40544547.0
2012-08-02	IWM	ETF	76.27	77.31	76.25	76.78	43374800.0
2012-08-02	DIA	ETF	128.66	129.29	127.51	128.54	10915200.0
2012-08-02	GLD	ETF	154.66	155.14	153.61	154.13	11538800.0
2012-08-02	TLT	ETF	129.59	130.69	129.13	129.51	7972000.0
2012-08-02	AADR	ETF	28.16	28.16	28.16	28.16	13700.0
2012-08-02	AAXJ	ETF	52.63	52.87	52.15	52.48	144200.0
2012-08-02	ACTV	ETF	13.99	14.12	13.8	13.95	223671.0
2012-08-02	ACWI	ETF	43.84	44.13	43.44	43.76	751000.0
2012-08-02	ACWV	ETF	55.18	55.38	54.92	55.2	78900.0
2012-08-02	ACWX	ETF	36.89	37.2	36.56	36.75	177744.0
2012-08-02	ADRE	ETF	37.46	37.93	37.46	37.59	105372.0
2012-08-02	AFK	ETF	28.07	28.34	28.0686	28.29	38935.0
2012-08-02	AGEM	ETF	21.45	21.45	20.94	20.94	7502.0
2012-08-02	AGG	ETF	112.33	112.5	112.26	112.26	846300.0
2012-08-02	AGQ	ETF	148.12	149.44	145.2	146.92	293300.0
2012-08-02	AGZ	ETF	113.8	113.8	113.61	113.66	34585.0
2012-08-02	AIA	ETF	42.13	42.14	41.63	41.8	13960.0
2012-08-02	AIQ	ETF	4.4	4.85	4.4	4.8495	40319.0
2012-08-02	AIVI	ETF	37.59	37.82	37.06	37.35	72100.0
2012-08-02	AMJ	ETF	39.63	39.85	39.22	39.22	1739523.0
2012-08-02	AMLP	ETF	82.5	83.0	81.95	82.1	304800.0
2012-08-02	ANGL	ETF	26.38	26.38	26.0	26.0	10900.0
2012-08-02	AOA	ETF	34.92	35.06	34.76	34.93	6800.0
2012-08-02	AOK	ETF	30.0	30.02	29.94	29.97	39568.0
2012-08-02	AOM	ETF	30.9	30.92	30.72	30.79	62735.0
2012-08-02	AOR	ETF	32.49	32.653	32.41	32.4814	26030.0
2012-08-02	ARB	ETF	34.14	35.82	34.03	35.61	165354.0
2012-08-02	ASEA	ETF	16.11	16.21	16.05	16.17	34100.0
2012-08-02	AWAY	ETF	22.66	22.9	22.32	22.83	246893.0
2012-08-02	BAB	ETF	30.62	30.65	30.45	30.45	198866.0
2012-08-02	BAL	ETF	46.81	46.96	46.35	46.73	29447.0
2012-08-02	BALT	ETF	3.1	3.32	3.1	3.27	97143.0
2012-08-02	BBH	ETF	48.56	49.24	48.56	48.86	26300.0
2012-08-02	BCM	ETF	43.25	43.25	43.09	43.09	2482.0
2012-08-02	BIB	ETF	13.2188	13.45	12.9938	13.2592	34512.0
2012-08-02	BICK	ETF	22.2	22.3825	22.09	22.234	19874.0
2012-08-02	BIL	ETF	91.64	91.66	91.64	91.64	105600.0
2012-08-02	BIS	ETF	3043.2	3097.52	3031.36	3076.8	25.3
2012-08-02	BIV	ETF	89.94	90.08	89.84	89.84	228100.0
2012-08-02	BJK	ETF	29.86	29.9	29.52	29.64	12100.0
2012-08-02	BKF	ETF	35.41	35.7	35.158	35.35	36257.0
2012-08-02	BKLN	ETF	24.6	24.61	24.55	24.57	224200.0
2012-08-02	BLV	ETF	98.41	99.0	98.21	98.37	65400.0
2012-08-02	BMVP	ETF	15.1833	15.3455	15.1833	15.3033	36619.0
2012-08-02	BND	ETF	85.12	85.21	85.06	85.1	899500.0
2012-08-02	BNO	ETF	37.355	37.87	37.335	37.64	120000.0
2012-08-02	BOIL	ETF	1069000.0	1070000.0	936400.0	945800.0	24.2
2012-08-02	BOND	ETF	107.3	107.41	107.25	107.38	401898.0

> showing 50 of 940 rows — these rows as CSV

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