PREVIEW / etf_daily / 2010-04-07

all etf daily files

  file:    by_date/etf_daily/2010/2010-04-07.parquet
  size:    32 KB
  rows:    744

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-07	SPY	ETF	118.8	119.36	117.81	118.36	184576300.0
2010-04-07	QQQ	ETF	48.69	48.87	48.37	48.63	77211459.0
2010-04-07	IWM	ETF	70.04	70.31	69.45	69.9	71418200.0
2010-04-07	DIA	ETF	109.55	109.7	108.52	109.05	10894000.0
2010-04-07	GLD	ETF	111.85	112.93	111.77	112.49	19139500.0
2010-04-07	TLT	ETF	87.45	88.92	87.3	88.73	6389900.0
2010-04-07	AAXJ	ETF	58.86	58.86	58.18	58.46	947500.0
2010-04-07	ACWI	ETF	44.22	44.42	44.01	44.2	129700.0
2010-04-07	ACWX	ETF	42.43	42.43	42.13	42.26	27487.0
2010-04-07	ADRE	ETF	45.5	45.5	44.808	45.02	98682.0
2010-04-07	AFK	ETF	32.27	32.65	32.05	32.5	26557.0
2010-04-07	AGG	ETF	103.4	103.77	103.4	103.77	746600.0
2010-04-07	AGQ	ETF	123.9	126.04	123.76	124.44	266850.0
2010-04-07	AGZ	ETF	107.56	107.995	107.55	107.88	41602.0
2010-04-07	AIA	ETF	41.9	41.9	41.3601	41.5499	14410.0
2010-04-07	AIQ	ETF	28.15	28.4	27.9	28.35	19392.0
2010-04-07	AIS	ETF	1.65	1.73	1.64	1.67	1434683.0
2010-04-07	AIVI	ETF	43.26	43.26	42.86	42.97	8400.0
2010-04-07	AMJ	ETF	31.27	31.27	31.0	31.15	563185.0
2010-04-07	AOA	ETF	32.08	32.1	31.78	31.97	8900.0
2010-04-07	AOK	ETF	27.8635	27.91	27.86	27.86	3794.0
2010-04-07	AOM	ETF	28.85	28.9399	28.8101	28.8874	2493.0
2010-04-07	AOR	ETF	29.98	30.09	29.91	29.94	11706.0
2010-04-07	ARB	ETF	27.27	27.27	26.22	26.43	480822.0
2010-04-07	BAB	ETF	24.71	24.92	24.6	24.9	259075.0
2010-04-07	BAL	ETF	39.19	39.1901	38.85	38.855	3982.0
2010-04-07	BALT	ETF	13.89	14.0	13.76	13.95	358359.0
2010-04-07	BBH	ETF	34.4967	34.6867	34.46	34.5467	40800.0
2010-04-07	BIL	ETF	91.72	91.72	91.68	91.68	725100.0
2010-04-07	BITS	ETF	31.84	32.0	31.6	32.0	1290.0
2010-04-07	BIV	ETF	79.44	79.92	79.41	79.84	125700.0
2010-04-07	BJK	ETF	26.8	26.8	26.29	26.5	16800.0
2010-04-07	BKF	ETF	47.83	48.18	47.471	47.72	254455.0
2010-04-07	BLV	ETF	75.66	76.52	75.56	76.46	73000.0
2010-04-07	BMVP	ETF	13.4133	13.4367	13.32	13.3566	8410.0
2010-04-07	BND	ETF	78.6	78.88	78.6	78.83	526900.0
2010-04-07	BNE	ETF	11.13	11.18	11.13	11.15	717181.0
2010-04-07	BRF	ETF	45.95	46.182	45.35	45.73	537418.0
2010-04-07	BSV	ETF	79.55	79.71	79.54	79.64	843100.0
2010-04-07	BTF	ETF	74.05	74.89999999999999	74.05	74.35	5799.200000000001
2010-04-07	BWX	ETF	27.785	27.81	27.685	27.77	252514.0
2010-04-07	BWZ	ETF	35.38	35.48	35.38	35.43	9146.0
2010-04-07	BZQ	ETF	3406.4	3528.0	3395.2	3486.4	252.5
2010-04-07	CEF	ETF	14.43	14.61	14.34	14.35	1718200.0
2010-04-07	CEW	ETF	22.36	22.43	22.33	22.37	161485.0
2010-04-07	CGO	ETF	14.99	15.147	14.86	15.07	31728.0
2010-04-07	CGW	ETF	18.8	18.8099	18.63	18.73	48684.0
2010-04-07	CHI	ETF	12.87	12.89	12.74	12.76	384063.0
2010-04-07	CHIE	ETF	15.15	15.292	15.09	15.17	4310.0
2010-04-07	CHII	ETF	15.9	15.9	15.65	15.72	14193.0

> showing 50 of 744 rows — these rows as CSV

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