PREVIEW / etf_daily / 2009-11-23

all etf daily files

  file:    by_date/etf_daily/2009/2009-11-23.parquet
  size:    30 KB
  rows:    693

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-11-23	SPY	ETF	110.72	111.74	110.6	110.82	148010200.0
2009-11-23	QQQ	ETF	43.87	44.4	43.86	44.14	91621407.0
2009-11-23	IWM	ETF	59.41	60.32	59.29	59.61	57935400.0
2009-11-23	DIA	ETF	104.2	104.98	104.13	104.46	9489200.0
2009-11-23	GLD	ETF	114.67	115.12	113.99	114.29	24457700.0
2009-11-23	TLT	ETF	94.54	95.1	94.34	95.0	3219300.0
2009-11-23	AAXJ	ETF	55.79	56.5	55.79	56.15	96300.0
2009-11-23	ACWI	ETF	42.34	42.84	42.34	42.53	222700.0
2009-11-23	ACWX	ETF	41.62	41.7	41.34	41.4	78361.0
2009-11-23	ADRE	ETF	45.01	45.16	44.6001	44.71	152292.0
2009-11-23	AFK	ETF	28.66	29.434	28.6401	28.6401	10108.0
2009-11-23	AGG	ETF	105.05	105.17	104.92	105.15	470600.0
2009-11-23	AGQ	ETF	142.8	144.1	138.36	138.96	380600.0
2009-11-23	AGZ	ETF	108.64	108.89	108.525	108.79	14192.0
2009-11-23	AIA	ETF	40.23	40.58	40.14	40.24	89807.0
2009-11-23	AIQ	ETF	27.95	29.5	27.95	29.3	22518.0
2009-11-23	AIS	ETF	1.14	1.15	1.1	1.15	287284.0
2009-11-23	AIVI	ETF	44.66	44.95	44.44	44.56	32900.0
2009-11-23	AMJ	ETF	26.77	26.98	26.637	26.77	263381.0
2009-11-23	AOA	ETF	29.4	30.08	29.4	29.7	7500.0
2009-11-23	AOK	ETF	27.54	27.56	27.47	27.52	16372.0
2009-11-23	AOM	ETF	28.19	28.397	28.19	28.34	10883.0
2009-11-23	AOR	ETF	28.84	29.1179	28.84	28.98	22361.0
2009-11-23	ARB	ETF	22.6	22.89	22.32	22.7	174584.0
2009-11-23	BAB	ETF	24.92	24.99	24.9	24.9	24942.0
2009-11-23	BAL	ETF	35.8	37.095	35.8	36.62	22801.0
2009-11-23	BBH	ETF	32.27	32.6467	32.27	32.4667	147300.0
2009-11-23	BIL	ETF	91.7	91.72	91.7	91.7	63200.0
2009-11-23	BITS	ETF	27.76	27.76	26.32	26.92	1910.0
2009-11-23	BIV	ETF	80.77	80.93	80.64	80.87	98800.0
2009-11-23	BJK	ETF	25.39	25.44	24.93	24.93	11000.0
2009-11-23	BKF	ETF	47.26	47.45	46.82	46.97	438330.0
2009-11-23	BLV	ETF	78.19	78.19	77.31	78.03	83800.0
2009-11-23	BMVP	ETF	12.25	12.4142	12.25	12.3233	12870.0
2009-11-23	BND	ETF	79.77	79.84	79.62	79.79	517500.0
2009-11-23	BNE	ETF	6.24	6.52	6.2	6.29	125561.0
2009-11-23	BRF	ETF	47.24	47.45	47.03	47.35	335972.0
2009-11-23	BSV	ETF	80.35	80.35	80.11	80.32	882900.0
2009-11-23	BTF	ETF	64.1	64.45	63.8	64.35	22183.0
2009-11-23	BWX	ETF	29.875	29.875	29.725	29.79	437662.0
2009-11-23	BWZ	ETF	37.94	37.9798	37.855	37.94	47191.0
2009-11-23	BZQ	ETF	3808.0	3889.6	3772.8	3881.6	301.0
2009-11-23	CEF	ETF	14.65	14.84	14.43	14.63	2021300.0
2009-11-23	CEW	ETF	22.28	22.34	22.239	22.26	118813.0
2009-11-23	CGO	ETF	13.98	13.98	13.55	13.56	40402.0
2009-11-23	CGW	ETF	18.13	18.35	18.07	18.2	153067.0
2009-11-23	CHI	ETF	12.13	12.18	11.97	11.99	126471.0
2009-11-23	CHW	ETF	7.79	7.82	7.65	7.71	304014.0
2009-11-23	CHY	ETF	11.33	11.43	11.2323	11.3	262005.0
2009-11-23	CMF	ETF	52.475	52.895	52.475	52.594	11364.0

> showing 50 of 693 rows — these rows as CSV

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