PREVIEW / etf_daily / 2009-03-04

all etf daily files

  file:    by_date/etf_daily/2009/2009-03-04.parquet
  size:    28 KB
  rows:    642

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-04	SPY	ETF	71.23	72.87	70.07	71.73	462753100.0
2009-03-04	QQQ	ETF	27.01	27.71	26.92	27.33	164906096.0
2009-03-04	IWM	ETF	36.79	37.65	36.22	36.99	80120300.0
2009-03-04	DIA	ETF	68.35	69.88	67.63	68.77	31996400.0
2009-03-04	GLD	ETF	90.25	90.35	88.45	88.99	19875100.0
2009-03-04	TLT	ETF	101.49	102.25	101.16	102.12	3178400.0
2009-03-04	AAXJ	ETF	28.04	29.28	28.04	29.01	103200.0
2009-03-04	ACWI	ETF	24.96	25.62	24.84	25.37	151700.0
2009-03-04	ACWX	ETF	23.11	23.91	23.11	23.613	68856.0
2009-03-04	ADRE	ETF	23.56	25.194	23.56	24.866	211477.0
2009-03-04	AFK	ETF	17.83	17.83	17.63	17.63	200.0
2009-03-04	AGG	ETF	100.38	100.38	99.77	100.1	548900.0
2009-03-04	AGQ	ETF	80.86	81.08	77.52	79.1	105900.0
2009-03-04	AGZ	ETF	107.25	107.5	106.88	107.48	10477.0
2009-03-04	AIA	ETF	22.12	22.57	21.92	22.546	12964.0
2009-03-04	AIQ	ETF	40.0	40.55	39.05	39.8	46615.0
2009-03-04	AIS	ETF	0.37	0.39	0.37	0.39	19580.0
2009-03-04	AIVI	ETF	24.93	25.65	24.74	25.27	27800.0
2009-03-04	AOA	ETF	20.13	21.06	19.13	19.71	63400.0
2009-03-04	AOK	ETF	23.95	24.05	23.94	24.02	2169.0
2009-03-04	AOM	ETF	22.69	22.8246	22.64	22.8	794.0
2009-03-04	AOR	ETF	21.41	21.5	21.41	21.5	1047.0
2009-03-04	ARB	ETF	13.22	13.22	12.63	12.9	326597.0
2009-03-04	BAL	ETF	24.5	24.5	24.5	24.5	400.0
2009-03-04	BBH	ETF	52.8767	53.6633	52.79	53.2967	471600.0
2009-03-04	BIL	ETF	91.78	91.78	91.68	91.76	140900.0
2009-03-04	BITS	ETF	18.96	18.96	16.2	18.4	425.0
2009-03-04	BIV	ETF	74.69	75.4	74.67	75.4	77100.0
2009-03-04	BJK	ETF	14.05	14.57	14.05	14.57	1500.0
2009-03-04	BKF	ETF	21.2	22.32	21.2	22.15	33408.0
2009-03-04	BLV	ETF	71.37	71.72	71.16	71.43	12500.0
2009-03-04	BMVP	ETF	8.7867	9.0767	8.7832	8.9533	58580.0
2009-03-04	BND	ETF	75.97	76.21	75.95	76.17	536700.0
2009-03-04	BNE	ETF	1.42	1.53	1.31	1.38	224499.0
2009-03-04	BOSS	ETF	9.36	9.36	9.32	9.36	100.0
2009-03-04	BSV	ETF	78.37	78.37	77.85	78.33	295700.0
2009-03-04	BTF	ETF	34.949999999999996	34.949999999999996	32.55	34.5405	35522.200000000004
2009-03-04	BWX	ETF	24.105	24.25	24.09	24.195	215424.0
2009-03-04	BWZ	ETF	31.38	31.38	31.38	31.38	100.0
2009-03-04	CBON	ETF	0.73	0.74	0.57	0.572	617620.0
2009-03-04	CDL	ETF	0.11	0.11	0.09	0.1	1841719.0
2009-03-04	CEF	ETF	11.44	11.47	11.1	11.2	1210900.0
2009-03-04	CGO	ETF	7.69	8.22	7.69	8.04	43028.0
2009-03-04	CGW	ETF	10.77	11.38	10.77	11.27	48346.0
2009-03-04	CHB	ETF	0.28	0.3	0.26	0.28	251112.0
2009-03-04	CHI	ETF	7.25	7.7	7.13	7.62	311807.0
2009-03-04	CHIC	ETF	4.98	5.34	4.9	5.02	298058.0
2009-03-04	CHW	ETF	4.56	4.73	4.42	4.67	238807.0
2009-03-04	CHY	ETF	6.95	7.4799	6.93	7.32	365774.0
2009-03-04	CMF	ETF	51.15	51.15	50.39	50.6375	13696.0

> showing 50 of 642 rows — these rows as CSV

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