PREVIEW / etf_daily / 2012-04-24

all etf daily files

  file:    by_date/etf_daily/2012/2012-04-24.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-04-24	SPY	ETF	136.91	137.66	136.8	137.31	137484200.0
2012-04-24	QQQ	ETF	64.97	65.23	64.45	64.73	49661432.0
2012-04-24	IWM	ETF	79.13	79.93	78.86	79.7	44810200.0
2012-04-24	DIA	ETF	129.27	130.23	129.26	129.72	4418700.0
2012-04-24	GLD	ETF	159.63	160.18	159.29	159.3	5200600.0
2012-04-24	TLT	ETF	117.61	117.76	117.08	117.09	4336600.0
2012-04-24	AADR	ETF	30.05	30.05	30.05	30.05	200.0
2012-04-24	AAXJ	ETF	55.35	55.61	55.29	55.39	117600.0
2012-04-24	ACTV	ETF	16.79	16.91	16.62	16.74	443593.0
2012-04-24	ACWI	ETF	45.83	46.05	45.75	45.9	878100.0
2012-04-24	ACWX	ETF	39.4	39.65	39.39	39.5	92816.0
2012-04-24	ADRE	ETF	40.82	40.9	40.69	40.73	28338.0
2012-04-24	AFK	ETF	29.28	29.29	29.13	29.148	5719.0
2012-04-24	AGG	ETF	110.53	110.58	110.41	110.43	627500.0
2012-04-24	AGQ	ETF	199.64	200.84	194.88	196.68	245175.0
2012-04-24	AGZ	ETF	112.87	112.95	112.73	112.91	8751.0
2012-04-24	AIA	ETF	44.01	44.18	43.88	43.9323	17585.0
2012-04-24	AIQ	ETF	6.6	6.65	6.45	6.6	12739.0
2012-04-24	AIS	ETF	2.97	2.98	2.93	2.94	517268.0
2012-04-24	AIVI	ETF	39.71	40.09	39.71	39.91	24000.0
2012-04-24	AMJ	ETF	39.4	39.64	39.4	39.5	826274.0
2012-04-24	AMLP	ETF	83.3	83.7	83.3	83.4	364960.0
2012-04-24	ANGL	ETF	25.55	25.55	25.48	25.52	1600.0
2012-04-24	AOA	ETF	35.54	35.71	35.54	35.56	14300.0
2012-04-24	AOK	ETF	29.98	30.01	29.95	29.9603	34618.0
2012-04-24	AOM	ETF	30.93	30.9925	30.926	30.96	14968.0
2012-04-24	AOR	ETF	32.81	32.91	32.78	32.84	20342.0
2012-04-24	ARB	ETF	38.05	38.47	37.91	38.17	275425.0
2012-04-24	ARGT	ETF	18.38	18.42	18.38	18.38	550.0
2012-04-24	ASEA	ETF	16.04	16.09	16.0	16.02	33600.0
2012-04-24	AWAY	ETF	23.67	25.94	23.67	25.1	654191.0
2012-04-24	BAB	ETF	29.6	29.6	29.48	29.51	122320.0
2012-04-24	BAL	ETF	57.52	57.73	56.07	56.65	65018.0
2012-04-24	BALT	ETF	4.42	4.53	4.38	4.53	143684.0
2012-04-24	BBH	ETF	44.77	44.96	44.65	44.81	24800.0
2012-04-24	BCM	ETF	44.3	44.3	44.3	44.3	882.0
2012-04-24	BIB	ETF	11.6375	11.6375	11.5962	11.5962	1600.0
2012-04-24	BICK	ETF	25.03	25.223	25.03	25.17	16589.0
2012-04-24	BIL	ETF	91.66	91.66	91.64	91.66	271500.0
2012-04-24	BIS	ETF	3721.6	3723.2	3705.6	3705.6	8.6
2012-04-24	BIV	ETF	87.76	87.78	87.65	87.71	328400.0
2012-04-24	BJK	ETF	36.04	36.15	35.86	35.89	16100.0
2012-04-24	BKF	ETF	39.83	40.03	39.7401	39.87	90167.0
2012-04-24	BKLN	ETF	24.41	24.46	24.4	24.42	119900.0
2012-04-24	BLV	ETF	91.1	91.2	90.95	91.14	308500.0
2012-04-24	BMVP	ETF	15.2	15.25	15.17	15.2	5898.0
2012-04-24	BND	ETF	83.79	83.83	83.7	83.73	1104600.0
2012-04-24	BNO	ETF	41.9	41.9	41.62	41.64	43200.0
2012-04-24	BOIL	ETF	639000.0	644000.0	622000.0	624000.0	5.2
2012-04-24	BOND	ETF	103.2	103.22	103.08	103.12	506524.0

> showing 50 of 921 rows — these rows as CSV

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