PREVIEW / etf_daily / 2011-12-22

all etf daily files

  file:    by_date/etf_daily/2011/2011-12-22.parquet
  size:    37 KB
  rows:    890

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-12-22	SPY	ETF	124.63	125.4	124.23	125.27	119465400.0
2011-12-22	QQQ	ETF	55.22	55.6261	55.17	55.6	40334025.0
2011-12-22	IWM	ETF	74.16	74.67	73.98	74.27	41502800.0
2011-12-22	DIA	ETF	121.14	121.55	120.91	121.53	4202800.0
2011-12-22	GLD	ETF	156.35	156.8	155.33	156.04	9888400.0
2011-12-22	TLT	ETF	120.0	120.42	119.35	119.6	5247400.0
2011-12-22	AADR	ETF	27.94	27.97	27.87	27.9	5200.0
2011-12-22	AAXJ	ETF	50.04	50.52	50.0	50.35	2806000.0
2011-12-22	ACTV	ETF	13.21	13.5	13.09	13.44	88657.0
2011-12-22	ACWI	ETF	41.83	42.12	41.75	42.07	1340400.0
2011-12-22	ACWV	ETF	51.09	51.09	51.03	51.03	700.0
2011-12-22	ACWX	ETF	36.38	36.69	36.1951	36.65	712793.0
2011-12-22	ADRE	ETF	37.84	38.31	37.84	38.24	49852.0
2011-12-22	AFK	ETF	26.83	27.0	26.77	26.9	15784.0
2011-12-22	AGEM	ETF	20.83	21.14	20.83	21.14	3414.0
2011-12-22	AGG	ETF	109.9	109.94	109.78	109.9	1465900.0
2011-12-22	AGQ	ETF	189.36	190.68	186.08	187.68	471550.0
2011-12-22	AGZ	ETF	112.839	113.01	112.63	112.84	167689.0
2011-12-22	AIA	ETF	39.27	39.566	39.21	39.566	22284.0
2011-12-22	AIQ	ETF	5.25	6.4	5.25	6.0	181845.0
2011-12-22	AIS	ETF	1.82	1.86	1.78	1.83	1356031.0
2011-12-22	AIVI	ETF	38.96	39.31	38.91	39.3	109300.0
2011-12-22	AMJ	ETF	38.15	38.25	37.99	38.07	959233.0
2011-12-22	AMLP	ETF	82.5	82.5	81.4	81.4	538020.0
2011-12-22	AOA	ETF	33.1	33.27	33.09	33.25	8800.0
2011-12-22	AOK	ETF	29.35	29.39	29.32	29.38	45302.0
2011-12-22	AOM	ETF	29.93	30.04	29.93	30.04	26034.0
2011-12-22	AOR	ETF	31.23	31.315	31.23	31.3	15040.0
2011-12-22	ARB	ETF	35.5	35.92	35.27	35.68	114360.0
2011-12-22	ARGT	ETF	21.88	21.88	21.88	21.88	100.0
2011-12-22	ASEA	ETF	14.71	14.96	14.71	14.96	2800.0
2011-12-22	AWAY	ETF	20.73	21.97	20.64	20.85	263169.0
2011-12-22	BAB	ETF	29.2	29.2	28.611	28.82	243850.0
2011-12-22	BAL	ETF	53.8591	54.0	53.65	54.0	4459.0
2011-12-22	BALT	ETF	4.92	5.0	4.81	5.0	78806.0
2011-12-22	BBH	ETF	35.2633	35.96	35.2633	35.6933	7500.0
2011-12-22	BCM	ETF	42.8	43.24	42.8	43.039	3142.0
2011-12-22	BIB	ETF	8.4187	8.47	8.4187	8.47	5048.0
2011-12-22	BICK	ETF	22.97	23.18	22.91	23.1	44735.0
2011-12-22	BIL	ETF	91.68	91.68	91.66	91.68	141850.0
2011-12-22	BIS	ETF	5403.2	5403.2	5368.0	5387.2	3.75
2011-12-22	BITS	ETF	22.88	23.0	22.36	22.72	3225.0
2011-12-22	BIV	ETF	87.82	87.85	87.63	87.77	124700.0
2011-12-22	BJK	ETF	30.17	30.21	30.05	30.16	14700.0
2011-12-22	BKF	ETF	36.45	36.81	36.426	36.8	135786.0
2011-12-22	BKLN	ETF	23.85	23.94	23.77	23.89	216800.0
2011-12-22	BLV	ETF	91.8	91.91	91.4	91.6	30300.0
2011-12-22	BMVP	ETF	13.57	13.64	13.57	13.63	23944.0
2011-12-22	BND	ETF	83.76	83.83	83.72	83.78	859700.0
2011-12-22	BNO	ETF	37.5	37.595	37.35	37.35	43400.0

> showing 50 of 890 rows — these rows as CSV

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