PREVIEW / etf_daily / 2008-01-04

all etf daily files

  file:    by_date/etf_daily/2008/2008-01-04.parquet
  size:    25 KB
  rows:    561

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-04	SPY	ETF	143.34	143.44	140.91	141.31	232330900.0
2008-01-04	QQQ	ETF	49.79	49.83	48.21	48.4	212658574.0
2008-01-04	IWM	ETF	73.24	73.33	71.61	72.09	123498600.0
2008-01-04	DIA	ETF	129.57	129.73	127.82	128.17	15022600.0
2008-01-04	GLD	ETF	85.34	85.55	84.43	85.13	8402200.0
2008-01-04	TLT	ETF	94.5	94.79	94.2	94.27	2420200.0
2008-01-04	ADRE	ETF	54.0	54.0001	52.45	52.74	617226.0
2008-01-04	AGG	ETF	101.81	102.37	101.81	102.13	497700.0
2008-01-04	AIA	ETF	46.96	47.0	45.648	45.89	12900.0
2008-01-04	AIQ	ETF	46.2	47.4	46.05	46.95	52140.0
2008-01-04	AIS	ETF	1.01	1.01	0.9	0.96	102676.0
2008-01-04	AIVI	ETF	69.91	69.92	68.3	68.38	128900.0
2008-01-04	ARB	ETF	40.23	40.23	39.21	39.43	457600.0
2008-01-04	BBH	ETF	53.69	54.0367	53.0333	53.0333	686100.0
2008-01-04	BIL	ETF	91.7	91.7	91.54	91.58	173200.0
2008-01-04	BITS	ETF	24.12	24.44	23.0	23.6	7799.0
2008-01-04	BIV	ETF	78.3	78.37	78.09	78.21	80100.0
2008-01-04	BKF	ETF	58.39	58.39	56.826	57.479	31200.0
2008-01-04	BLV	ETF	77.8	77.98	77.65	77.74	10600.0
2008-01-04	BMVP	ETF	17.03	17.03	16.71	16.76	146100.0
2008-01-04	BND	ETF	77.74	77.74	77.48	77.55	231100.0
2008-01-04	BNE	ETF	16.11	16.4	15.66	15.71	275000.0
2008-01-04	BOSS	ETF	37.36	37.68	37.36	37.68	200.0
2008-01-04	BRF	ETF	14.65	14.65	14.65	14.65	800.0
2008-01-04	BSV	ETF	77.79	77.79	77.47	77.57	47800.0
2008-01-04	BTF	ETF	109.89999999999999	110.0	108.55	109.14999999999999	2580.0
2008-01-04	BWX	ETF	27.24	27.3	27.155	27.21	154032.0
2008-01-04	CBON	ETF	14.96	15.58	14.79	15.07	103860.0
2008-01-04	CDL	ETF	1.9	1.9	1.68	1.72	1994411.0
2008-01-04	CEF	ETF	11.12	11.28	11.05	11.17	337900.0
2008-01-04	CGO	ETF	19.23	19.47	18.76	18.8799	23400.0
2008-01-04	CGW	ETF	25.85	25.85	25.2401	25.32	104106.0
2008-01-04	CHB	ETF	8.54	8.54	7.85	8.01	2238432.0
2008-01-04	CHI	ETF	15.07	15.11	14.93	15.05	238300.0
2008-01-04	CHIC	ETF	15.29	15.34	14.14	14.35	1172311.0
2008-01-04	CHW	ETF	13.05	13.05	12.71	12.758	134300.0
2008-01-04	CHY	ETF	13.52	13.8	13.48	13.64	255474.0
2008-01-04	CMF	ETF	52.72	52.72	52.72	52.72	200.0
2008-01-04	CN	ETF	60.5	60.62	58.64	59.12	307500.0
2008-01-04	CNXT	ETF	0.75	0.75	0.7	0.7	5190685.0
2008-01-04	COW	ETF	46.85	46.85	46.45	46.54	6900.0
2008-01-04	CPST	ETF	1.75	1.75	1.63	1.7	2571112.0
2008-01-04	CSA	ETF	15.66	15.75	15.45	15.59	57800.0
2008-01-04	CSD	ETF	25.94	25.94	25.06	25.06	34200.0
2008-01-04	CSQ	ETF	14.09	14.09	13.67	13.73	233393.0
2008-01-04	CUT	ETF	23.73	23.73	23.35	23.4	49800.0
2008-01-04	CVY	ETF	22.84	22.86	22.38	22.38	17400.0
2008-01-04	CWI	ETF	27.44	27.44	26.6533	26.6533	195900.0
2008-01-04	CZA	ETF	24.99	24.99	24.99	24.99	1100.0
2008-01-04	DBA	ETF	33.84	34.66	33.72	34.58	2919700.0

> showing 50 of 561 rows — these rows as CSV

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