PREVIEW / etf_daily / 2010-02-03

all etf daily files

  file:    by_date/etf_daily/2010/2010-02-03.parquet
  size:    31 KB
  rows:    716

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-02-03	SPY	ETF	109.88	110.48	109.51	109.83	172730700.0
2010-02-03	QQQ	ETF	43.45	43.97	43.42	43.89	93581594.0
2010-02-03	IWM	ETF	61.2	61.63	60.59	61.08	50241000.0
2010-02-03	DIA	ETF	102.62	103.06	102.34	102.63	6561600.0
2010-02-03	GLD	ETF	109.1	109.54	108.43	108.7	13393200.0
2010-02-03	TLT	ETF	90.81	90.97	90.27	90.35	5343700.0
2010-02-03	AAXJ	ETF	53.77	53.81	53.12	53.55	180500.0
2010-02-03	ACWI	ETF	41.28	41.4	41.0	41.1	34300.0
2010-02-03	ACWX	ETF	39.81	39.83	39.41	39.64	64247.0
2010-02-03	ADRE	ETF	41.15	41.46	40.91	41.11	174487.0
2010-02-03	AFK	ETF	29.31	29.31	29.112	29.2	21733.0
2010-02-03	AGG	ETF	104.14	104.25	103.89	104.11	2040600.0
2010-02-03	AGQ	ETF	106.62	107.74	103.14	104.48	284350.0
2010-02-03	AGZ	ETF	108.19	108.31	108.06	108.155	82667.0
2010-02-03	AIA	ETF	38.32	38.5696	38.12	38.34	34625.0
2010-02-03	AIQ	ETF	25.95	25.95	24.85	25.15	19145.0
2010-02-03	AIS	ETF	1.18	1.19	1.16	1.19	101560.0
2010-02-03	AIVI	ETF	42.02	42.09	41.64	41.83	26800.0
2010-02-03	AMJ	ETF	29.3	29.46	29.13	29.3	304985.0
2010-02-03	AOA	ETF	29.86	29.86	29.5	29.53	14900.0
2010-02-03	AOK	ETF	27.3	27.41	27.3	27.31	32091.0
2010-02-03	AOM	ETF	28.06	28.09	27.9401	28.0145	17529.0
2010-02-03	AOR	ETF	28.7	28.719	28.53	28.64	4562.0
2010-02-03	ARB	ETF	25.1	25.53	24.9	25.03	185836.0
2010-02-03	BAB	ETF	24.83	24.865	24.75	24.75	120970.0
2010-02-03	BAL	ETF	34.05	34.13	33.95	34.02	12203.0
2010-02-03	BBH	ETF	34.5467	34.5467	34.1667	34.32	48600.0
2010-02-03	BIL	ETF	91.74	91.76	91.72	91.74	739400.0
2010-02-03	BITS	ETF	32.28	32.84	32.24	32.64	385.0
2010-02-03	BIV	ETF	80.22	80.28	79.9	80.1	172700.0
2010-02-03	BJK	ETF	24.53	24.53	24.01	24.13	34400.0
2010-02-03	BKF	ETF	43.47	43.65	43.07	43.3	232107.0
2010-02-03	BLV	ETF	76.84	77.02	76.51	76.67	28400.0
2010-02-03	BMVP	ETF	12.4833	12.55	12.4733	12.5025	23560.0
2010-02-03	BND	ETF	79.24	79.32	79.17	79.3	444700.0
2010-02-03	BNE	ETF	6.19	6.33	5.98	6.27	582281.0
2010-02-03	BRF	ETF	45.14	45.46	44.8	44.81	517909.0
2010-02-03	BSV	ETF	80.15	80.15	80.01	80.05	1317300.0
2010-02-03	BTF	ETF	67.19999999999999	67.19999999999999	66.69999999999999	66.69999999999999	6574.0
2010-02-03	BWX	ETF	28.09	28.23	27.95	28.0	466682.0
2010-02-03	BWZ	ETF	35.85	36.2899	35.73	35.77	29311.0
2010-02-03	BZQ	ETF	4316.8	4398.4	4275.2	4388.8	267.0
2010-02-03	CEF	ETF	13.25	13.3	13.04	13.05	854100.0
2010-02-03	CEW	ETF	21.92	21.92	21.806	21.82	121798.0
2010-02-03	CGO	ETF	14.02	14.12	13.95	14.05	12262.0
2010-02-03	CGW	ETF	18.01	18.01	17.78	17.93	76950.0
2010-02-03	CHI	ETF	12.39	12.48	12.32	12.43	170829.0
2010-02-03	CHIE	ETF	14.22	14.28	14.13	14.1599	5390.0
2010-02-03	CHII	ETF	14.83	14.89	14.704	14.76	13358.0
2010-02-03	CHIM	ETF	25.22	25.22	25.22	25.22	50.0

> showing 50 of 716 rows — these rows as CSV

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