PREVIEW / etf_daily / 2010-03-19

all etf daily files

  file:    by_date/etf_daily/2010/2010-03-19.parquet
  size:    32 KB
  rows:    732

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-19	SPY	ETF	115.97	117.29	115.52	115.97	226641100.0
2010-03-19	QQQ	ETF	47.95	47.95	47.32	47.49	86337043.0
2010-03-19	IWM	ETF	67.41	68.51	67.16	67.41	80546500.0
2010-03-19	DIA	ETF	107.34	108.17	106.92	107.34	12068000.0
2010-03-19	GLD	ETF	108.28	110.29	107.85	108.28	24329100.0
2010-03-19	TLT	ETF	91.26	91.58	90.87	91.26	2976300.0
2010-03-19	AAXJ	ETF	55.75	56.47	55.75	55.75	112500.0
2010-03-19	ACWI	ETF	43.05	43.65	42.96	43.05	349000.0
2010-03-19	ACWX	ETF	41.59	41.59	41.01	41.19	36150.0
2010-03-19	ADRE	ETF	43.67	43.7	42.95	43.03	71689.0
2010-03-19	AFK	ETF	30.8501	30.8501	30.3	30.7499	3775.0
2010-03-19	AGG	ETF	104.75	104.85	104.7	104.75	388600.0
2010-03-19	AGQ	ETF	109.52	114.88	109.4	109.52	426500.0
2010-03-19	AGZ	ETF	108.39	108.49	108.23	108.325	32475.0
2010-03-19	AIA	ETF	40.47	40.47	39.77	39.88	46925.0
2010-03-19	AIQ	ETF	28.85	29.3	28.15	29.25	74428.0
2010-03-19	AIS	ETF	1.47	1.48	1.41	1.47	332466.0
2010-03-19	AIVI	ETF	42.04	42.5	41.98	42.04	9900.0
2010-03-19	AMJ	ETF	30.5	30.5	29.8899	29.98	578248.0
2010-03-19	AOA	ETF	31.25	31.49	31.2	31.25	8900.0
2010-03-19	AOK	ETF	27.85	27.85	27.8465	27.8465	2510.0
2010-03-19	AOM	ETF	28.83	28.83	28.65	28.71	11536.0
2010-03-19	AOR	ETF	29.8	29.8	29.6	29.66	9012.0
2010-03-19	ARB	ETF	25.33	25.34	24.92	25.26	315761.0
2010-03-19	BAB	ETF	25.04	25.1	25.0	25.03	112372.0
2010-03-19	BAL	ETF	39.74	39.75	39.6199	39.6199	4297.0
2010-03-19	BALT	ETF	13.57	13.83	13.05	13.65	1055704.0
2010-03-19	BBH	ETF	35.5733	35.5733	34.82	35.5733	230700.0
2010-03-19	BIL	ETF	91.68	91.7	91.68	91.68	107100.0
2010-03-19	BITS	ETF	32.4	33.4	31.84	33.4	1918.0
2010-03-19	BIV	ETF	80.74	80.92	80.68	80.74	110200.0
2010-03-19	BJK	ETF	24.75	25.0	24.66	24.75	9800.0
2010-03-19	BKF	ETF	46.2	46.37	45.28	45.44	207609.0
2010-03-19	BLV	ETF	77.86	78.05	77.58	77.86	23200.0
2010-03-19	BMVP	ETF	13.26	13.26	13.1	13.14	16959.0
2010-03-19	BND	ETF	79.54	79.61	79.47	79.54	341300.0
2010-03-19	BNE	ETF	11.29	11.3	11.22	11.23	746605.0
2010-03-19	BRF	ETF	46.25	46.46	45.36	45.37	285926.0
2010-03-19	BSV	ETF	80.08	80.15	80.05	80.08	516600.0
2010-03-19	BTF	ETF	73.7	73.7	73.0	73.2	2461.8
2010-03-19	BWX	ETF	28.295	28.295	28.1468	28.245	107892.0
2010-03-19	BWZ	ETF	35.89	35.89	35.648	35.65	36375.0
2010-03-19	BZQ	ETF	3833.6	3848.0	3673.6	3833.6	563.0
2010-03-19	CEF	ETF	13.9	14.2	13.87	13.9	732700.0
2010-03-19	CEW	ETF	22.13	22.13	22.024	22.07	94963.0
2010-03-19	CGO	ETF	14.55	14.72	14.36	14.71	37384.0
2010-03-19	CGW	ETF	18.32	18.34	18.098	18.2	55525.0
2010-03-19	CHI	ETF	12.65	12.66	12.35	12.459	196289.0
2010-03-19	CHIE	ETF	14.25	14.25	14.25	14.25	100.0
2010-03-19	CHII	ETF	15.3201	15.33	15.18	15.222	3155.0

> showing 50 of 732 rows — these rows as CSV

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