PREVIEW / etf_daily / 2009-08-27

all etf daily files

  file:    by_date/etf_daily/2009/2009-08-27.parquet
  size:    29 KB
  rows:    668

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-27	SPY	ETF	103.11	103.72	101.94	103.4	196230100.0
2009-08-27	QQQ	ETF	40.32	40.47	39.67	40.4	121957773.0
2009-08-27	IWM	ETF	58.44	58.6	57.23	58.42	45253800.0
2009-08-27	DIA	ETF	95.5	96.12	94.6	95.82	13096800.0
2009-08-27	GLD	ETF	92.8	93.31	92.38	93.19	6870300.0
2009-08-27	TLT	ETF	96.18	96.62	95.73	96.07	2514000.0
2009-08-27	AAXJ	ETF	49.13	49.31	48.44	49.31	106700.0
2009-08-27	ACWI	ETF	39.21	39.43	38.67	39.31	99700.0
2009-08-27	ACWX	ETF	38.04	38.38	37.63	38.27	73926.0
2009-08-27	ADRE	ETF	38.41	38.676	37.89	38.59	86222.0
2009-08-27	AFK	ETF	27.88	28.39	27.75	28.39	10345.0
2009-08-27	AGG	ETF	103.5	103.73	103.42	103.66	487300.0
2009-08-27	AGQ	ETF	86.46	87.06	83.64	86.32	79400.0
2009-08-27	AGZ	ETF	107.91	107.91	107.41	107.68	21365.0
2009-08-27	AIA	ETF	35.79	35.89	35.28	35.87	55758.0
2009-08-27	AIQ	ETF	27.85	27.9	27.0	27.65	47161.0
2009-08-27	AIS	ETF	0.96	0.96	0.9306	0.94	118002.0
2009-08-27	AIVI	ETF	40.68	41.17	40.16	40.99	16900.0
2009-08-27	AMJ	ETF	23.98	23.98	23.5465	23.92	222170.0
2009-08-27	AOA	ETF	27.87	28.14	27.82	28.09	17600.0
2009-08-27	AOK	ETF	26.8	27.09	26.52	26.7688	26515.0
2009-08-27	AOM	ETF	27.16	27.79	27.144	27.3	28927.0
2009-08-27	AOR	ETF	27.76	28.49	27.472	27.75	14928.0
2009-08-27	ARB	ETF	18.67	18.82	18.17	18.81	252669.0
2009-08-27	BAL	ETF	29.72	29.93	29.54	29.93	2700.0
2009-08-27	BBH	ETF	33.6733	33.73	33.3333	33.5967	220500.0
2009-08-27	BIL	ETF	91.7	91.74	91.7	91.72	118750.0
2009-08-27	BITS	ETF	20.56	20.56	19.632	20.28	1575.0
2009-08-27	BIV	ETF	79.29	79.45	79.0	79.26	117000.0
2009-08-27	BJK	ETF	23.96	23.98	23.24	23.9	5900.0
2009-08-27	BKF	ETF	38.46	38.5	37.6608	38.5	160541.0
2009-08-27	BLV	ETF	77.98	77.98	77.45	77.57	10100.0
2009-08-27	BMVP	ETF	11.8567	11.864	11.7234	11.8433	14109.0
2009-08-27	BND	ETF	78.66	78.73	78.5	78.66	402300.0
2009-08-27	BNE	ETF	6.37	6.89	6.16	6.88	398799.0
2009-08-27	BRF	ETF	36.76	36.85	35.75	36.7	168055.0
2009-08-27	BSV	ETF	79.68	79.74	79.59	79.65	317600.0
2009-08-27	BTF	ETF	58.65	58.65	57.4	58.3	6020.6
2009-08-27	BWX	ETF	28.125	28.3725	28.124	28.37	371020.0
2009-08-27	BWZ	ETF	36.08	36.29	36.0717	36.263	9097.0
2009-08-27	BZQ	ETF	6971.2	7219.2	6806.4	6806.4	22.5
2009-08-27	CEF	ETF	12.05	12.15	12.0	12.11	437700.0
2009-08-27	CEW	ETF	21.2791	21.3144	21.2	21.3144	23349.0
2009-08-27	CGO	ETF	13.19	13.19	12.79	13.17	42451.0
2009-08-27	CGW	ETF	17.13	17.23	16.8	17.17	64530.0
2009-08-27	CHB	ETF	0.5	0.71	0.5	0.65	12411785.0
2009-08-27	CHI	ETF	11.34	11.352	11.15	11.22	158217.0
2009-08-27	CHIC	ETF	17.39	17.41	17.36	17.37	1795327.0
2009-08-27	CHW	ETF	7.24	7.4	7.24	7.344	165792.0
2009-08-27	CHY	ETF	11.23	11.23	10.99	11.03	197375.0

> showing 50 of 668 rows — these rows as CSV

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