PREVIEW / etf_daily / 2010-03-12

all etf daily files

  file:    by_date/etf_daily/2010/2010-03-12.parquet
  size:    32 KB
  rows:    733

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-03-12	SPY	ETF	115.95	115.97	115.14	115.46	162074800.0
2010-03-12	QQQ	ETF	47.5	47.53	47.1	47.36	64068257.0
2010-03-12	IWM	ETF	68.1	68.13	67.26	67.72	61862000.0
2010-03-12	DIA	ETF	106.64	106.68	106.13	106.42	10139600.0
2010-03-12	GLD	ETF	108.56	108.77	107.45	107.95	11849000.0
2010-03-12	TLT	ETF	89.77	90.65	89.73	90.48	3099100.0
2010-03-12	AAXJ	ETF	55.71	55.89	55.55	55.73	106000.0
2010-03-12	ACWI	ETF	43.25	43.25	42.85	43.05	147700.0
2010-03-12	ACWX	ETF	41.29	41.42	41.1001	41.26	42142.0
2010-03-12	ADRE	ETF	44.0	44.1	43.6151	43.68	128183.0
2010-03-12	AFK	ETF	30.56	30.79	30.56	30.75	6303.0
2010-03-12	AGG	ETF	104.49	104.63	104.4	104.52	854200.0
2010-03-12	AGQ	ETF	112.5	113.26	109.62	111.34	204900.0
2010-03-12	AGZ	ETF	108.09	108.38	108.09	108.35	22476.0
2010-03-12	AIA	ETF	40.07	40.1685	39.78	39.85	22763.0
2010-03-12	AIQ	ETF	26.85	27.725	26.05	27.45	65685.0
2010-03-12	AIS	ETF	1.45	1.48	1.4	1.48	479906.0
2010-03-12	AIVI	ETF	42.67	42.67	42.5	42.56	40200.0
2010-03-12	AMJ	ETF	30.64	30.64	30.41	30.54	448775.0
2010-03-12	AOA	ETF	31.36	31.36	31.11	31.2	11600.0
2010-03-12	AOK	ETF	27.81	27.81	27.7125	27.73	9770.0
2010-03-12	AOM	ETF	28.66	28.66	28.6152	28.66	5340.0
2010-03-12	AOR	ETF	29.73	29.73	29.53	29.63	18090.0
2010-03-12	ARB	ETF	23.9	24.51	23.73	23.96	231301.0
2010-03-12	BAB	ETF	24.9	25.04	24.82	25.03	162535.0
2010-03-12	BAL	ETF	38.3	38.97	38.3	38.97	1331.0
2010-03-12	BALT	ETF	14.13	14.25	13.95	14.18	996604.0
2010-03-12	BBH	ETF	34.87	34.87	34.5667	34.7367	91500.0
2010-03-12	BIL	ETF	91.7	91.7	91.68	91.68	106100.0
2010-03-12	BITS	ETF	32.8	33.52	31.8	32.36	1166.0
2010-03-12	BIV	ETF	80.22	80.6	80.22	80.56	98300.0
2010-03-12	BJK	ETF	24.72	24.77	24.62	24.69	10800.0
2010-03-12	BKF	ETF	45.96	46.2	45.7	45.935	217789.0
2010-03-12	BLV	ETF	76.58	77.23	76.58	77.07	32700.0
2010-03-12	BMVP	ETF	13.083	13.083	13.007	13.04	14692.0
2010-03-12	BND	ETF	79.24	79.43	79.21	79.35	554900.0
2010-03-12	BNE	ETF	11.29	11.3	11.25	11.25	653891.0
2010-03-12	BRF	ETF	48.13	48.13	47.25	47.42	213370.0
2010-03-12	BSV	ETF	80.06	80.11	80.01	80.11	567000.0
2010-03-12	BTF	ETF	73.3	73.94999999999999	73.3	73.6	7486.200000000001
2010-03-12	BWX	ETF	28.145	28.2538	28.067	28.235	178796.0
2010-03-12	BWZ	ETF	35.98	36.0599	35.8315	35.95	23196.0
2010-03-12	BZQ	ETF	3550.4	3646.4	3529.6	3646.4	189.5
2010-03-12	CEF	ETF	13.98	14.04	13.87	13.93	1243000.0
2010-03-12	CEW	ETF	22.15	22.22	22.15	22.2	126636.0
2010-03-12	CGO	ETF	14.14	14.36	14.14	14.3299	24428.0
2010-03-12	CGW	ETF	18.24	18.25	18.05	18.14	48055.0
2010-03-12	CHI	ETF	12.64	12.69	12.57	12.59	103372.0
2010-03-12	CHIE	ETF	14.51	14.51	14.4608	14.4608	1700.0
2010-03-12	CHII	ETF	15.41	15.44	15.246	15.281	9770.0

> showing 50 of 733 rows — these rows as CSV

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