PREVIEW / etf_daily / 2009-09-15

all etf daily files

  file:    by_date/etf_daily/2009/2009-09-15.parquet
  size:    29 KB
  rows:    670

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-15	SPY	ETF	105.45	106.11	104.76	105.72	196795900.0
2009-09-15	QQQ	ETF	41.66	41.95	41.57	41.81	91594541.0
2009-09-15	IWM	ETF	60.01	60.72	59.77	60.54	48814300.0
2009-09-15	DIA	ETF	96.5	97.31	95.96	96.9	11687700.0
2009-09-15	GLD	ETF	97.75	99.1	97.56	98.9	16247000.0
2009-09-15	TLT	ETF	95.19	95.77	95.07	95.25	2187900.0
2009-09-15	AAXJ	ETF	51.8	52.19	51.45	52.19	2009200.0
2009-09-15	ACWI	ETF	40.43	40.7	40.2	40.58	1886000.0
2009-09-15	ACWX	ETF	39.36	39.72	39.22	39.65	55348.0
2009-09-15	ADRE	ETF	40.35	40.67	40.06	40.59	108075.0
2009-09-15	AFK	ETF	28.17	28.23	27.9	28.06	13460.0
2009-09-15	AGG	ETF	103.96	104.16	103.9	103.93	471600.0
2009-09-15	AGQ	ETF	114.78	121.4	114.62	121.14	271200.0
2009-09-15	AGZ	ETF	108.11	108.31	107.81	108.2021	4799.0
2009-09-15	AIA	ETF	37.6	37.89	37.53	37.856	64642.0
2009-09-15	AIQ	ETF	27.8	27.85	27.1	27.45	43694.0
2009-09-15	AIS	ETF	1.06	1.1	1.06	1.08	468943.0
2009-09-15	AIVI	ETF	42.61	43.0	42.43	42.81	26600.0
2009-09-15	AMJ	ETF	24.73	24.84	24.67	24.77	243506.0
2009-09-15	AOA	ETF	28.83	28.98	28.78	28.98	3300.0
2009-09-15	AOK	ETF	27.0	27.05	26.98	27.05	2026.0
2009-09-15	AOM	ETF	27.99	27.99	27.642	27.78	9315.0
2009-09-15	AOR	ETF	27.63	28.37	27.48	28.34	10918.0
2009-09-15	ARB	ETF	18.47	19.06	18.47	18.96	175848.0
2009-09-15	BAL	ETF	32.62	32.89	32.5	32.826	4231.0
2009-09-15	BBH	ETF	33.6633	33.8733	33.5833	33.6033	112800.0
2009-09-15	BIL	ETF	91.7	91.72	91.7	91.7	167500.0
2009-09-15	BITS	ETF	21.92	21.96	21.72	21.8	565.0
2009-09-15	BIV	ETF	79.61	79.64	79.32	79.56	135200.0
2009-09-15	BJK	ETF	25.99	26.49	25.75	26.29	13400.0
2009-09-15	BKF	ETF	40.68	40.99	40.3789	40.94	167193.0
2009-09-15	BLV	ETF	78.13	78.36	77.82	78.12	20200.0
2009-09-15	BMVP	ETF	11.96	12.01	11.91	11.98	30498.0
2009-09-15	BND	ETF	78.92	78.99	78.81	78.94	378100.0
2009-09-15	BNE	ETF	7.21	7.28	6.86	7.2	210991.0
2009-09-15	BRF	ETF	39.24	39.66	38.51	39.48	568447.0
2009-09-15	BSV	ETF	79.88	79.99	79.62	79.67	540100.0
2009-09-15	BTF	ETF	58.4	58.449999999999996	57.85	58.422999999999995	5854.6
2009-09-15	BWX	ETF	29.0	29.13	28.81	29.11	387362.0
2009-09-15	BWZ	ETF	37.04	37.12	36.9392	37.12	20670.0
2009-09-15	BZQ	ETF	6104.0	6104.0	5995.2	6003.2	12.0
2009-09-15	CEF	ETF	13.1	13.38	12.94	13.36	730600.0
2009-09-15	CEW	ETF	21.54	21.65	21.49	21.65	13622.0
2009-09-15	CGO	ETF	13.76	13.8736	13.62	13.87	25135.0
2009-09-15	CGW	ETF	17.74	17.95	17.68	17.92	62622.0
2009-09-15	CHB	ETF	0.47	0.56	0.46	0.55	4941971.0
2009-09-15	CHI	ETF	11.48	11.65	11.42	11.53	172863.0
2009-09-15	CHIC	ETF	17.45	17.47	17.44	17.46	343036.0
2009-09-15	CHW	ETF	7.73	7.73	7.51	7.65	241583.0
2009-09-15	CHY	ETF	11.3	11.35	11.23	11.26	180382.0

> showing 50 of 670 rows — these rows as CSV

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