PREVIEW / etf_daily / 2010-07-02

all etf daily files

  file:    by_date/etf_daily/2010/2010-07-02.parquet
  size:    32 KB
  rows:    754

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-02	SPY	ETF	103.11	103.42	101.62	102.2	233385200.0
2010-07-02	QQQ	ETF	42.67	42.8215	42.09	42.47	78565281.0
2010-07-02	IWM	ETF	60.75	60.89	59.42	59.82	72084200.0
2010-07-02	DIA	ETF	97.53	97.74	96.17	96.87	11305700.0
2010-07-02	GLD	ETF	118.21	118.5	117.41	118.49	14732800.0
2010-07-02	TLT	ETF	101.11	101.44	100.16	100.79	6297600.0
2010-07-02	AAXJ	ETF	52.17	52.59	51.94	52.2	431400.0
2010-07-02	ACWI	ETF	38.07	38.1	37.47	37.68	165100.0
2010-07-02	ACWX	ETF	35.62	35.78	35.23	35.4	115626.0
2010-07-02	ADRE	ETF	39.28	39.65	39.1	39.4299	138554.0
2010-07-02	AFK	ETF	27.98	27.98	27.51	27.61	1635.0
2010-07-02	AGG	ETF	106.69	106.89	106.68	106.73	586100.0
2010-07-02	AGQ	ETF	115.92	115.92	112.2	114.88	149100.0
2010-07-02	AGZ	ETF	110.11	110.13	109.94	109.984	15500.0
2010-07-02	AIA	ETF	36.89	36.97	36.45	36.7	15977.0
2010-07-02	AIQ	ETF	20.1	20.1	19.1	19.1	116049.0
2010-07-02	AIS	ETF	1.72	1.72	1.63	1.67	525385.0
2010-07-02	AIVI	ETF	36.73	36.94	36.06	36.33	37800.0
2010-07-02	AMJ	ETF	30.99	31.078	30.46	30.77	333805.0
2010-07-02	AOA	ETF	28.13	28.13	27.77	27.99	12200.0
2010-07-02	AOK	ETF	27.24	27.24	27.1654	27.19	6482.0
2010-07-02	AOM	ETF	27.4201	27.49	27.35	27.409	7300.0
2010-07-02	AOR	ETF	27.73	27.82	27.55	27.6635	16752.0
2010-07-02	ARB	ETF	25.98	25.98	24.98	25.27	180468.0
2010-07-02	BAB	ETF	26.15	26.15	25.96	25.968	110209.0
2010-07-02	BAL	ETF	36.76	36.78	36.76	36.78	2100.0
2010-07-02	BALT	ETF	10.79	10.87	10.08	10.27	185374.0
2010-07-02	BBH	ETF	28.98	29.4667	28.9333	29.2467	306300.0
2010-07-02	BIB	ETF	5.0963	5.0963	5.0963	5.0963	800.0
2010-07-02	BICK	ETF	26.92	26.99	26.765	26.99	2455.0
2010-07-02	BIL	ETF	91.7	91.72	91.7	91.72	139150.0
2010-07-02	BIS	ETF	13115.2	13115.2	13115.2	13115.2	1.25
2010-07-02	BITS	ETF	26.16	26.6	25.5	26.12	1825.0
2010-07-02	BIV	ETF	83.17	83.47	83.17	83.31	323400.0
2010-07-02	BJK	ETF	22.78	22.79	22.51	22.62	6500.0
2010-07-02	BKF	ETF	41.06	41.36	40.801	41.06	157582.0
2010-07-02	BLV	ETF	81.53	81.95	81.25	81.6	90600.0
2010-07-02	BMVP	ETF	11.6233	11.6255	11.5033	11.59	4870.0
2010-07-02	BND	ETF	81.16	81.23	81.03	81.14	640400.0
2010-07-02	BNE	ETF	11.23	11.23	11.21	11.22	294094.0
2010-07-02	BNO	ETF	24.38	24.38	24.38	24.38	600.0
2010-07-02	BRF	ETF	44.7	44.86	44.1	44.72	183620.0
2010-07-02	BSCE	ETF	20.4	20.42	20.3932	20.42	17640.0
2010-07-02	BSV	ETF	80.74	80.83	80.7	80.83	573000.0
2010-07-02	BTF	ETF	66.55	67.3	65.0	65.7	3112.0
2010-07-02	BWX	ETF	27.295	27.345	27.12	27.25	210780.0
2010-07-02	BWZ	ETF	34.25	34.25	34.02	34.0748	8803.0
2010-07-02	BZQ	ETF	4198.4	4307.2	4140.8	4163.2	752.5
2010-07-02	CEF	ETF	14.74	14.83	14.59	14.62	1536700.0
2010-07-02	CEW	ETF	21.28	21.39	21.28	21.36	70405.0

> showing 50 of 754 rows — these rows as CSV

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