PREVIEW / etf_daily / 2009-07-28

all etf daily files

  file:    by_date/etf_daily/2009/2009-07-28.parquet
  size:    30 KB
  rows:    671

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-07-28	SPY	ETF	97.66	98.37	97.06	97.89	186685200.0
2009-07-28	QQQ	ETF	39.18	39.59	38.93	39.08	111564277.0
2009-07-28	IWM	ETF	54.76	55.32	54.34	55.12	56192800.0
2009-07-28	DIA	ETF	90.61	91.28	90.08	90.99	11700400.0
2009-07-28	GLD	ETF	92.74	92.82	91.65	92.11	10881200.0
2009-07-28	TLT	ETF	90.72	91.82	90.43	91.2	3324800.0
2009-07-28	AAXJ	ETF	49.26	49.7	49.02	49.6	266200.0
2009-07-28	ACWI	ETF	37.12	37.26	36.79	37.09	80000.0
2009-07-28	ACWX	ETF	35.93	36.05	35.59	35.95	30744.0
2009-07-28	ADRE	ETF	37.88	38.0	37.372	37.88	95825.0
2009-07-28	AFK	ETF	27.45	28.1	27.13	27.5001	20236.0
2009-07-28	AGG	ETF	102.01	102.53	102.01	102.27	674500.0
2009-07-28	AGQ	ETF	83.4	83.76	80.02	81.5	270300.0
2009-07-28	AGZ	ETF	107.73	107.745	107.08	107.55	31417.0
2009-07-28	AIA	ETF	36.27	36.31	35.83	36.28	59263.0
2009-07-28	AIQ	ETF	34.4	36.25	34.3	35.5	66625.0
2009-07-28	AIS	ETF	0.89	0.9	0.86	0.88	213496.0
2009-07-28	AIVI	ETF	37.48	37.61	37.06	37.49	16800.0
2009-07-28	AMJ	ETF	24.98	25.0287	24.6432	24.869	154880.0
2009-07-28	AOA	ETF	26.79	26.79	26.49	26.72	7800.0
2009-07-28	AOK	ETF	25.83	26.59	25.83	26.11	16107.0
2009-07-28	AOM	ETF	26.32	26.36	25.85	26.3	17941.0
2009-07-28	AOR	ETF	26.66	26.66	25.94	26.5	10214.0
2009-07-28	ARB	ETF	17.18	17.3875	16.45	16.92	161021.0
2009-07-28	BAL	ETF	30.74	30.8096	30.73	30.73	2800.0
2009-07-28	BBH	ETF	34.05	34.4733	33.9367	34.37	584100.0
2009-07-28	BIL	ETF	91.72	91.72	91.7	91.72	243500.0
2009-07-28	BITS	ETF	22.4	22.56	22.2	22.56	752.0
2009-07-28	BIV	ETF	77.51	77.73	77.25	77.32	137600.0
2009-07-28	BJK	ETF	22.43	22.43	21.99	22.27	9700.0
2009-07-28	BKF	ETF	38.54	38.78	37.87	38.55	1032484.0
2009-07-28	BLV	ETF	73.77	74.46	73.7	74.07	22000.0
2009-07-28	BMVP	ETF	11.47	11.49	11.38	11.47	17177.0
2009-07-28	BND	ETF	77.75	77.98	77.51	77.78	686600.0
2009-07-28	BNE	ETF	8.0	8.2	7.92	8.19	97056.0
2009-07-28	BOSS	ETF	16.79	16.79	16.11	16.79	100.0
2009-07-28	BRF	ETF	32.52	32.79	32.02	32.79	69997.0
2009-07-28	BSV	ETF	79.35	79.39	79.15	79.29	271300.0
2009-07-28	BTF	ETF	53.099999999999994	53.099999999999994	52.255	53.05	4712.0
2009-07-28	BWX	ETF	27.695	27.8	27.695	27.8	429472.0
2009-07-28	BWZ	ETF	35.75	35.795	35.614	35.64	10438.0
2009-07-28	BZQ	ETF	7852.8	7852.8	7644.8	7747.2	23.25
2009-07-28	CBON	ETF	0.74	0.74	0.6698	0.71	21817.0
2009-07-28	CEF	ETF	11.88	11.99	11.74	11.78	945800.0
2009-07-28	CEW	ETF	21.28	21.35	21.1515	21.3	37326.0
2009-07-28	CGO	ETF	12.25	12.8498	12.25	12.53	51258.0
2009-07-28	CGW	ETF	16.26	16.33	16.04	16.33	61570.0
2009-07-28	CHB	ETF	0.51	0.65	0.5	0.54	5740215.0
2009-07-28	CHI	ETF	11.12	11.25	10.85	10.9	167353.0
2009-07-28	CHIC	ETF	14.34	14.49	14.14	14.38	250281.0

> showing 50 of 671 rows — these rows as CSV

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