PREVIEW / etf_daily / 2008-02-19

all etf daily files

  file:    by_date/etf_daily/2008/2008-02-19.parquet
  size:    25 KB
  rows:    563

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-02-19	SPY	ETF	136.72	136.89	134.61	135.52	145190000.0
2008-02-19	QQQ	ETF	44.39	44.5	43.27	43.74	110507578.0
2008-02-19	IWM	ETF	70.88	71.01	69.62	70.73	50724600.0
2008-02-19	DIA	ETF	124.73	124.95	122.96	123.68	9395500.0
2008-02-19	GLD	ETF	91.23	91.94	90.98	91.58	8371600.0
2008-02-19	TLT	ETF	91.14	91.7	90.64	90.95	2911600.0
2008-02-19	ADRE	ETF	52.06	52.82	51.7173	51.94	427868.0
2008-02-19	AGG	ETF	101.86	101.98	101.31	101.46	597200.0
2008-02-19	AIA	ETF	45.29	45.29	43.78	43.82	11900.0
2008-02-19	AIQ	ETF	52.25	53.2	51.633	51.95	15471.0
2008-02-19	AIS	ETF	0.95	1.01	0.95	1.0	67000.0
2008-02-19	AIVI	ETF	63.67	63.85	62.88	63.04	26200.0
2008-02-19	ARB	ETF	42.69	42.715	41.68	41.85	294500.0
2008-02-19	BBH	ETF	55.3333	55.6667	54.98	55.0733	226500.0
2008-02-19	BIL	ETF	91.74	91.78	91.7	91.76	17800.0
2008-02-19	BITS	ETF	22.16	22.6	21.6	21.64	7006.0
2008-02-19	BIV	ETF	78.28	78.28	77.75	77.85	51500.0
2008-02-19	BJK	ETF	42.87	42.9	42.75	42.9	1100.0
2008-02-19	BKF	ETF	54.67	54.69	53.5	53.53	15700.0
2008-02-19	BLV	ETF	74.72	75.61	74.72	75.12	17300.0
2008-02-19	BMVP	ETF	16.3333	16.3333	16.0353	16.06	36400.0
2008-02-19	BND	ETF	77.33	77.33	76.5	76.5	602700.0
2008-02-19	BNE	ETF	13.2	13.26	13.05	13.14	100100.0
2008-02-19	BRF	ETF	14.68	14.6801	14.68	14.68	11400.0
2008-02-19	BSV	ETF	78.49	78.59	78.22	78.23	72600.0
2008-02-19	BTF	ETF	113.24999999999999	113.35000000000001	111.9005	112.14999999999999	8720.0
2008-02-19	BWX	ETF	27.3	27.41	27.135	27.2	251492.0
2008-02-19	CBON	ETF	14.71	14.79	14.05	14.25	49364.0
2008-02-19	CDL	ETF	1.4	1.44	1.36	1.38	1377506.0
2008-02-19	CEF	ETF	12.74	12.86	12.67	12.84	539800.0
2008-02-19	CGO	ETF	16.0	16.01	15.8501	15.89	19308.0
2008-02-19	CGW	ETF	23.89	23.89	23.2301	23.306	59005.0
2008-02-19	CHB	ETF	8.27	8.56	8.16	8.37	1169340.0
2008-02-19	CHI	ETF	14.69	14.91	14.5	14.53	144175.0
2008-02-19	CHIC	ETF	18.93	19.25	18.79	19.02	447190.0
2008-02-19	CHW	ETF	11.54	11.78	11.4	11.63	209862.0
2008-02-19	CHY	ETF	13.32	13.65	13.25	13.31	208345.0
2008-02-19	CMF	ETF	52.2	52.255	51.88	51.88	18600.0
2008-02-19	CN	ETF	64.3	64.4	61.97	62.77	320396.0
2008-02-19	CNXT	ETF	0.6	0.61	0.57	0.57	2168803.0
2008-02-19	COW	ETF	45.72	45.84	45.54	45.84	26600.0
2008-02-19	CPI	ETF	19.3101	19.61	19.1	19.1	1600.0
2008-02-19	CPST	ETF	1.6	1.6	1.56	1.59	1358732.0
2008-02-19	CSA	ETF	15.39	15.43	14.94	15.1	74300.0
2008-02-19	CSD	ETF	24.04	24.04	23.75	23.77	16000.0
2008-02-19	CSQ	ETF	12.7	13.03	12.69	12.88	462298.0
2008-02-19	CUT	ETF	22.16	22.16	21.39	21.39	45200.0
2008-02-19	CVY	ETF	23.17	23.17	22.73	22.74	23600.0
2008-02-19	CWI	ETF	25.64	25.64	25.1133	25.1933	52950.0
2008-02-19	DBA	ETF	39.72	40.15	39.63	40.07	2870500.0

> showing 50 of 563 rows — these rows as CSV

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