PREVIEW / etf_daily / 2009-05-01

all etf daily files

  file:    by_date/etf_daily/2009/2009-05-01.parquet
  size:    28 KB
  rows:    644

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
2009-05-01	SPY	ETF	87.44	88.21	86.72	87.89	236110300.0
2009-05-01	QQQ	ETF	34.28	34.54	34.01	34.37	100111971.0
2009-05-01	IWM	ETF	48.65	49.3	48.41	48.82	64532300.0
2009-05-01	DIA	ETF	81.79	82.19	80.96	82.16	12356400.0
2009-05-01	GLD	ETF	86.75	87.49	86.69	86.95	6122400.0
2009-05-01	TLT	ETF	97.12	97.29	96.57	97.11	2772200.0
2009-05-01	AAXJ	ETF	35.88	39.36	35.88	39.15	86700.0
2009-05-01	ACWI	ETF	31.93	32.34	31.8	32.13	52200.0
2009-05-01	ACWX	ETF	30.43	30.667	30.31	30.53	35008.0
2009-05-01	ADRE	ETF	31.32	31.78	30.98	31.68	223521.0
2009-05-01	AFK	ETF	22.3	22.46	22.12	22.46	1400.0
2009-05-01	AGG	ETF	101.08	101.16	100.75	100.92	536100.0
2009-05-01	AGQ	ETF	68.96	72.36	68.54	70.62	64000.0
2009-05-01	AGZ	ETF	107.92	107.92	107.5	107.82	5758.0
2009-05-01	AIA	ETF	29.46	29.97	29.46	29.89	48218.0
2009-05-01	AIQ	ETF	39.25	40.95	38.65	40.55	77534.0
2009-05-01	AIS	ETF	0.43	0.44	0.4199	0.43	61415.0
2009-05-01	AIVI	ETF	32.22	32.5	32.19	32.31	2700.0
2009-05-01	AMJ	ETF	21.2399	21.55	21.22	21.52	13567.0
2009-05-01	AOA	ETF	24.18	24.18	23.84	24.05	7000.0
2009-05-01	AOK	ETF	25.314	25.99	25.31	25.31	3609.0
2009-05-01	AOM	ETF	24.93	25.49	24.75	25.3	19676.0
2009-05-01	AOR	ETF	24.76	24.76	24.24	24.56	14539.0
2009-05-01	ARB	ETF	20.82	21.41	20.8	20.88	371232.0
2009-05-01	BAL	ETF	30.9	32.0	30.9	32.0	8580.0
2009-05-01	BBH	ETF	29.7367	29.7367	28.99	29.13	761400.0
2009-05-01	BIL	ETF	91.72	91.78	91.7	91.78	62300.0
2009-05-01	BITS	ETF	17.76	17.76	17.32	17.68	7025.0
2009-05-01	BIV	ETF	76.01	76.66	75.81	76.02	146100.0
2009-05-01	BJK	ETF	20.57	20.6	20.01	20.4	10200.0
2009-05-01	BKF	ETF	29.57	30.01	29.0	29.84	62720.0
2009-05-01	BLV	ETF	72.01	72.17	71.56	71.76	9600.0
2009-05-01	BMVP	ETF	10.4467	10.5516	10.3885	10.55	16173.0
2009-05-01	BND	ETF	76.78	76.86	76.66	76.83	413600.0
2009-05-01	BNE	ETF	5.14	5.56	5.0	5.39	152969.0
2009-05-01	BSV	ETF	78.76	78.82	78.5	78.82	186300.0
2009-05-01	BTF	ETF	46.39999999999999	47.24999999999999	46.3	46.9	10209.6
2009-05-01	BWX	ETF	25.815	25.95	25.815	25.95	109050.0
2009-05-01	BWZ	ETF	33.25	33.45	33.2117	33.2117	12911.0
2009-05-01	CBON	ETF	2.31	2.31	2.21	2.22	9311.0
2009-05-01	CEF	ETF	11.07	11.38	11.05	11.24	649100.0
2009-05-01	CGO	ETF	9.68	9.91	9.68	9.85	23893.0
2009-05-01	CGW	ETF	13.79	14.08	13.78	13.98	28318.0
2009-05-01	CHB	ETF	0.58	0.61	0.56	0.59	676593.0
2009-05-01	CHI	ETF	9.1	9.56	9.1	9.52	214801.0
2009-05-01	CHIC	ETF	12.68	12.89	12.23	12.56	200885.0
2009-05-01	CHW	ETF	6.46	6.65	6.32	6.56	212850.0
2009-05-01	CHY	ETF	9.0	9.29	8.95	9.29	150637.0
2009-05-01	CMF	ETF	52.375	52.425	52.3676	52.395	8858.0
2009-05-01	CNXT	ETF	1.35	1.48	1.3	1.48	766565.0

> showing 50 of 644 rows — these rows as CSV

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