PREVIEW / etf_daily / 2005-08-09

all etf daily files

  file:    by_date/etf_daily/2005/2005-08-09.parquet
  size:    15 KB
  rows:    279

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
2005-08-09	SPY	ETF	123.06	123.59	122.87	123.39	47170000.0
2005-08-09	QQQ	ETF	39.37	39.59	39.306	39.45	64615442.0
2005-08-09	IWM	ETF	65.89	66.07	65.45	65.84	21193800.0
2005-08-09	DIA	ETF	105.87	106.43	105.82	106.27	5427100.0
2005-08-09	GLD	ETF	43.27	43.35	43.17	43.34	1305800.0
2005-08-09	TLT	ETF	91.7	91.85	91.28	91.83	1474800.0
2005-08-09	AAA	ETF	56.81	56.87	56.66	56.84	2200.0
2005-08-09	ADRE	ETF	98.5	99.92	98.5	99.86	5720.0
2005-08-09	AFK	ETF	25.71	25.71	25.58	25.63	3700.0
2005-08-09	AGG	ETF	101.18	101.26	101.0	101.26	103300.0
2005-08-09	AIQ	ETF	49.0	49.75	45.75	46.15	40840.0
2005-08-09	AIS	ETF	0.96	1.02	0.91	0.97	134400.0
2005-08-09	ARB	ETF	41.66	41.7	41.09	41.37	228100.0
2005-08-09	BAB	ETF	51.29	51.66	51.15	51.5	38300.0
2005-08-09	BBH	ETF	62.7	63.2267	62.7	63.0567	748500.0
2005-08-09	BCM	ETF	59.0	59.12	58.3	58.41	59900.0
2005-08-09	BIS	ETF	680.0	724.8	680.0	721.6	57.5
2005-08-09	BITS	ETF	15.8	15.8	14.4	14.44	4014.0
2005-08-09	BKF	ETF	32.98	33.18	32.71	32.91	9200.0
2005-08-09	BNE	ETF	13.88	13.9	13.67	13.67	339900.0
2005-08-09	BOSS	ETF	26.89	26.92	26.89	26.92	500.0
2005-08-09	BRF	ETF	15.4	15.41	15.4	15.41	1200.0
2005-08-09	BTF	ETF	85.5	85.85000000000001	85.5	85.74999999999999	920.0
2005-08-09	CBON	ETF	32.56	33.01	32.56	32.85	3815.0
2005-08-09	CDC	ETF	4.2	4.2	3.2	3.6	87900.0
2005-08-09	CDL	ETF	12.55	13.37	12.51	13.3	1137800.0
2005-08-09	CEF	ETF	5.29	5.3	5.25	5.3	261500.0
2005-08-09	CHB	ETF	11.95	12.14	11.93	12.05	288000.0
2005-08-09	CHI	ETF	20.55	20.65	20.43	20.65	76400.0
2005-08-09	CHIC	ETF	14.2	14.45	14.17	14.35	145504.0
2005-08-09	CHIR	ETF	36.5901	36.8301	36.3399	36.5001	600645.0
2005-08-09	CHY	ETF	16.42	16.6	16.42	16.59	102400.0
2005-08-09	CIL	ETF	25.85	25.85	25.8	25.85	2000.0
2005-08-09	CIZ	ETF	23.5	23.5	23.5	23.5	2100.0
2005-08-09	CN	ETF	32.75	32.76	32.17	32.36	31200.0
2005-08-09	CNXT	ETF	1.75	1.84	1.73	1.78	5937480.0
2005-08-09	CPI	ETF	23.51	23.51	23.41	23.41	1900.0
2005-08-09	CPST	ETF	3.34	3.34	2.81	3.09	5120336.0
2005-08-09	CSB	ETF	31.44	31.8	31.4	31.52	7500.0
2005-08-09	CSM	ETF	2.42	2.42	2.42	2.42	800.0
2005-08-09	CSQ	ETF	14.15	14.24	14.03	14.23	323700.0
2005-08-09	CTEC	ETF	56.55	56.9	55.849999999999994	56.349999999999994	2131.6
2005-08-09	CURE	ETF	0.3862	0.4475	0.3817	0.435	3576336.0
2005-08-09	CYA	ETF	89.0	89.0	68.0	77.4	3460.0
2005-08-09	CYB	ETF	3.61	3.62	3.61	3.62	3100.0
2005-08-09	DGT	ETF	65.14	65.14	64.92	64.99	5700.0
2005-08-09	DIG	ETF	12.8125	12.8125	12.8	12.8	400.0
2005-08-09	DIV	ETF	13.57	13.7	13.51	13.61	12800.0
2005-08-09	DRIV	ETF	36.28	36.76	36.0	36.35	493065.0
2005-08-09	DSI	ETF	5.795	5.795	5.79	5.79	2800.0

> showing 50 of 279 rows — these rows as CSV

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