PREVIEW / etf_daily / 2009-08-12

all etf daily files

  file:    by_date/etf_daily/2009/2009-08-12.parquet
  size:    29 KB
  rows:    667

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-12	SPY	ETF	99.56	101.56	99.51	100.8	219052400.0
2009-08-12	QQQ	ETF	39.21	40.22	39.2	39.87	147239950.0
2009-08-12	IWM	ETF	56.3	57.84	56.26	57.12	53618600.0
2009-08-12	DIA	ETF	92.55	94.42	92.53	93.77	13586400.0
2009-08-12	GLD	ETF	92.6	93.49	92.47	92.95	7906400.0
2009-08-12	TLT	ETF	92.95	93.07	91.09	91.69	4729200.0
2009-08-12	AAXJ	ETF	49.2	50.01	48.5	49.51	169900.0
2009-08-12	ACWI	ETF	37.82	38.53	37.82	38.27	231400.0
2009-08-12	ACWX	ETF	36.62	37.3	36.62	37.0	201835.0
2009-08-12	ADRE	ETF	38.02	38.6	38.02	38.31	682189.0
2009-08-12	AFK	ETF	27.4	30.36	27.3184	27.513	28755.0
2009-08-12	AGG	ETF	102.78	102.82	102.32	102.69	672100.0
2009-08-12	AGQ	ETF	87.4	91.6	87.38	91.14	90650.0
2009-08-12	AGZ	ETF	107.162	107.31	106.86	107.14	10970.0
2009-08-12	AIA	ETF	35.56	36.25	35.51	36.11	24274.0
2009-08-12	AIQ	ETF	25.65	26.2	25.55	26.0	91436.0
2009-08-12	AIS	ETF	0.98	0.98	0.9	0.95	158653.0
2009-08-12	AIVI	ETF	38.48	39.33	38.48	39.1	23600.0
2009-08-12	AMJ	ETF	24.42	24.7	24.2899	24.5929	408020.0
2009-08-12	AOA	ETF	27.33	27.61	27.33	27.55	3600.0
2009-08-12	AOK	ETF	26.5	26.72	26.3201	26.46	12370.0
2009-08-12	AOM	ETF	26.8794	26.92	26.16	26.92	6233.0
2009-08-12	AOR	ETF	27.09	27.26	27.09	27.1924	13848.0
2009-08-12	ARB	ETF	16.3	16.55	16.15	16.31	139383.0
2009-08-12	BAL	ETF	33.1	33.5	32.86	33.209	8200.0
2009-08-12	BBH	ETF	33.2867	33.7867	33.2167	33.57	449700.0
2009-08-12	BIL	ETF	91.7	91.74	91.7	91.74	188500.0
2009-08-12	BITS	ETF	22.16	22.4	21.6	22.0	2049.0
2009-08-12	BIV	ETF	78.15	78.15	77.61	77.96	198900.0
2009-08-12	BJK	ETF	23.08	24.2	23.08	23.42	8600.0
2009-08-12	BKF	ETF	38.5	39.17	38.31	39.07	208161.0
2009-08-12	BLV	ETF	76.25	76.57	75.25	75.43	39500.0
2009-08-12	BMVP	ETF	11.5433	11.75	11.5433	11.6771	19518.0
2009-08-12	BND	ETF	77.95	78.0	77.56	77.92	419500.0
2009-08-12	BNE	ETF	5.93	6.3	5.9	6.09	730653.0
2009-08-12	BOSS	ETF	19.8	19.92	19.8	19.92	500.0
2009-08-12	BRF	ETF	35.37	35.86	35.26	35.72	160048.0
2009-08-12	BSV	ETF	79.25	79.34	79.0	79.15	306100.0
2009-08-12	BTF	ETF	56.6005	57.5	56.6005	57.2335	9206.0
2009-08-12	BWX	ETF	27.79	27.895	27.66	27.86	468954.0
2009-08-12	BWZ	ETF	35.52	35.77	35.52	35.756	11362.0
2009-08-12	BZQ	ETF	7166.4	7166.4	6852.8	6852.8	30.75
2009-08-12	CBON	ETF	1.15	1.15	1.05	1.12	23497.0
2009-08-12	CEF	ETF	11.86	11.98	11.81	11.84	1562400.0
2009-08-12	CEW	ETF	21.108	21.26	21.108	21.23	15301.0
2009-08-12	CGO	ETF	12.95	13.05	12.88	12.95	19329.0
2009-08-12	CGW	ETF	16.15	16.57	16.13	16.37	54577.0
2009-08-12	CHB	ETF	0.5	0.5598	0.43	0.49	4357509.0
2009-08-12	CHI	ETF	11.33	11.51	11.23	11.3	180277.0
2009-08-12	CHIC	ETF	14.72	15.1799	14.56	14.77	256292.0

> showing 50 of 667 rows — these rows as CSV

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