PREVIEW / etf_daily / 2009-09-22

all etf daily files

  file:    by_date/etf_daily/2009/2009-09-22.parquet
  size:    30 KB
  rows:    671

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-09-22	SPY	ETF	107.08	107.37	106.6	107.07	143126700.0
2009-09-22	QQQ	ETF	42.82	42.83	42.4398	42.65	75638373.0
2009-09-22	IWM	ETF	62.03	62.24	61.59	62.02	36266400.0
2009-09-22	DIA	ETF	98.31	98.42	97.69	98.21	8206300.0
2009-09-22	GLD	ETF	99.84	99.84	99.37	99.67	10879500.0
2009-09-22	TLT	ETF	95.65	96.37	95.51	96.18	2068000.0
2009-09-22	AAXJ	ETF	53.26	53.26	52.68	53.21	472300.0
2009-09-22	ACWI	ETF	41.39	41.48	41.17	41.38	127600.0
2009-09-22	ACWX	ETF	40.5	40.5	40.2	40.43	48153.0
2009-09-22	ADRE	ETF	41.14	41.41	41.0	41.28	440488.0
2009-09-22	AFK	ETF	29.13	29.47	29.0001	29.03	7300.0
2009-09-22	AGG	ETF	104.03	104.32	104.03	104.09	567000.0
2009-09-22	AGQ	ETF	123.2	123.38	120.88	122.32	175300.0
2009-09-22	AGZ	ETF	108.592	108.592	108.11	108.11	16152.0
2009-09-22	AIA	ETF	38.86	39.17	38.74	39.17	26932.0
2009-09-22	AIQ	ETF	28.15	28.15	27.25	27.3	47745.0
2009-09-22	AIS	ETF	1.15	1.17	1.1317	1.16	468307.0
2009-09-22	AIVI	ETF	43.4	43.47	43.25	43.36	12500.0
2009-09-22	AMJ	ETF	25.08	25.1	24.9	25.03	196916.0
2009-09-22	AOA	ETF	29.45	29.54	29.44	29.47	35300.0
2009-09-22	AOK	ETF	27.14	27.23	27.14	27.2139	3759.0
2009-09-22	AOM	ETF	28.19	28.19	27.43	28.04	14875.0
2009-09-22	AOR	ETF	28.67	28.7199	28.6591	28.7061	3719.0
2009-09-22	ARB	ETF	19.39	20.15	19.12	19.87	358762.0
2009-09-22	BAL	ETF	33.17	33.32	33.08	33.28	4651.0
2009-09-22	BBH	ETF	34.6033	34.6033	34.01	34.0733	209700.0
2009-09-22	BIL	ETF	91.74	91.74	91.7	91.7	187200.0
2009-09-22	BITS	ETF	20.84	21.76	20.84	21.64	1396.0
2009-09-22	BIV	ETF	79.59	79.85	79.5	79.81	149800.0
2009-09-22	BJK	ETF	26.17	26.57	26.17	26.32	13400.0
2009-09-22	BKF	ETF	41.85	42.343	41.62	42.14	138968.0
2009-09-22	BLV	ETF	78.56	78.94	78.22	78.87	15000.0
2009-09-22	BMVP	ETF	12.1233	12.1233	12.0629	12.0906	13771.0
2009-09-22	BND	ETF	79.04	79.09	78.91	78.94	641400.0
2009-09-22	BNE	ETF	7.06	7.15	6.99	6.99	223003.0
2009-09-22	BOSS	ETF	20.3	20.3	20.3	20.3	100.0
2009-09-22	BRF	ETF	39.77	40.1	39.38	39.94	196659.0
2009-09-22	BSV	ETF	79.72	79.86	79.7	79.74	439400.0
2009-09-22	BTF	ETF	60.25	61.199999999999996	60.14999999999999	60.502	4153.8
2009-09-22	BWX	ETF	29.06	29.24	29.035	29.215	375492.0
2009-09-22	BWZ	ETF	37.04	37.3377	37.04	37.28	27323.0
2009-09-22	BZQ	ETF	5596.8	5611.2	5368.0	5500.8	38.25
2009-09-22	CEF	ETF	13.1	13.31	13.1	13.31	578200.0
2009-09-22	CEW	ETF	21.65	21.82	21.54	21.8	76827.0
2009-09-22	CGO	ETF	13.97	14.11	13.81	13.84	48225.0
2009-09-22	CGW	ETF	18.11	18.15	17.95	18.03	106404.0
2009-09-22	CHB	ETF	0.55	0.65	0.54	0.57	9692743.0
2009-09-22	CHI	ETF	11.77	11.77	11.5	11.67	229848.0
2009-09-22	CHIC	ETF	17.49	17.49	17.46	17.47	215392.0
2009-09-22	CHW	ETF	7.99	7.99	7.73	7.8	244919.0

> showing 50 of 671 rows — these rows as CSV

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