PREVIEW / etf_daily / 2008-01-23

all etf daily files

  file:    by_date/etf_daily/2008/2008-01-23.parquet
  size:    26 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-23	SPY	ETF	127.09	134.19	126.84	133.86	511913000.0
2008-01-23	QQQ	ETF	42.54	44.15	41.61	44.02	390156448.0
2008-01-23	IWM	ETF	65.3	69.98	65.09	69.02	183099500.0
2008-01-23	DIA	ETF	117.24	122.81	116.38	122.7	42838800.0
2008-01-23	GLD	ETF	87.16	88.67	86.73	87.89	14282000.0
2008-01-23	TLT	ETF	97.98	98.16	95.88	96.29	7636600.0
2008-01-23	ADRE	ETF	45.64	48.33	44.55	48.3	969094.0
2008-01-23	AGG	ETF	104.39	104.39	103.05	103.1	911200.0
2008-01-23	AIA	ETF	43.34	43.34	40.35	42.11	7400.0
2008-01-23	AIQ	ETF	47.65	49.95	47.2	49.9	60440.0
2008-01-23	AIS	ETF	0.9	0.91	0.85	0.88	291000.0
2008-01-23	AIVI	ETF	59.75	62.14	58.5	62.11	84500.0
2008-01-23	ARB	ETF	39.25	41.87	39.2	41.41	804859.0
2008-01-23	BBH	ETF	52.63	53.35	51.6533	53.18	1105500.0
2008-01-23	BIL	ETF	91.8	91.86	91.74	91.84	89150.0
2008-01-23	BITS	ETF	20.6	21.12	20.16	20.8	7465.0
2008-01-23	BIV	ETF	80.79	80.79	79.49	79.63	124700.0
2008-01-23	BKF	ETF	47.53	50.92	47.05	50.566	84800.0
2008-01-23	BLV	ETF	79.0	79.41	78.29	78.3	33400.0
2008-01-23	BMVP	ETF	14.8867	15.5267	14.67	15.5267	160820.0
2008-01-23	BND	ETF	79.26	79.35	78.43	78.64	263500.0
2008-01-23	BNE	ETF	12.21	12.58	12.0	12.37	1120500.0
2008-01-23	BRF	ETF	14.6	14.66	14.6	14.63	12161.0
2008-01-23	BSV	ETF	79.14	79.14	78.65	78.77	188800.0
2008-01-23	BTF	ETF	99.94999999999999	104.14999999999999	99.94999999999999	104.14999999999999	4784.8
2008-01-23	BWX	ETF	27.4	27.4	27.24	27.305	169600.0
2008-01-23	CBON	ETF	14.44	15.8	14.23	15.76	83420.0
2008-01-23	CDL	ETF	1.55	1.62	1.42	1.61	1475318.0
2008-01-23	CEF	ETF	11.21	11.43	11.12	11.3	545300.0
2008-01-23	CGO	ETF	16.0	17.2	15.86	17.18	27200.0
2008-01-23	CGW	ETF	21.84	22.3699	19.25	22.05	204499.0
2008-01-23	CHB	ETF	8.05	9.52	7.99	9.1	3228093.0
2008-01-23	CHI	ETF	14.96	15.1	14.56	15.06	147445.0
2008-01-23	CHIC	ETF	14.29	16.2	14.29	15.98	1244365.0
2008-01-23	CHW	ETF	11.35	11.9	11.18	11.8999	253767.0
2008-01-23	CHY	ETF	13.43	13.65	12.85	13.54	227174.0
2008-01-23	CMF	ETF	53.72	53.72	53.0	53.0	24800.0
2008-01-23	CN	ETF	56.1	60.43	53.32	58.3	1008211.0
2008-01-23	CNXT	ETF	0.61	0.64	0.57	0.64	11029975.0
2008-01-23	COW	ETF	45.23	45.3901	44.57	44.57	6900.0
2008-01-23	CPI	ETF	21.77	21.77	21.5	21.5	3300.0
2008-01-23	CPST	ETF	1.34	1.428	1.26	1.33	2796707.0
2008-01-23	CSA	ETF	15.62	16.36	15.62	15.95	48900.0
2008-01-23	CSD	ETF	22.71	23.73	22.55	23.73	20900.0
2008-01-23	CSQ	ETF	13.09	13.32	12.75	13.18	373076.0
2008-01-23	CUT	ETF	19.6	21.07	19.59	20.3	19700.0
2008-01-23	CVY	ETF	20.8	22.46	20.8	22.39	55300.0
2008-01-23	CWI	ETF	23.76	24.3467	22.9133	24.1267	135600.0
2008-01-23	CZA	ETF	22.32	22.32	22.2	22.2	500.0
2008-01-23	DBA	ETF	35.77	35.78	34.25	34.29	3801500.0

> showing 50 of 565 rows — these rows as CSV

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