PREVIEW / etf_daily / 2010-03-01

all etf daily files

  file:    by_date/etf_daily/2010/2010-03-01.parquet
  size:    31 KB
  rows:    723

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-01	SPY	ETF	111.2	112.0	111.17	111.89	147709700.0
2010-03-01	QQQ	ETF	44.95	45.49	44.95	45.41	77290019.0
2010-03-01	IWM	ETF	63.26	64.32	63.26	64.26	70967800.0
2010-03-01	DIA	ETF	103.67	104.2	103.58	104.02	5818700.0
2010-03-01	GLD	ETF	109.48	109.9	108.97	109.43	12830900.0
2010-03-01	TLT	ETF	91.33	91.53	90.96	91.34	2415200.0
2010-03-01	AAXJ	ETF	53.29	53.73	53.29	53.54	136100.0
2010-03-01	ACWI	ETF	41.17	41.49	41.09	41.49	2895200.0
2010-03-01	ACWX	ETF	39.16	39.5181	39.1	39.48	101048.0
2010-03-01	ADRE	ETF	41.59	41.81	41.436	41.75	77910.0
2010-03-01	AFK	ETF	28.98	29.22	28.85	29.22	27800.0
2010-03-01	AGG	ETF	104.35	104.48	104.25	104.36	618000.0
2010-03-01	AGQ	ETF	104.88	105.86	103.34	103.34	390500.0
2010-03-01	AGZ	ETF	108.73	108.74	108.4	108.71	10414.0
2010-03-01	AIA	ETF	38.32	38.52	38.3	38.36	33186.0
2010-03-01	AIQ	ETF	25.0	25.11	24.45	24.65	32175.0
2010-03-01	AIS	ETF	1.35	1.35	1.29	1.35	469678.0
2010-03-01	AIVI	ETF	40.17	40.54	40.17	40.42	13900.0
2010-03-01	AMJ	ETF	29.65	29.74	29.57	29.72	230863.0
2010-03-01	AOA	ETF	29.86	30.07	29.86	30.06	13500.0
2010-03-01	AOK	ETF	27.46	27.49	27.42	27.445	8501.0
2010-03-01	AOM	ETF	28.1	28.16	28.1	28.16	3522.0
2010-03-01	AOR	ETF	28.79	28.91	28.69	28.85	13698.0
2010-03-01	ARB	ETF	21.7	22.12	21.65	21.83	527196.0
2010-03-01	BAB	ETF	25.05	25.05	24.96	24.97	121615.0
2010-03-01	BAL	ETF	40.26	40.525	40.06	40.0601	16192.0
2010-03-01	BBH	ETF	34.2967	34.4133	34.2067	34.3533	98100.0
2010-03-01	BIL	ETF	91.72	91.72	91.68	91.68	265300.0
2010-03-01	BITS	ETF	31.72	34.28	31.28	33.976	5531.0
2010-03-01	BIV	ETF	80.6	80.6	80.41	80.51	113100.0
2010-03-01	BJK	ETF	23.29	23.81	23.29	23.63	6600.0
2010-03-01	BKF	ETF	43.51	44.0	43.32	44.0	407002.0
2010-03-01	BLV	ETF	77.25	77.31	76.9	77.11	28000.0
2010-03-01	BMVP	ETF	12.6067	12.75	12.6063	12.75	39698.0
2010-03-01	BND	ETF	79.53	79.53	79.36	79.46	565000.0
2010-03-01	BNE	ETF	11.15	11.22	11.14	11.2	2169357.0
2010-03-01	BRF	ETF	45.76	46.38	45.7	46.35	302505.0
2010-03-01	BSV	ETF	80.3	80.33	80.21	80.29	401600.0
2010-03-01	BTF	ETF	68.05	69.25	68.05	69.25	9176.6
2010-03-01	BWX	ETF	27.78	28.045	27.625	27.81	4125852.0
2010-03-01	BWZ	ETF	35.98	35.98	35.56	35.63	66262.0
2010-03-01	BZQ	ETF	4115.2	4144.0	4032.0	4048.0	648.0
2010-03-01	CEF	ETF	13.69	13.8	13.6	13.63	695400.0
2010-03-01	CEW	ETF	21.82	21.85	21.76	21.84	66246.0
2010-03-01	CGO	ETF	14.25	14.59	14.08	14.3	33764.0
2010-03-01	CGW	ETF	17.88	17.88	17.59	17.67	64864.0
2010-03-01	CHI	ETF	12.38	12.47	12.35	12.45	133753.0
2010-03-01	CHIE	ETF	14.05	14.09	14.0001	14.09	1570.0
2010-03-01	CHII	ETF	14.82	14.864	14.8	14.816	2085.0
2010-03-01	CHIM	ETF	26.12	26.152	26.08	26.152	2607.0

> showing 50 of 723 rows — these rows as CSV

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