PREVIEW / etf_daily / 2008-01-15

all etf daily files

  file:    by_date/etf_daily/2008/2008-01-15.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-15	SPY	ETF	139.79	141.49	137.9	138.17	239940100.0
2008-01-15	QQQ	ETF	47.38	47.52	46.35	46.55	241791958.0
2008-01-15	IWM	ETF	69.88	70.16	69.07	69.5	95261600.0
2008-01-15	DIA	ETF	126.49	126.91	124.88	125.3	19807000.0
2008-01-15	GLD	ETF	89.6	90.35	87.91	87.99	23853900.0
2008-01-15	TLT	ETF	95.16	95.63	95.07	95.61	1435300.0
2008-01-15	ADRE	ETF	52.43	52.85	50.78	51.01	524006.0
2008-01-15	AGG	ETF	102.81	102.96	102.62	102.96	361400.0
2008-01-15	AIA	ETF	46.0	46.1	44.07	44.47	17900.0
2008-01-15	AIQ	ETF	48.2	48.9	48.05	48.75	50640.0
2008-01-15	AIS	ETF	0.95	0.97	0.95	0.96	52400.0
2008-01-15	AIVI	ETF	68.18	68.31	66.81	66.9	78900.0
2008-01-15	ARB	ETF	39.79	41.44	39.67	40.96	291700.0
2008-01-15	BBH	ETF	55.27	55.92	55.27	55.5033	1224300.0
2008-01-15	BIL	ETF	91.72	91.72	91.62	91.68	26800.0
2008-01-15	BITS	ETF	21.64	22.52	20.44	21.88	13712.0
2008-01-15	BIV	ETF	78.55	78.93	78.55	78.93	38700.0
2008-01-15	BKF	ETF	57.85	57.95	55.739	56.05	42200.0
2008-01-15	BLV	ETF	77.86	77.99	77.69	77.99	9100.0
2008-01-15	BMVP	ETF	16.41	16.4567	16.2233	16.2267	51340.0
2008-01-15	BND	ETF	78.18	78.18	77.71	78.15	204800.0
2008-01-15	BNE	ETF	13.69	13.85	13.24	13.25	274600.0
2008-01-15	BRF	ETF	14.63	14.67	14.61	14.62	46000.0
2008-01-15	BSV	ETF	78.18	78.18	77.9	78.07	31000.0
2008-01-15	BTF	ETF	107.5	107.55	106.89949999999999	106.95	3540.0
2008-01-15	BWX	ETF	27.625	27.63	27.375	27.455	143158.0
2008-01-15	CBON	ETF	14.55	15.17	14.55	14.77	60694.0
2008-01-15	CDL	ETF	1.51	1.59	1.46	1.52	929080.0
2008-01-15	CEF	ETF	11.61	11.7	11.21	11.25	961800.0
2008-01-15	CGO	ETF	19.19	19.19	18.51	18.72	30133.0
2008-01-15	CGW	ETF	24.63	24.64	23.6	23.75	138468.0
2008-01-15	CHB	ETF	7.93	8.2	7.64	7.73	1398489.0
2008-01-15	CHI	ETF	15.7	15.89	15.6	15.8888	111200.0
2008-01-15	CHIC	ETF	13.8	13.97	13.32	13.35	505756.0
2008-01-15	CHW	ETF	12.95	13.04	12.72	13.0	205989.0
2008-01-15	CHY	ETF	13.92	14.1199	13.8101	14.08	257649.0
2008-01-15	CMF	ETF	53.035	53.12	52.89	53.12	18600.0
2008-01-15	CN	ETF	62.38	62.8	60.42	61.07	284700.0
2008-01-15	CNXT	ETF	0.78	0.78	0.69	0.71	5744810.0
2008-01-15	COW	ETF	45.7	45.7899	45.04	45.41	111500.0
2008-01-15	CPST	ETF	1.61	1.61	1.46	1.52	2309807.0
2008-01-15	CSA	ETF	15.6	15.85	15.47	15.84	18500.0
2008-01-15	CSD	ETF	24.37	24.41	23.99	23.99	23200.0
2008-01-15	CSQ	ETF	14.07	14.08	13.85	13.94	285400.0
2008-01-15	CUT	ETF	22.49	22.67	21.36	21.7	38600.0
2008-01-15	CVY	ETF	22.16	22.17	21.97	22.0	102100.0
2008-01-15	CWI	ETF	26.64	26.64	25.7267	25.8733	337500.0
2008-01-15	CZA	ETF	23.96	23.96	23.96	23.96	200.0
2008-01-15	DBA	ETF	36.36	36.85	36.05	36.58	1855200.0
2008-01-15	DBB	ETF	22.79	22.92	22.46	22.63	30600.0

> showing 50 of 557 rows — these rows as CSV

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