PREVIEW / etf_daily / 2008-03-17

all etf daily files

  file:    by_date/etf_daily/2008/2008-03-17.parquet
  size:    26 KB
  rows:    578

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-03-17	SPY	ETF	126.57	129.26	126.07	128.3	405311100.0
2008-03-17	QQQ	ETF	41.26	42.01	41.05	41.48	193130557.0
2008-03-17	IWM	ETF	64.23	65.94	64.23	65.06	126969000.0
2008-03-17	DIA	ETF	117.68	120.96	117.65	120.09	27004300.0
2008-03-17	GLD	ETF	99.32	100.44	98.0	99.17	26505900.0
2008-03-17	TLT	ETF	95.59	96.31	95.31	95.73	3329300.0
2008-03-17	ADRE	ETF	46.7	47.74	46.08	47.05	853979.0
2008-03-17	AGG	ETF	102.42	103.26	102.14	102.99	722200.0
2008-03-17	AIA	ETF	39.96	39.96	39.37	39.93	109800.0
2008-03-17	AIQ	ETF	42.45	42.75	40.8	41.25	31500.0
2008-03-17	AIS	ETF	0.98	1.01	0.98	1.0	126700.0
2008-03-17	AIVI	ETF	59.69	60.96	59.68	60.46	31700.0
2008-03-17	ARB	ETF	41.97	43.46	41.61	42.94	332100.0
2008-03-17	BBH	ETF	55.6067	56.5867	55.22	55.44	526800.0
2008-03-17	BIL	ETF	91.82	91.94	91.74	91.84	136100.0
2008-03-17	BITS	ETF	19.44	21.08	19.12	20.08	4279.0
2008-03-17	BIV	ETF	79.71	79.71	78.95	79.38	32300.0
2008-03-17	BJK	ETF	37.74	38.55	37.71	38.31	1800.0
2008-03-17	BKF	ETF	47.0	47.51	46.27	47.42	33800.0
2008-03-17	BLV	ETF	76.54	76.81	76.17	76.63	7500.0
2008-03-17	BMVP	ETF	14.88	15.17	14.88	15.08	123300.0
2008-03-17	BND	ETF	77.63	78.06	77.0	77.67	83700.0
2008-03-17	BNE	ETF	14.37	14.45	14.08	14.13	224800.0
2008-03-17	BOSS	ETF	33.76	33.76	32.6	32.6	100.0
2008-03-17	BRF	ETF	14.55	14.58	14.55	14.58	8300.0
2008-03-17	BSV	ETF	78.89	79.2	78.89	79.09	59100.0
2008-03-17	BTF	ETF	98.0	98.14999999999999	95.05	97.69999999999999	3680.0
2008-03-17	BWX	ETF	29.4	29.495	29.01	29.17	470478.0
2008-03-17	CBON	ETF	11.45	11.45	10.92	11.1	116326.0
2008-03-17	CDL	ETF	1.41	1.43	1.32	1.32	1325521.0
2008-03-17	CEF	ETF	14.74	14.93	14.47	14.79	2196900.0
2008-03-17	CGO	ETF	15.05	15.33	14.99	15.17	48200.0
2008-03-17	CGW	ETF	23.03	23.29	22.76	23.04	158848.0
2008-03-17	CHB	ETF	8.75	9.28	8.66	8.94	1600376.0
2008-03-17	CHI	ETF	13.08	13.23	12.8	12.83	187200.0
2008-03-17	CHIC	ETF	19.28	19.51	18.9	19.11	457858.0
2008-03-17	CHW	ETF	10.2	10.508	10.07	10.29	281047.0
2008-03-17	CHY	ETF	11.83	12.0	11.52	11.59	279215.0
2008-03-17	CMF	ETF	51.53	51.875	51.53	51.875	19600.0
2008-03-17	CN	ETF	53.7	55.22	52.32	54.65	366085.0
2008-03-17	CNXT	ETF	0.437	0.437	0.378	0.4	3302654.0
2008-03-17	COW	ETF	41.73	41.86	41.2	41.45	185700.0
2008-03-17	CPI	ETF	19.0	19.1	18.55	18.59	9900.0
2008-03-17	CPST	ETF	1.9	1.95	1.79	1.87	3359096.0
2008-03-17	CSA	ETF	15.01	15.16	14.8	15.09	86700.0
2008-03-17	CSD	ETF	21.74	21.85	21.49	21.79	4600.0
2008-03-17	CSQ	ETF	11.15	11.35	11.06	11.23	521419.0
2008-03-17	CUT	ETF	20.99	20.99	20.03	20.43	18700.0
2008-03-17	CVY	ETF	21.0	21.52	21.0	21.44	21500.0
2008-03-17	CWI	ETF	23.8933	24.2867	23.7133	24.0467	55950.0

> showing 50 of 578 rows — these rows as CSV

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