PREVIEW / etf_daily / 2010-07-26

all etf daily files

  file:    by_date/etf_daily/2010/2010-07-26.parquet
  size:    33 KB
  rows:    765

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-07-26	SPY	ETF	110.6	111.67	110.29	111.56	184445700.0
2010-07-26	QQQ	ETF	46.12	46.46	45.91	46.44	64850819.0
2010-07-26	IWM	ETF	65.26	66.52	64.92	66.46	66248300.0
2010-07-26	DIA	ETF	104.41	105.33	104.21	105.26	9047000.0
2010-07-26	GLD	ETF	116.38	116.47	115.3	115.52	11219000.0
2010-07-26	TLT	ETF	99.63	99.81	99.0	99.61	4856400.0
2010-07-26	AADR	ETF	25.4	25.4	25.22	25.37	18900.0
2010-07-26	AAXJ	ETF	55.84	56.46	55.72	56.42	688700.0
2010-07-26	ACWI	ETF	40.88	41.25	40.71	41.17	394100.0
2010-07-26	ACWX	ETF	38.55	38.95	38.44	38.92	50164.0
2010-07-26	ADRE	ETF	42.23	42.65	42.14	42.65	131279.0
2010-07-26	AFK	ETF	30.37	30.57	30.22	30.57	50863.0
2010-07-26	AGG	ETF	107.47	107.47	107.24	107.41	836300.0
2010-07-26	AGQ	ETF	118.72	118.94	116.72	118.28	61100.0
2010-07-26	AGZ	ETF	110.47	110.47	110.36	110.46	7879.0
2010-07-26	AIA	ETF	39.6	39.89	39.5	39.89	13983.0
2010-07-26	AIQ	ETF	19.35	20.1	19.25	19.9	57259.0
2010-07-26	AIS	ETF	1.53	1.6	1.52	1.59	342966.0
2010-07-26	AIVI	ETF	39.94	40.49	39.94	40.48	14800.0
2010-07-26	AMJ	ETF	33.38	33.49	33.27	33.35	1803555.0
2010-07-26	AOA	ETF	30.11	30.4	30.02	30.4	3000.0
2010-07-26	AOK	ETF	27.8	27.9	27.79	27.9	28097.0
2010-07-26	AOM	ETF	28.29	28.4415	28.29	28.4401	6659.0
2010-07-26	AOR	ETF	29.01	29.19	29.01	29.19	8105.0
2010-07-26	ARB	ETF	30.44	31.03	30.17	30.92	239771.0
2010-07-26	BAB	ETF	25.9	25.99	25.81	25.92	294009.0
2010-07-26	BAL	ETF	37.06	37.51	36.95	37.51	9401.0
2010-07-26	BALT	ETF	11.41	11.47	11.32	11.43	141402.0
2010-07-26	BBH	ETF	30.3233	31.1	30.16	31.08	425100.0
2010-07-26	BIB	ETF	5.725	5.8063	5.725	5.8063	3600.0
2010-07-26	BICK	ETF	28.725	29.14	28.725	29.1	29142.0
2010-07-26	BIL	ETF	91.72	91.72	91.68	91.68	881800.0
2010-07-26	BIS	ETF	11510.4	11510.4	11238.4	11238.4	5.65
2010-07-26	BITS	ETF	26.48	26.6	26.0	26.4	500.0
2010-07-26	BIV	ETF	83.98	84.08	83.72	83.99	134600.0
2010-07-26	BJK	ETF	24.73	25.23	24.73	25.05	13700.0
2010-07-26	BKF	ETF	44.42	44.71	44.28	44.7	88285.0
2010-07-26	BLV	ETF	82.2	82.23	81.66	82.1	56900.0
2010-07-26	BMVP	ETF	12.55	12.63	12.55	12.63	5059.0
2010-07-26	BND	ETF	81.52	81.56	81.4	81.54	570400.0
2010-07-26	BNE	ETF	11.36	11.36	11.33	11.35	518687.0
2010-07-26	BNO	ETF	26.095	26.255	26.095	26.21	43000.0
2010-07-26	BOSS	ETF	28.59	29.65	28.59	29.65	100.0
2010-07-26	BRF	ETF	48.7	48.76	48.25	48.34	317345.0
2010-07-26	BSCE	ETF	20.65	20.75	20.63	20.65	22286.0
2010-07-26	BSV	ETF	81.12	81.16	81.06	81.15	656000.0
2010-07-26	BTF	ETF	69.6	70.85	69.6	70.75	1027.6000000000001
2010-07-26	BWX	ETF	28.05	28.15	27.825	28.145	128496.0
2010-07-26	BWZ	ETF	34.96	35.18	34.88	35.18	8266.0
2010-07-26	BZQ	ETF	3481.6	3526.4	3456.0	3468.8	846.0

> showing 50 of 765 rows — these rows as CSV

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