PREVIEW / etf_daily / 2011-12-30

all etf daily files

  file:    by_date/etf_daily/2011/2011-12-30.parquet
  size:    37 KB
  rows:    894

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-30	SPY	ETF	126.02	126.33	125.5	125.5	95599000.0
2011-12-30	QQQ	ETF	55.86	56.12	55.82	55.83	21832343.0
2011-12-30	IWM	ETF	74.12	74.52	73.69	73.75	31979800.0
2011-12-30	DIA	ETF	122.33	122.63	121.84	121.85	4734000.0
2011-12-30	GLD	ETF	152.14	153.75	151.79	151.99	10852700.0
2011-12-30	TLT	ETF	121.11	121.76	120.89	121.25	5948800.0
2011-12-30	AADR	ETF	28.01	28.14	27.92	28.11	5300.0
2011-12-30	AAXJ	ETF	49.84	50.0	49.69	49.9	456000.0
2011-12-30	ACTV	ETF	13.33	13.61	13.31	13.6	206167.0
2011-12-30	ACWI	ETF	42.09	42.35	42.09	42.17	1673300.0
2011-12-30	ACWV	ETF	51.55	51.55	51.25	51.25	2700.0
2011-12-30	ACWX	ETF	36.65	36.93	36.53	36.81	629662.0
2011-12-30	ADRE	ETF	38.05	38.2	37.87	38.07	51073.0
2011-12-30	AFK	ETF	25.66	25.81	25.481	25.75	61346.0
2011-12-30	AGEM	ETF	20.57	20.6288	20.5632	20.6288	983.0
2011-12-30	AGG	ETF	110.51	110.64	110.24	110.25	1098300.0
2011-12-30	AGQ	ETF	171.0	176.36	165.88	166.6	907375.0
2011-12-30	AGZ	ETF	112.93	113.009	112.84	112.95	43659.0
2011-12-30	AIA	ETF	39.08	39.26	39.03	39.15	18054.0
2011-12-30	AIQ	ETF	5.1	6.5	5.1	6.3	51008.0
2011-12-30	AIS	ETF	2.18	2.24	2.16	2.2	815957.0
2011-12-30	AIVI	ETF	39.52	39.71	39.29	39.58	75900.0
2011-12-30	AMJ	ETF	38.95	39.03	38.761	38.97	2537533.0
2011-12-30	AMLP	ETF	83.0	83.15	82.7	83.1	257940.0
2011-12-30	AOA	ETF	33.12	33.21	33.05	33.05	29200.0
2011-12-30	AOK	ETF	29.39	29.39	29.31	29.35	75116.0
2011-12-30	AOM	ETF	29.87	29.96	29.87	29.9	26624.0
2011-12-30	AOR	ETF	31.19	31.24	31.14	31.14	58805.0
2011-12-30	ARB	ETF	34.81	35.0	34.2	34.41	152881.0
2011-12-30	ARGT	ETF	21.0	21.02	20.98	21.02	1700.0
2011-12-30	ASEA	ETF	14.37	14.43	14.23	14.37	13700.0
2011-12-30	AWAY	ETF	23.0	23.53	22.67	23.25	182700.0
2011-12-30	BAB	ETF	28.64	28.79	28.64	28.7	105374.0
2011-12-30	BAL	ETF	56.57	56.754	56.3625	56.46	12201.0
2011-12-30	BALT	ETF	4.48	4.7525	4.41	4.75	195405.0
2011-12-30	BBH	ETF	36.2767	36.5933	36.2767	36.43	16500.0
2011-12-30	BCM	ETF	42.908	43.15	42.908	42.96	6125.0
2011-12-30	BIB	ETF	8.6713	8.715	8.0	8.69	40720.0
2011-12-30	BICK	ETF	22.57	22.85	22.57	22.68	38730.0
2011-12-30	BIL	ETF	91.66	91.68	91.66	91.66	200350.0
2011-12-30	BIS	ETF	5305.6	5312.0	5216.0	5216.0	9.7
2011-12-30	BITS	ETF	22.32	23.0	22.3	23.0	8521.0
2011-12-30	BIV	ETF	87.02	87.14	86.89	86.97	126700.0
2011-12-30	BJK	ETF	30.0	30.2	30.0	30.07	7000.0
2011-12-30	BKF	ETF	36.1	36.37	36.08	36.27	130014.0
2011-12-30	BKLN	ETF	23.77	23.9	23.74	23.81	304100.0
2011-12-30	BLV	ETF	92.03	92.38	91.91	92.01	32800.0
2011-12-30	BMVP	ETF	13.71	13.71	13.67	13.67	10214.0
2011-12-30	BND	ETF	83.6	83.65	83.46	83.54	1535100.0
2011-12-30	BNO	ETF	37.14	37.54	37.05	37.32	47000.0

> showing 50 of 894 rows — these rows as CSV

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