PREVIEW / etf_daily / 2009-03-12

all etf daily files

  file:    by_date/etf_daily/2009/2009-03-12.parquet
  size:    28 KB
  rows:    632

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-03-12	SPY	ETF	72.62	75.75	71.97	75.5	409702700.0
2009-03-12	QQQ	ETF	27.72	28.76	27.44	28.67	184511048.0
2009-03-12	IWM	ETF	36.53	39.19	36.07	38.96	86839000.0
2009-03-12	DIA	ETF	69.38	71.99	68.85	71.77	21938300.0
2009-03-12	GLD	ETF	90.37	91.57	90.14	91.1	20128600.0
2009-03-12	TLT	ETF	102.66	103.97	102.31	103.25	3558900.0
2009-03-12	AAXJ	ETF	29.36	30.8	29.29	30.8	246700.0
2009-03-12	ACWI	ETF	25.52	26.49	25.24	26.42	58100.0
2009-03-12	ACWX	ETF	23.64	24.57	23.5	24.52	19648.0
2009-03-12	ADRE	ETF	25.42	26.524	25.33	26.42	264921.0
2009-03-12	AFK	ETF	18.35	18.69	18.35	18.69	200.0
2009-03-12	AGG	ETF	100.43	100.73	100.25	100.57	603500.0
2009-03-12	AGQ	ETF	77.32	80.26	77.32	79.18	96800.0
2009-03-12	AGZ	ETF	107.744	107.84	107.066	107.79	10670.0
2009-03-12	AIA	ETF	22.44	23.53	22.44	23.53	20701.0
2009-03-12	AIQ	ETF	32.9	33.4	31.4	33.0	127139.0
2009-03-12	AIS	ETF	0.39	0.4	0.37	0.39	154426.0
2009-03-12	AIVI	ETF	24.92	25.98	24.65	25.84	38100.0
2009-03-12	AOA	ETF	20.17	20.59	20.17	20.59	5500.0
2009-03-12	AOK	ETF	24.27	24.29	24.246	24.246	1265.0
2009-03-12	AOM	ETF	23.97	23.97	23.08	23.29	3555.0
2009-03-12	AOR	ETF	24.74	24.74	21.76	21.9644	1256.0
2009-03-12	ARB	ETF	12.6	13.16	12.13	13.02	355967.0
2009-03-12	BAL	ETF	24.38	24.62	24.38	24.61	2250.0
2009-03-12	BBH	ETF	55.1767	57.12	55.01	56.9733	1696500.0
2009-03-12	BIL	ETF	91.68	91.76	91.68	91.72	160550.0
2009-03-12	BITS	ETF	16.48	17.56	16.48	17.28	2262.0
2009-03-12	BIV	ETF	74.63	75.46	74.63	75.4	70300.0
2009-03-12	BJK	ETF	13.2	14.16	13.2	14.16	1100.0
2009-03-12	BKF	ETF	22.41	23.31	22.18	23.19	141767.0
2009-03-12	BLV	ETF	72.0	72.68	71.89	72.48	7500.0
2009-03-12	BMVP	ETF	8.95	9.36	8.88	9.31	40323.0
2009-03-12	BND	ETF	76.3	76.5	76.03	76.33	438300.0
2009-03-12	BNE	ETF	2.05	2.1699	1.6	2.08	305807.0
2009-03-12	BSV	ETF	78.05	78.05	77.81	77.94	181900.0
2009-03-12	BTF	ETF	35.4	36.949999999999996	35.05	36.74999999999999	21167.0
2009-03-12	BWX	ETF	24.68	24.9	24.55	24.9	216664.0
2009-03-12	CBON	ETF	0.9025	0.93	0.75	0.84	39552.0
2009-03-12	CEF	ETF	11.62	11.87	11.62	11.8	865800.0
2009-03-12	CGO	ETF	8.03	8.4	7.98	8.33	10075.0
2009-03-12	CGW	ETF	10.78	11.22	10.76	11.19	63207.0
2009-03-12	CHB	ETF	0.22	0.22	0.12	0.12	6543907.0
2009-03-12	CHI	ETF	7.39	7.99	7.32	7.8	202080.0
2009-03-12	CHIC	ETF	6.57	6.91	6.47	6.57	511521.0
2009-03-12	CHW	ETF	4.75	4.87	4.435	4.87	259826.0
2009-03-12	CHY	ETF	7.47	7.89	7.3	7.89	348940.0
2009-03-12	CMF	ETF	51.245	51.245	50.603	50.967	4430.0
2009-03-12	CNXT	ETF	0.44	0.48	0.406	0.47	269883.0
2009-03-12	COW	ETF	30.61	31.34	30.61	31.27	62980.0
2009-03-12	CPST	ETF	0.47	0.58	0.47	0.57	1320670.0

> showing 50 of 632 rows — these rows as CSV

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