PREVIEW / etf_daily / 2008-01-18

all etf daily files

  file:    by_date/etf_daily/2008/2008-01-18.parquet
  size:    25 KB
  rows:    557

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-18	SPY	ETF	134.74	135.02	131.1	132.06	348561500.0
2008-01-18	QQQ	ETF	45.64	46.14	44.76	45.35	273063208.0
2008-01-18	IWM	ETF	68.12	68.81	66.29	67.22	131880200.0
2008-01-18	DIA	ETF	122.33	123.28	120.12	120.57	35591900.0
2008-01-18	GLD	ETF	87.17	87.46	86.51	87.42	9094500.0
2008-01-18	TLT	ETF	95.55	95.77	95.22	95.49	2676800.0
2008-01-18	ADRE	ETF	48.66	49.55	47.69	49.0	812024.0
2008-01-18	AGG	ETF	102.96	103.25	102.8	103.25	809400.0
2008-01-18	AIA	ETF	41.74	44.1	41.74	43.59	4800.0
2008-01-18	AIQ	ETF	50.4	50.4	48.15	49.75	35546.0
2008-01-18	AIS	ETF	0.96	1.01	0.95	0.98	56500.0
2008-01-18	AIVI	ETF	66.01	66.15	64.23	65.12	111400.0
2008-01-18	ARB	ETF	40.79	41.86	40.07	40.2	365855.0
2008-01-18	BBH	ETF	55.9867	55.9867	54.8	54.8033	1743600.0
2008-01-18	BIL	ETF	91.66	91.74	91.64	91.7	71450.0
2008-01-18	BITS	ETF	21.24	22.64	21.24	22.36	12992.0
2008-01-18	BIV	ETF	79.06	79.26	79.0	79.26	35800.0
2008-01-18	BKF	ETF	53.0	53.23	51.56	52.64	49600.0
2008-01-18	BLV	ETF	77.96	78.08	77.8	77.82	4700.0
2008-01-18	BMVP	ETF	15.64	15.8613	15.4033	15.51	124057.0
2008-01-18	BND	ETF	78.01	78.41	78.01	78.28	100500.0
2008-01-18	BNE	ETF	13.05	13.105	12.51	12.57	492100.0
2008-01-18	BRF	ETF	14.64	14.64	14.61	14.63	6800.0
2008-01-18	BSV	ETF	78.27	78.35	78.08	78.35	46000.0
2008-01-18	BTF	ETF	103.0	104.0	102.5	103.0	5780.0
2008-01-18	BWX	ETF	27.36	27.36	27.1945	27.36	227000.0
2008-01-18	CBON	ETF	14.37	14.52	13.86	13.9	83599.0
2008-01-18	CDL	ETF	1.65	1.65	1.49	1.52	1959065.0
2008-01-18	CEF	ETF	11.21	11.48	11.1	11.38	853100.0
2008-01-18	CGO	ETF	17.64	17.64	17.01	17.35	33600.0
2008-01-18	CGW	ETF	22.99	23.6	22.8001	23.08	108765.0
2008-01-18	CHB	ETF	7.7	8.06	7.45	7.87	2163098.0
2008-01-18	CHI	ETF	15.17	15.17	14.86	14.91	137301.0
2008-01-18	CHIC	ETF	14.56	15.01	14.35	14.61	1052269.0
2008-01-18	CHW	ETF	12.7	12.7	11.91	12.01	180784.0
2008-01-18	CHY	ETF	13.75	13.75	13.33	13.44	154400.0
2008-01-18	CMF	ETF	53.05	53.215	52.855	53.215	19200.0
2008-01-18	CN	ETF	64.49	65.34	63.01	64.92	523329.0
2008-01-18	CNXT	ETF	0.69	0.7299	0.64	0.65	10447520.0
2008-01-18	COW	ETF	45.2	45.42	45.11	45.42	27377.0
2008-01-18	CPST	ETF	1.47	1.5181	1.4	1.41	1702374.0
2008-01-18	CSA	ETF	15.59	15.62	15.16	15.39	24800.0
2008-01-18	CSD	ETF	23.61	23.75	23.13	23.27	8100.0
2008-01-18	CSQ	ETF	13.55	13.65	13.2	13.31	322395.0
2008-01-18	CUT	ETF	22.33	22.33	20.7	20.97	32800.0
2008-01-18	CVY	ETF	21.7	21.7	21.14	21.24	19000.0
2008-01-18	CWI	ETF	25.24	25.3333	24.7933	25.1733	193200.0
2008-01-18	CZA	ETF	23.26	23.26	22.94	22.94	1000.0
2008-01-18	DBA	ETF	36.87	37.18	36.3	36.58	2464500.0
2008-01-18	DBB	ETF	22.38	22.69	22.18	22.65	68200.0

> showing 50 of 557 rows — these rows as CSV

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