PREVIEW / etf_daily / 2010-04-28

all etf daily files

  file:    by_date/etf_daily/2010/2010-04-28.parquet
  size:    33 KB
  rows:    750

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-04-28	SPY	ETF	119.05	119.68	118.27	119.38	300674100.0
2010-04-28	QQQ	ETF	49.6	49.63	48.98	49.37	130082077.0
2010-04-28	IWM	ETF	72.57	72.78	71.92	72.28	79762700.0
2010-04-28	DIA	ETF	110.38	110.84	109.69	110.55	14833300.0
2010-04-28	GLD	ETF	114.03	114.99	113.63	114.31	26891900.0
2010-04-28	TLT	ETF	91.13	91.35	90.48	90.7	8379500.0
2010-04-28	AAXJ	ETF	57.44	57.44	56.41	56.94	185600.0
2010-04-28	ACWI	ETF	43.69	43.7	43.08	43.51	682100.0
2010-04-28	ACWX	ETF	41.12	41.12	40.33	40.78	191216.0
2010-04-28	ADRE	ETF	43.75	43.7901	43.02	43.596	120066.0
2010-04-28	AFK	ETF	31.76	31.76	31.27	31.42	28152.0
2010-04-28	AGG	ETF	104.41	104.56	104.3	104.4	929600.0
2010-04-28	AGQ	ETF	121.42	124.84	119.22	123.0	186250.0
2010-04-28	AGZ	ETF	108.228	108.228	108.07	108.185	12631.0
2010-04-28	AIA	ETF	40.92	41.04	40.63	40.95	24428.0
2010-04-28	AIQ	ETF	27.35	27.45	27.0	27.15	8909.0
2010-04-28	AIS	ETF	1.63	1.63	1.52	1.56	450785.0
2010-04-28	AIVI	ETF	41.85	41.9	40.98	41.53	37800.0
2010-04-28	AMJ	ETF	31.57	31.57	31.01	31.17	453865.0
2010-04-28	AOA	ETF	32.05	32.05	31.65	31.95	9900.0
2010-04-28	AOK	ETF	28.09	28.09	27.981	27.986	13154.0
2010-04-28	AOM	ETF	28.95	28.95	28.7	28.9	7396.0
2010-04-28	AOR	ETF	30.12	30.93	29.9201	29.96	14198.0
2010-04-28	ARB	ETF	32.0	32.03	30.94	31.07	240851.0
2010-04-28	BAB	ETF	25.5	25.53	25.4	25.43	84627.0
2010-04-28	BAL	ETF	40.75	40.78	40.02	40.18	9947.0
2010-04-28	BALT	ETF	14.3	14.37	13.89	14.15	538356.0
2010-04-28	BBH	ETF	32.4067	32.73	32.4067	32.6267	102900.0
2010-04-28	BIB	ETF	6.9688	7.0738	6.9688	7.0738	28000.0
2010-04-28	BICK	ETF	29.54	29.95	29.31	29.5	13516.0
2010-04-28	BIL	ETF	91.68	91.7	91.68	91.7	214950.0
2010-04-28	BIS	ETF	10142.4	10163.2	10132.96	10163.2	5.6
2010-04-28	BITS	ETF	31.52	31.76	31.52	31.76	75.0
2010-04-28	BIV	ETF	80.87	80.9	80.55	80.74	107500.0
2010-04-28	BJK	ETF	26.86	26.92	26.41	26.64	19200.0
2010-04-28	BKF	ETF	45.61	45.622	44.874	45.37	250854.0
2010-04-28	BLV	ETF	78.15	78.15	77.75	77.93	33000.0
2010-04-28	BMVP	ETF	13.58	13.62	13.5	13.57	42978.0
2010-04-28	BND	ETF	79.56	79.59	79.42	79.54	733100.0
2010-04-28	BNE	ETF	11.21	11.25	11.17	11.19	457262.0
2010-04-28	BRF	ETF	45.46	45.788	44.815	45.56	320813.0
2010-04-28	BSV	ETF	80.1	80.14	79.96	80.07	404800.0
2010-04-28	BTF	ETF	73.1	74.25	73.1	73.8	4914.0
2010-04-28	BWX	ETF	27.36	27.375	27.1301	27.225	1918634.0
2010-04-28	BWZ	ETF	35.07	35.07	34.76	34.916	25190.0
2010-04-28	BZQ	ETF	3792.0	3977.6	3763.2	3812.8	1186.0
2010-04-28	CEF	ETF	14.5	14.72	14.39	14.65	1403500.0
2010-04-28	CEW	ETF	22.2	22.42	22.12	22.21	150579.0
2010-04-28	CGO	ETF	14.73	14.8264	14.66	14.68	42856.0
2010-04-28	CGW	ETF	18.49	18.49	18.15	18.27	70210.0

> showing 50 of 750 rows — these rows as CSV

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