PREVIEW / etf_daily / 2009-09-23

all etf daily files

  file:    by_date/etf_daily/2009/2009-09-23.parquet
  size:    30 KB
  rows:    675

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-23	SPY	ETF	107.32	108.03	105.99	106.18	225947400.0
2009-09-23	QQQ	ETF	42.83	43.17	42.377	42.45	143924062.0
2009-09-23	IWM	ETF	62.13	62.61	61.31	61.43	54838900.0
2009-09-23	DIA	ETF	98.36	99.16	97.4	97.58	13199100.0
2009-09-23	GLD	ETF	99.16	99.89	98.68	98.83	14688000.0
2009-09-23	TLT	ETF	95.94	96.58	95.2	96.47	5712000.0
2009-09-23	AAXJ	ETF	52.61	53.25	52.48	52.72	134800.0
2009-09-23	ACWI	ETF	41.57	41.67	40.9	40.9	152100.0
2009-09-23	ACWX	ETF	40.51	40.7488	40.02	40.02	72795.0
2009-09-23	ADRE	ETF	41.3	41.44	40.69	40.81	98209.0
2009-09-23	AFK	ETF	29.09	29.57	29.09	29.31	18923.0
2009-09-23	AGG	ETF	104.14	104.39	104.0	104.35	616700.0
2009-09-23	AGQ	ETF	119.54	121.12	115.7	117.96	261050.0
2009-09-23	AGZ	ETF	108.37	108.6299	108.11	108.12	9986.0
2009-09-23	AIA	ETF	39.12	39.17	38.72	38.75	22372.0
2009-09-23	AIQ	ETF	27.25	27.75	27.2	27.2	35793.0
2009-09-23	AIS	ETF	1.24	1.24	1.15	1.16	469162.0
2009-09-23	AIVI	ETF	43.41	43.46	42.79	42.86	19200.0
2009-09-23	AMJ	ETF	25.1	25.17	24.8499	25.0	996610.0
2009-09-23	AOA	ETF	29.66	30.05	29.21	29.21	8600.0
2009-09-23	AOK	ETF	27.2199	27.24	27.15	27.15	12160.0
2009-09-23	AOM	ETF	28.22	28.22	27.5	28.07	19374.0
2009-09-23	AOR	ETF	28.8	28.8	28.51	28.53	21502.0
2009-09-23	ARB	ETF	19.9	20.04	19.74	19.82	236356.0
2009-09-23	BAL	ETF	33.08	33.77	33.0	33.75	12223.0
2009-09-23	BBH	ETF	34.1	34.3133	33.7933	33.84	171600.0
2009-09-23	BIL	ETF	91.72	91.74	91.7	91.74	129750.0
2009-09-23	BITS	ETF	21.72	21.84	21.03	21.8	1832.0
2009-09-23	BIV	ETF	79.73	80.08	79.55	80.08	184200.0
2009-09-23	BJK	ETF	26.56	26.65	26.28	26.32	13300.0
2009-09-23	BKF	ETF	42.18	42.48	41.46	41.68	203417.0
2009-09-23	BLV	ETF	78.82	79.09	78.37	78.81	34400.0
2009-09-23	BMVP	ETF	12.113	12.209	12.027	12.027	16328.0
2009-09-23	BND	ETF	79.05	79.18	78.92	79.17	540700.0
2009-09-23	BNE	ETF	7.03	7.28	7.0	7.13	224801.0
2009-09-23	BOSS	ETF	20.32	20.32	20.16	20.16	200.0
2009-09-23	BRF	ETF	39.94	40.21	39.0	39.1	326550.0
2009-09-23	BSV	ETF	79.67	79.95	79.67	79.92	350900.0
2009-09-23	BTF	ETF	60.8	61.349999999999994	60.35	60.8	7042.6
2009-09-23	BWX	ETF	29.22	29.3	29.05	29.155	307102.0
2009-09-23	BWZ	ETF	37.3	37.4297	37.25	37.27	23498.0
2009-09-23	BZQ	ETF	5488.0	5657.6	5440.0	5657.6	13.25
2009-09-23	CEF	ETF	13.25	13.25	12.98	13.0	787700.0
2009-09-23	CEW	ETF	21.71	21.8748	21.68	21.738	105016.0
2009-09-23	CGO	ETF	14.03	14.03	13.77	13.94	16755.0
2009-09-23	CGW	ETF	18.09	18.22	17.8601	17.94	65968.0
2009-09-23	CHB	ETF	0.6	0.6	0.53	0.56	3447448.0
2009-09-23	CHI	ETF	11.63	11.9	11.6	11.81	220240.0
2009-09-23	CHIC	ETF	17.47	17.48	17.46	17.46	407255.0
2009-09-23	CHW	ETF	7.76	7.96	7.76	7.798	193128.0

> showing 50 of 675 rows — these rows as CSV

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