PREVIEW / etf_daily / 2010-11-26

all etf daily files

  file:    by_date/etf_daily/2010/2010-11-26.parquet
  size:    33 KB
  rows:    792

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
2010-11-26	SPY	ETF	119.16	119.81	118.8	118.8	76007800.0
2010-11-26	QQQ	ETF	52.8	53.13	52.67	52.97	23640289.0
2010-11-26	IWM	ETF	73.28	73.73	73.13	73.22	19004000.0
2010-11-26	DIA	ETF	110.94	111.35	110.64	110.64	2330100.0
2010-11-26	GLD	ETF	132.38	133.16	131.93	133.11	7822400.0
2010-11-26	TLT	ETF	96.72	97.12	96.55	97.07	4848900.0
2010-11-26	AADR	ETF	28.63	28.74	28.59	28.74	2900.0
2010-11-26	AAXJ	ETF	61.13	61.24	60.9	60.9	567000.0
2010-11-26	ACWI	ETF	44.39	44.6	44.2	44.45	498300.0
2010-11-26	ACWX	ETF	41.94	42.08	41.83	41.97	26172.0
2010-11-26	ADRE	ETF	45.29	45.5399	45.15	45.32	23725.0
2010-11-26	AFK	ETF	33.1	33.1	32.745	32.86	31978.0
2010-11-26	AGG	ETF	107.23	107.42	107.22	107.37	134200.0
2010-11-26	AGQ	ETF	240.76	245.94	239.0	242.0	433200.0
2010-11-26	AGZ	ETF	110.48	110.83	110.48	110.77	7105.0
2010-11-26	AIA	ETF	44.04	44.04	43.76	43.7828	11585.0
2010-11-26	AIQ	ETF	19.55	19.6	19.3	19.35	16893.0
2010-11-26	AIS	ETF	1.4	1.4	1.39	1.39	26655.0
2010-11-26	AIVI	ETF	42.77	42.82	42.56	42.63	6500.0
2010-11-26	AMJ	ETF	35.82	35.9	35.75	35.81	121198.0
2010-11-26	AMLP	ETF	79.25	79.5	79.25	79.25	28180.0
2010-11-26	AOA	ETF	32.73	32.85	32.73	32.79	3100.0
2010-11-26	AOK	ETF	28.6	28.6	28.55	28.5899	2455.0
2010-11-26	AOM	ETF	29.44	29.5	29.44	29.46	7546.0
2010-11-26	AOR	ETF	30.69	30.6956	30.65	30.68	11350.0
2010-11-26	ARB	ETF	29.04	29.67	28.86	29.59	92515.0
2010-11-26	BAB	ETF	25.55	25.55	25.41	25.51	90566.0
2010-11-26	BAL	ETF	57.28	57.39	56.485	57.05	81657.0
2010-11-26	BALT	ETF	12.27	12.3099	12.15	12.2	50032.0
2010-11-26	BBH	ETF	32.9633	32.9633	32.8333	32.9	10500.0
2010-11-26	BICK	ETF	31.8	31.8	31.34	31.49	16355.0
2010-11-26	BIL	ETF	91.7	91.72	91.7	91.72	223750.0
2010-11-26	BIS	ETF	9092.8	9092.8	9092.8	9092.8	1.405
2010-11-26	BITS	ETF	28.2	28.4	28.2	28.4	100.0
2010-11-26	BIV	ETF	85.38	85.47	85.24	85.47	37300.0
2010-11-26	BJK	ETF	30.88	30.9	30.67	30.67	4400.0
2010-11-26	BKF	ETF	47.33	47.88	47.3	47.61	278329.0
2010-11-26	BLV	ETF	81.06	81.37	80.92	81.34	8300.0
2010-11-26	BMVP	ETF	14.17	14.25	14.17	14.25	673.0
2010-11-26	BND	ETF	81.81	81.82	81.61	81.82	341200.0
2010-11-26	BNO	ETF	28.52	28.52	28.52	28.52	600.0
2010-11-26	BRF	ETF	58.6	59.18	58.56	58.99	184454.0
2010-11-26	BSCE	ETF	20.84	20.84	20.84	20.84	564.0
2010-11-26	BSV	ETF	81.35	81.4	81.32	81.39	98400.0
2010-11-26	BTF	ETF	78.05	78.8	77.75	78.3	840.0
2010-11-26	BWX	ETF	29.0	29.035	28.925	28.965	109828.0
2010-11-26	BWZ	ETF	36.35	36.44	36.35	36.42	11224.0
2010-11-26	BZQ	ETF	2819.2	2827.2	2771.2	2790.4	257.0
2010-11-26	CEF	ETF	18.74	18.95	18.59	18.93	666800.0
2010-11-26	CEW	ETF	22.69	22.72	22.62	22.644	72838.0

> showing 50 of 792 rows — these rows as CSV

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