PREVIEW / etf_daily / 2009-07-21

all etf daily files

  file:    by_date/etf_daily/2009/2009-07-21.parquet
  size:    29 KB
  rows:    667

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-07-21	SPY	ETF	95.87	95.9	94.42	95.57	217718300.0
2009-07-21	QQQ	ETF	38.07	38.18	37.64	38.18	130587601.0
2009-07-21	IWM	ETF	53.04	53.07	51.79	52.45	40423000.0
2009-07-21	DIA	ETF	89.13	89.27	88.1	89.17	14599300.0
2009-07-21	GLD	ETF	93.52	93.53	92.69	93.13	9343800.0
2009-07-21	TLT	ETF	91.45	93.7	91.29	93.55	3895300.0
2009-07-21	AAXJ	ETF	48.02	48.02	47.23	47.91	623000.0
2009-07-21	ACWI	ETF	36.41	36.5	35.85	36.29	231300.0
2009-07-21	ACWX	ETF	35.45	35.45	34.824	35.14	28354.0
2009-07-21	ADRE	ETF	37.29	37.29	36.4	36.95	261516.0
2009-07-21	AFK	ETF	26.9899	26.9899	26.0	26.36	5941.0
2009-07-21	AGG	ETF	102.09	103.01	102.09	103.0	812700.0
2009-07-21	AGQ	ETF	81.22	81.22	78.68	79.7	161350.0
2009-07-21	AGZ	ETF	107.53	108.28	107.175	107.715	55590.0
2009-07-21	AIA	ETF	35.18	35.18	34.56	34.85	60240.0
2009-07-21	AIQ	ETF	31.85	32.25	31.25	32.1	121962.0
2009-07-21	AIS	ETF	0.82	0.87	0.7826	0.87	497662.0
2009-07-21	AIVI	ETF	37.27	37.27	36.58	36.84	25700.0
2009-07-21	AMJ	ETF	24.16	24.3	23.8819	24.01	198463.0
2009-07-21	AOA	ETF	26.23	26.23	25.84	26.05	5400.0
2009-07-21	AOK	ETF	25.93	25.98	25.93	25.954	2759.0
2009-07-21	AOM	ETF	26.04	26.04	26.0	26.0	940.0
2009-07-21	AOR	ETF	26.31	26.31	26.0194	26.15	3503.0
2009-07-21	ARB	ETF	17.49	17.87	14.87	15.88	1577871.0
2009-07-21	BAL	ETF	33.68	33.68	31.95	32.13	8220.0
2009-07-21	BBH	ETF	32.6867	33.1	32.5467	33.1	462600.0
2009-07-21	BIL	ETF	91.72	91.74	91.7	91.72	509850.0
2009-07-21	BITS	ETF	22.76	22.76	21.6	22.4	1950.0
2009-07-21	BIV	ETF	77.47	78.28	77.3	78.24	98600.0
2009-07-21	BJK	ETF	22.8	22.8	21.3	21.3	9600.0
2009-07-21	BKF	ETF	37.76	37.76	36.72	37.43	440789.0
2009-07-21	BLV	ETF	73.81	74.92	73.35	74.72	24300.0
2009-07-21	BMVP	ETF	11.32	11.32	11.2	11.27	14278.0
2009-07-21	BND	ETF	77.66	78.24	77.55	78.2	438600.0
2009-07-21	BNE	ETF	7.1	7.36	6.93	7.36	105800.0
2009-07-21	BRF	ETF	31.49	31.49	30.65	31.11	290738.0
2009-07-21	BSV	ETF	79.36	79.62	79.27	79.55	220400.0
2009-07-21	BTF	ETF	50.0	50.8	49.85	50.8	3503.8
2009-07-21	BWX	ETF	27.75	27.835	27.705	27.71	402164.0
2009-07-21	BWZ	ETF	35.77	35.87	35.77	35.87	4947.0
2009-07-21	BZQ	ETF	8000.0	8422.4	8000.0	8172.8	31.25
2009-07-21	CBON	ETF	0.8	0.8	0.7	0.7	17545.0
2009-07-21	CEF	ETF	11.97	11.97	11.77	11.84	549100.0
2009-07-21	CEW	ETF	21.21	21.21	21.06	21.14	31490.0
2009-07-21	CGO	ETF	12.06	12.14	11.91	12.0	19464.0
2009-07-21	CGW	ETF	16.15	16.15	15.8301	16.028	88740.0
2009-07-21	CHB	ETF	0.32	0.35	0.29	0.3	1326744.0
2009-07-21	CHI	ETF	10.8	10.8799	10.61	10.77	144064.0
2009-07-21	CHIC	ETF	12.61	12.66	11.7	12.07	588218.0
2009-07-21	CHW	ETF	6.91	6.94	6.766	6.89	131581.0

> showing 50 of 667 rows — these rows as CSV

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