PREVIEW / etf_daily / 2009-08-28

all etf daily files

  file:    by_date/etf_daily/2009/2009-08-28.parquet
  size:    29 KB
  rows:    661

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-08-28	SPY	ETF	104.23	104.35	102.67	103.38	147024400.0
2009-08-28	QQQ	ETF	40.89	41.08	40.16	40.44	114310203.0
2009-08-28	IWM	ETF	59.02	59.18	57.66	58.05	39328800.0
2009-08-28	DIA	ETF	96.39	96.45	95.01	95.58	10813900.0
2009-08-28	GLD	ETF	94.07	94.15	93.63	93.87	6757700.0
2009-08-28	TLT	ETF	95.44	96.51	95.31	96.51	2072500.0
2009-08-28	AAXJ	ETF	49.52	49.52	48.72	49.07	83400.0
2009-08-28	ACWI	ETF	39.51	39.66	39.12	39.31	233100.0
2009-08-28	ACWX	ETF	38.56	38.56	38.11	38.186	14106.0
2009-08-28	ADRE	ETF	38.95	38.95	38.224	38.44	92189.0
2009-08-28	AFK	ETF	28.53	28.56	28.15	28.1501	4355.0
2009-08-28	AGG	ETF	103.49	103.87	103.43	103.59	503600.0
2009-08-28	AGQ	ETF	92.06	93.34	91.32	91.96	142200.0
2009-08-28	AGZ	ETF	107.74	108.04	107.64	108.04	16075.0
2009-08-28	AIA	ETF	36.13	36.13	35.7001	35.828	20718.0
2009-08-28	AIQ	ETF	27.75	27.95	27.25	27.5	58204.0
2009-08-28	AIS	ETF	0.93	0.97	0.87	0.94	243328.0
2009-08-28	AIVI	ETF	41.4	41.4	40.67	40.94	19600.0
2009-08-28	AMJ	ETF	24.0	24.04	23.76	23.9	232787.0
2009-08-28	AOA	ETF	28.54	28.54	28.09	28.15	14100.0
2009-08-28	AOK	ETF	26.78	26.79	26.76	26.78	17773.0
2009-08-28	AOM	ETF	27.89	27.89	27.274	27.3	6274.0
2009-08-28	AOR	ETF	28.06	28.06	27.69	27.75	28884.0
2009-08-28	ARB	ETF	18.87	18.9	18.25	18.56	242909.0
2009-08-28	BAL	ETF	30.19	30.19	30.0755	30.0755	549.0
2009-08-28	BBH	ETF	33.8667	33.9333	33.04	33.2867	341400.0
2009-08-28	BIL	ETF	91.72	91.76	91.7	91.74	83550.0
2009-08-28	BITS	ETF	20.28	20.4	20.12	20.4	1025.0
2009-08-28	BIV	ETF	79.11	79.51	79.01	79.51	104100.0
2009-08-28	BJK	ETF	24.4	24.4	23.74	24.22	79900.0
2009-08-28	BKF	ETF	38.49	38.6986	37.99	38.24	110903.0
2009-08-28	BLV	ETF	77.47	77.99	77.41	77.99	17000.0
2009-08-28	BMVP	ETF	11.93	11.93	11.74	11.79	14876.0
2009-08-28	BND	ETF	78.57	78.82	78.48	78.82	633000.0
2009-08-28	BNE	ETF	6.88	7.27	6.88	7.04	425240.0
2009-08-28	BRF	ETF	36.72	36.87	36.31	36.51	135057.0
2009-08-28	BSV	ETF	79.65	79.79	79.61	79.76	350500.0
2009-08-28	BTF	ETF	59.15	59.15	57.99999999999999	58.3	3583.4
2009-08-28	BWX	ETF	28.395	28.395	28.2062	28.27	309876.0
2009-08-28	BWZ	ETF	36.34	36.34	36.23	36.24	12274.0
2009-08-28	BZQ	ETF	6795.2	7049.6	6790.4	7040.0	49.5
2009-08-28	CEF	ETF	12.22	12.29	12.13	12.19	724100.0
2009-08-28	CEW	ETF	21.34	21.34	21.24	21.33	37485.0
2009-08-28	CGO	ETF	13.16	13.2	13.1253	13.159	10425.0
2009-08-28	CGW	ETF	17.2	17.278	16.95	17.07	56068.0
2009-08-28	CHB	ETF	0.69	0.72	0.5811	0.63	6628987.0
2009-08-28	CHI	ETF	11.21	11.33	11.11	11.1381	137807.0
2009-08-28	CHIC	ETF	17.4	17.4	17.35	17.35	1849925.0
2009-08-28	CHW	ETF	7.41	7.41	7.29	7.35	205219.0
2009-08-28	CHY	ETF	11.07	11.15	11.0	11.02	107209.0

> showing 50 of 661 rows — these rows as CSV

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