PREVIEW / etf_daily / 2011-10-25

all etf daily files

  file:    by_date/etf_daily/2011/2011-10-25.parquet
  size:    37 KB
  rows:    887

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
2011-10-25	SPY	ETF	124.89	124.95	122.78	123.05	268596800.0
2011-10-25	QQQ	ETF	58.27	58.32	57.22	57.34	65299179.0
2011-10-25	IWM	ETF	72.89	72.94	71.16	71.36	66767900.0
2011-10-25	DIA	ETF	118.22	118.36	116.57	116.79	9405200.0
2011-10-25	GLD	ETF	161.24	166.34	160.41	165.59	22130800.0
2011-10-25	TLT	ETF	113.38	116.35	113.35	116.2	11791200.0
2011-10-25	AADR	ETF	28.11	28.11	28.11	28.11	200.0
2011-10-25	AAXJ	ETF	52.64	52.79	52.04	52.21	471700.0
2011-10-25	ACTV	ETF	14.17	14.17	13.77	13.94	110026.0
2011-10-25	ACWI	ETF	43.53	43.58	42.87	42.92	653300.0
2011-10-25	ACWX	ETF	38.74	38.829	38.25	38.3	228719.0
2011-10-25	ADRE	ETF	39.65	39.65	39.04	39.14	51146.0
2011-10-25	AFK	ETF	28.04	28.2292	27.78	28.03	4065.0
2011-10-25	AGEM	ETF	21.85	21.85	21.73	21.78	1572.0
2011-10-25	AGG	ETF	109.33	109.81	109.26	109.8	1478200.0
2011-10-25	AGQ	ETF	230.36	255.84	225.76	254.6	1017650.0
2011-10-25	AGZ	ETF	112.0	112.4399	112.0	112.43	39520.0
2011-10-25	AIA	ETF	40.77	40.77	40.4	40.49	9131.0
2011-10-25	AIQ	ETF	5.95	5.95	5.45	5.55	43694.0
2011-10-25	AIS	ETF	2.28	2.3	2.21	2.23	646185.0
2011-10-25	AIVI	ETF	42.3	42.3	41.7	41.86	54400.0
2011-10-25	AMJ	ETF	36.84	36.992	36.51	36.64	2384364.0
2011-10-25	AMLP	ETF	80.05	80.25	79.3	79.4	171320.0
2011-10-25	AOA	ETF	33.17	33.17	32.82	32.98	4500.0
2011-10-25	AOK	ETF	29.23	29.24	29.15	29.182	19625.0
2011-10-25	AOM	ETF	29.95	29.95	29.8155	29.827	22423.0
2011-10-25	AOR	ETF	31.2	31.2	30.96	30.96	18966.0
2011-10-25	ARB	ETF	41.21	42.13	39.55	39.79	268633.0
2011-10-25	ARGT	ETF	22.22	22.22	22.14	22.14	1300.0
2011-10-25	ASEA	ETF	15.04	15.04	14.83	14.86	3600.0
2011-10-25	AWAY	ETF	36.66	36.98	36.3	36.5	58644.0
2011-10-25	BAB	ETF	27.63	28.15	27.63	28.15	484855.0
2011-10-25	BAL	ETF	60.59	62.21	60.49	61.36	41968.0
2011-10-25	BALT	ETF	5.73	5.76	5.505	5.52	129649.0
2011-10-25	BBH	ETF	35.3067	35.3067	34.51	34.5167	127200.0
2011-10-25	BCM	ETF	44.12	44.573	44.12	44.573	543.0
2011-10-25	BIB	ETF	7.92	7.92	7.4275	7.4275	50768.0
2011-10-25	BICK	ETF	25.38	25.38	24.998	24.998	7589.0
2011-10-25	BIL	ETF	91.68	91.7	91.68	91.7	482500.0
2011-10-25	BIS	ETF	6230.4	6230.4	6230.4	6230.4	2.5
2011-10-25	BITS	ETF	21.8	23.0	21.8	22.08	1140.0
2011-10-25	BIV	ETF	86.93	87.53	86.92	87.53	146000.0
2011-10-25	BJK	ETF	31.44	31.44	30.81	30.84	48000.0
2011-10-25	BKF	ETF	38.21	38.35	37.85	37.85	110097.0
2011-10-25	BKLN	ETF	23.92	23.92	23.74	23.82	57600.0
2011-10-25	BLNG	ETF	50.34	50.75	50.34	50.75	11400.0
2011-10-25	BLV	ETF	89.43	91.32	89.43	91.14	60500.0
2011-10-25	BMVP	ETF	13.5541	13.6033	13.4357	13.4357	6342.0
2011-10-25	BND	ETF	83.15	83.61	83.15	83.59	1615800.0
2011-10-25	BNO	ETF	37.97	38.15	37.59	38.04	124800.0

> showing 50 of 887 rows — these rows as CSV

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