PREVIEW / etf_daily / 2012-09-26

all etf daily files

  file:    by_date/etf_daily/2012/2012-09-26.parquet
  size:    39 KB
  rows:    942

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-09-26	SPY	ETF	144.07	144.11	142.95	143.29	146502200.0
2012-09-26	QQQ	ETF	68.67	68.71	67.85	68.2	32770371.0
2012-09-26	IWM	ETF	83.85	83.93	82.84	83.14	42167400.0
2012-09-26	DIA	ETF	134.37	134.51	133.74	133.9	5447700.0
2012-09-26	GLD	ETF	169.46	170.05	168.34	169.81	12064800.0
2012-09-26	TLT	ETF	124.56	125.09	124.45	125.04	7193400.0
2012-09-26	AAXJ	ETF	55.48	55.56	55.14	55.34	149000.0
2012-09-26	ACTV	ETF	12.29	12.4	12.2	12.39	208052.0
2012-09-26	ACWI	ETF	46.76	46.83	46.48	46.69	355400.0
2012-09-26	ACWV	ETF	56.5	56.61	56.32	56.54	252800.0
2012-09-26	ACWX	ETF	39.64	39.7	39.395	39.6	250627.0
2012-09-26	ADRE	ETF	38.8	38.934	38.5	38.89	23693.0
2012-09-26	AFK	ETF	31.04	31.14	30.92	31.0406	38604.0
2012-09-26	AGG	ETF	112.36	112.4	112.26	112.36	793500.0
2012-09-26	AGQ	ETF	222.56	227.2	218.88	225.52	443300.0
2012-09-26	AGZ	ETF	113.78	114.05	113.78	114.01	23409.0
2012-09-26	AIA	ETF	44.17	44.17	43.76	43.76	197255.0
2012-09-26	AIQ	ETF	6.75	7.0	6.75	6.9	4359.0
2012-09-26	AIVI	ETF	40.68	40.68	40.3	40.42	57700.0
2012-09-26	AMJ	ETF	40.0	40.2	39.92	40.0	662161.0
2012-09-26	AMLP	ETF	82.45	82.45	82.05	82.25	248560.0
2012-09-26	ANGL	ETF	26.43	26.44	26.29	26.32	3900.0
2012-09-26	AOA	ETF	36.63	36.66	36.5	36.58	20400.0
2012-09-26	AOK	ETF	30.57	30.57	30.44	30.5	11340.0
2012-09-26	AOM	ETF	31.5001	31.537	31.48	31.5	19958.0
2012-09-26	AOR	ETF	33.67	33.67	33.56	33.57	25846.0
2012-09-26	ARB	ETF	38.01	38.18	37.5	37.61	87544.0
2012-09-26	ARGT	ETF	17.76	17.76	17.62	17.68	1150.0
2012-09-26	ASEA	ETF	16.5	16.5	16.35	16.43	11900.0
2012-09-26	AWAY	ETF	24.0	24.0	23.28	23.42	352534.0
2012-09-26	BAB	ETF	30.13	30.23	30.07	30.21	810070.0
2012-09-26	BAL	ETF	47.43	47.43	46.7202	46.74	32263.0
2012-09-26	BALT	ETF	3.25	3.2517	3.15	3.15	35938.0
2012-09-26	BBH	ETF	54.1	54.22	53.3	53.38	16400.0
2012-09-26	BCM	ETF	45.41	45.46	45.289	45.412	1898.0
2012-09-26	BIB	ETF	15.7338	15.7613	15.23	15.23	60520.0
2012-09-26	BICK	ETF	23.38	23.53	23.355	23.41	13946.0
2012-09-26	BIL	ETF	91.62	91.64	91.62	91.62	150900.0
2012-09-26	BIS	ETF	2616.0	2632.0	2598.4	2627.2	88.5
2012-09-26	BIV	ETF	90.11	90.28	90.05	90.24	134600.0
2012-09-26	BJK	ETF	33.59	33.7	33.41	33.42	2800.0
2012-09-26	BKF	ETF	37.53	37.53	37.13	37.4	101808.0
2012-09-26	BKLN	ETF	24.96	24.99	24.94	24.95	615400.0
2012-09-26	BLV	ETF	96.65	96.84	96.52	96.8	48700.0
2012-09-26	BMVP	ETF	16.06	16.06	15.9234	15.9533	4254.0
2012-09-26	BND	ETF	85.1	85.17	85.02	85.12	1245800.0
2012-09-26	BNO	ETF	39.555	39.66	39.22	39.65	104800.0
2012-09-26	BOIL	ETF	915000.0	962000.0	910800.0	944800.0	19.8
2012-09-26	BOND	ETF	109.03	109.1	108.94	109.048	547738.0
2012-09-26	BRF	ETF	40.26	40.78	40.0	40.75	195676.0

> showing 50 of 942 rows — these rows as CSV

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