PREVIEW / etf_daily / 2009-04-21

all etf daily files

  file:    by_date/etf_daily/2009/2009-04-21.parquet
  size:    28 KB
  rows:    643

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-04-21	SPY	ETF	82.82	85.13	82.75	85.06	114090900.0
2009-04-21	QQQ	ETF	32.09	32.74	32.08	32.69	145490151.0
2009-04-21	IWM	ETF	45.06	47.06	44.95	46.87	60408100.0
2009-04-21	DIA	ETF	77.83	79.76	77.81	79.59	18051200.0
2009-04-21	GLD	ETF	87.85	87.88	86.33	86.89	10655900.0
2009-04-21	TLT	ETF	104.04	104.21	102.22	102.22	909100.0
2009-04-21	AAXJ	ETF	36.32	37.23	36.3	37.22	52100.0
2009-04-21	ACWI	ETF	29.9	30.68	29.87	30.64	64500.0
2009-04-21	ACWX	ETF	27.97	28.81	27.8901	28.81	33650.0
2009-04-21	ADRE	ETF	29.1	29.702	28.776	29.65	124266.0
2009-04-21	AFK	ETF	20.23	20.71	20.23	20.49	1200.0
2009-04-21	AGG	ETF	101.41	101.42	100.86	100.93	702100.0
2009-04-21	AGQ	ETF	68.04	68.2	64.92	66.18	65350.0
2009-04-21	AGZ	ETF	108.25	108.26	107.1	107.62	27889.0
2009-04-21	AIA	ETF	27.54	28.08	27.54	28.08	22941.0
2009-04-21	AIQ	ETF	41.35	42.05	41.2	41.8	35519.0
2009-04-21	AIS	ETF	0.44	0.44	0.41	0.42	51048.0
2009-04-21	AIVI	ETF	29.31	30.54	29.31	30.47	12500.0
2009-04-21	AMJ	ETF	20.1	20.2	20.1	20.2	108705.0
2009-04-21	AOA	ETF	22.74	23.2	22.74	23.2	2400.0
2009-04-21	AOK	ETF	25.1099	25.16	25.1099	25.16	675.0
2009-04-21	AOM	ETF	24.5	24.65	24.5	24.5361	1007.0
2009-04-21	AOR	ETF	23.8346	23.97	23.37	23.97	2767.0
2009-04-21	ARB	ETF	19.31	20.35	19.13	19.84	556979.0
2009-04-21	BAL	ETF	27.4	29.2	27.34	28.9499	5300.0
2009-04-21	BBH	ETF	28.3967	28.7633	28.2067	28.37	379500.0
2009-04-21	BIL	ETF	91.7	91.72	91.68	91.68	118850.0
2009-04-21	BITS	ETF	17.76	17.76	16.8	17.64	225.0
2009-04-21	BIV	ETF	76.78	77.06	76.46	76.51	67700.0
2009-04-21	BJK	ETF	17.53	17.84	17.37	17.51	4600.0
2009-04-21	BKF	ETF	27.7	28.52	27.41	28.52	158465.0
2009-04-21	BLV	ETF	73.98	74.02	72.8	73.33	17200.0
2009-04-21	BMVP	ETF	10.08	10.4133	10.08	10.3766	22873.0
2009-04-21	BND	ETF	77.28	77.28	76.92	77.07	408000.0
2009-04-21	BNE	ETF	4.62	5.04	4.5	4.63	365901.0
2009-04-21	BOSS	ETF	13.1	13.1	13.1	13.1	100.0
2009-04-21	BSV	ETF	78.86	78.88	78.6	78.72	178100.0
2009-04-21	BTF	ETF	44.5	45.3125	44.3	45.307	3393.2000000000003
2009-04-21	BWX	ETF	25.39	25.445	25.3	25.415	116828.0
2009-04-21	CBON	ETF	2.61	2.61	2.33	2.57	26985.0
2009-04-21	CEF	ETF	10.99	11.03	10.7	10.82	440000.0
2009-04-21	CGO	ETF	9.24	9.77	9.24	9.47	18428.0
2009-04-21	CGW	ETF	12.61	13.1	12.61	13.06	32840.0
2009-04-21	CHB	ETF	0.63	0.64	0.55	0.63	438898.0
2009-04-21	CHI	ETF	8.85	9.31	8.82	9.21	141510.0
2009-04-21	CHIC	ETF	11.21	12.46	11.21	12.35	729753.0
2009-04-21	CHW	ETF	6.88	7.38	5.75	5.9876	287680.0
2009-04-21	CHY	ETF	8.84	9.05	8.75	9.0187	203263.0
2009-04-21	CMF	ETF	52.14	52.24	52.125	52.175	11384.0
2009-04-21	CNXT	ETF	1.45	1.61	1.21	1.2801	1598195.0

> showing 50 of 643 rows — these rows as CSV

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