PREVIEW / etf_daily / 2008-01-29

all etf daily files

  file:    by_date/etf_daily/2008/2008-01-29.parquet
  size:    25 KB
  rows:    564

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
2008-01-29	SPY	ETF	136.1	136.45	134.88	135.91	168968300.0
2008-01-29	QQQ	ETF	44.56	44.68	44.04	44.41	138519982.0
2008-01-29	IWM	ETF	70.39	70.39	69.12	70.1	75340700.0
2008-01-29	DIA	ETF	124.25	124.9	123.34	124.54	15255000.0
2008-01-29	GLD	ETF	91.36	91.72	90.81	91.15	9091600.0
2008-01-29	TLT	ETF	95.28	95.32	94.58	94.94	3100200.0
2008-01-29	ADRE	ETF	49.86	49.937	49.15	49.7	228871.0
2008-01-29	AGG	ETF	103.15	103.23	102.83	102.9	450900.0
2008-01-29	AIA	ETF	43.47	43.57	43.2	43.35	16000.0
2008-01-29	AIQ	ETF	51.85	52.0	50.1	51.4	33151.0
2008-01-29	AIS	ETF	1.0	1.02	0.95	1.01	74100.0
2008-01-29	AIVI	ETF	64.58	64.98	64.04	64.91	58800.0
2008-01-29	ARB	ETF	41.46	41.46	39.59	40.13	437800.0
2008-01-29	BBH	ETF	53.7333	54.3333	53.6767	54.22	410100.0
2008-01-29	BIL	ETF	91.82	91.92	91.78	91.9	66650.0
2008-01-29	BITS	ETF	23.48	23.52	23.0	23.12	5970.0
2008-01-29	BIV	ETF	79.4	79.42	79.09	79.19	63000.0
2008-01-29	BJK	ETF	41.99	41.99	41.85	41.95	6400.0
2008-01-29	BKF	ETF	52.01	52.23	51.4	51.77	77700.0
2008-01-29	BLV	ETF	77.98	78.0	77.64	77.86	7500.0
2008-01-29	BMVP	ETF	15.8567	15.9113	15.7483	15.87	48721.0
2008-01-29	BND	ETF	78.05	78.32	78.04	78.26	107600.0
2008-01-29	BNE	ETF	12.93	13.04	12.49	12.91	254800.0
2008-01-29	BRF	ETF	14.62	14.66	14.599	14.66	31500.0
2008-01-29	BSV	ETF	78.53	78.57	78.37	78.56	118400.0
2008-01-29	BTF	ETF	107.3	108.24999999999999	107.24999999999999	108.0	1880.0
2008-01-29	BWX	ETF	27.415	27.415	27.275	27.385	79600.0
2008-01-29	CBON	ETF	15.65	15.78	14.3	15.32	147076.0
2008-01-29	CDL	ETF	1.75	1.78	1.66	1.67	1410382.0
2008-01-29	CEF	ETF	12.24	12.24	11.91	12.01	755800.0
2008-01-29	CGO	ETF	17.25	17.45	17.25	17.25	11456.0
2008-01-29	CGW	ETF	23.5	23.5	23.0	23.36	67901.0
2008-01-29	CHB	ETF	9.75	10.31	9.25	10.13	1977196.0
2008-01-29	CHI	ETF	16.0	16.12	15.5	15.8	131486.0
2008-01-29	CHIC	ETF	16.64	16.94	16.4	16.79	474514.0
2008-01-29	CHW	ETF	12.2	12.5	12.07	12.42	174948.0
2008-01-29	CHY	ETF	14.25	14.36	13.9672	14.12	168457.0
2008-01-29	CMF	ETF	52.98	53.01	52.83	52.95	24200.0
2008-01-29	CN	ETF	63.6	64.65	63.26	64.37	302231.0
2008-01-29	CNXT	ETF	0.65	0.69	0.6313	0.67	4177220.0
2008-01-29	COW	ETF	45.6	46.4	45.55	46.27	55400.0
2008-01-29	CPST	ETF	1.64	1.66	1.51	1.53	2987206.0
2008-01-29	CSA	ETF	16.39	16.5	16.05	16.38	135100.0
2008-01-29	CSD	ETF	24.72	24.72	24.4	24.72	14300.0
2008-01-29	CSQ	ETF	13.45	13.61	13.4	13.58	262044.0
2008-01-29	CUT	ETF	21.45	21.49	21.2	21.49	18400.0
2008-01-29	CVY	ETF	23.44	23.44	22.92	23.34	17500.0
2008-01-29	CWI	ETF	24.88	25.2467	24.88	25.2	212100.0
2008-01-29	DBA	ETF	37.31	37.31	36.42	36.72	1848900.0
2008-01-29	DBB	ETF	23.31	23.44	23.0	23.43	39900.0

> showing 50 of 564 rows — these rows as CSV

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