PREVIEW / etf_daily / 2008-01-02

all etf daily files

  file:    by_date/etf_daily/2008/2008-01-02.parquet
  size:    25 KB
  rows:    565

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-02	SPY	ETF	146.53	146.99	143.88	144.93	204935600.0
2008-01-02	QQQ	ETF	51.27	51.47	50.13	50.45	152344477.0
2008-01-02	IWM	ETF	76.15	76.5	74.59	75.16	94259600.0
2008-01-02	DIA	ETF	132.47	132.67	129.82	130.63	14811000.0
2008-01-02	GLD	ETF	83.56	85.14	83.44	84.86	12291100.0
2008-01-02	TLT	ETF	93.25	94.73	93.2	94.38	2959600.0
2008-01-02	ADRE	ETF	55.41	55.43	53.51	54.47	783632.0
2008-01-02	AGG	ETF	101.36	102.61	101.06	101.65	888900.0
2008-01-02	AIA	ETF	48.0	48.0	46.5799	46.88	14700.0
2008-01-02	AIQ	ETF	47.8	47.8	45.95	46.3	38980.0
2008-01-02	AIS	ETF	0.94	1.0	0.94	0.96	55400.0
2008-01-02	AIVI	ETF	70.54	70.73	69.83	70.11	68500.0
2008-01-02	ARB	ETF	41.47	41.47	40.14	40.54	364300.0
2008-01-02	BBH	ETF	54.1533	54.4033	53.13	53.87	708300.0
2008-01-02	BIL	ETF	91.64	91.66	91.58	91.66	29450.0
2008-01-02	BITS	ETF	25.72	25.84	24.48	24.8	9254.0
2008-01-02	BIV	ETF	78.97	78.97	77.42	77.99	63600.0
2008-01-02	BKF	ETF	59.87	59.87	58.7	58.91	22800.0
2008-01-02	BLV	ETF	76.89	77.63	76.89	77.56	31600.0
2008-01-02	BMVP	ETF	17.22	17.3433	17.0033	17.09	67514.0
2008-01-02	BND	ETF	78.26	78.26	76.91	77.36	2723300.0
2008-01-02	BNE	ETF	17.57	17.57	16.7	16.96	199500.0
2008-01-02	BRF	ETF	14.72	14.73	14.62	14.67	2400.0
2008-01-02	BSV	ETF	77.15	77.4	77.12	77.39	24200.0
2008-01-02	BTF	ETF	109.8	110.55	109.25	109.25	3040.0
2008-01-02	BWX	ETF	26.825	27.085	26.825	27.065	144018.0
2008-01-02	CBON	ETF	17.43	17.64	16.13	16.39	81158.0
2008-01-02	CDL	ETF	2.08	2.15	2.04	2.06	1546528.0
2008-01-02	CEF	ETF	10.91	11.14	10.87	11.09	558700.0
2008-01-02	CGO	ETF	19.01	19.48	19.01	19.46	15500.0
2008-01-02	CGW	ETF	25.9001	26.1	25.46	25.6	312751.0
2008-01-02	CHB	ETF	9.37	9.51	8.8	8.85	1063685.0
2008-01-02	CHI	ETF	14.56	14.83	14.35	14.82	134600.0
2008-01-02	CHIC	ETF	16.24	16.37	15.22	15.38	708925.0
2008-01-02	CHW	ETF	12.7	12.85	12.51	12.82	144305.0
2008-01-02	CHY	ETF	13.25	13.44	13.0236	13.38	208005.0
2008-01-02	CMF	ETF	52.165	52.18	51.9	52.165	20400.0
2008-01-02	CN	ETF	60.42	60.58	58.42	59.06	217951.0
2008-01-02	CNXT	ETF	0.84	0.84	0.79	0.81	3843193.0
2008-01-02	COW	ETF	47.49	47.49	47.07	47.31	4800.0
2008-01-02	CPI	ETF	23.5	23.5	22.75	23.0	1600.0
2008-01-02	CPST	ETF	1.63	1.69	1.59	1.63	1797413.0
2008-01-02	CSA	ETF	15.99	16.04	15.72	16.04	22700.0
2008-01-02	CSD	ETF	26.74	26.74	26.29	26.36	8400.0
2008-01-02	CSQ	ETF	14.0	14.15	13.7	13.83	329605.0
2008-01-02	CUT	ETF	24.28	24.3	23.99	24.0	11400.0
2008-01-02	CVY	ETF	23.42	23.42	23.09	23.14	12000.0
2008-01-02	CWI	ETF	27.6867	27.6867	27.2267	27.3867	52800.0
2008-01-02	CZA	ETF	25.65	25.65	25.65	25.65	300.0
2008-01-02	DBA	ETF	33.14	33.59	33.04	33.43	1078600.0

> showing 50 of 565 rows — these rows as CSV

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