PREVIEW / etf_daily / 2008-03-20

all etf daily files

  file:    by_date/etf_daily/2008/2008-03-20.parquet
  size:    26 KB
  rows:    575

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-20	SPY	ETF	130.05	132.91	129.26	132.08	245320700.0
2008-03-20	QQQ	ETF	42.35	43.1	42.1	43.09	128396981.0
2008-03-20	IWM	ETF	66.45	68.1	66.39	67.48	103328000.0
2008-03-20	DIA	ETF	121.51	123.69	120.9	123.11	15866800.0
2008-03-20	GLD	ETF	90.73	91.65	89.8	89.91	28830000.0
2008-03-20	TLT	ETF	97.0	97.75	96.87	97.18	3905900.0
2008-03-20	ADRE	ETF	46.33	47.0	45.09	46.6	432356.0
2008-03-20	AGG	ETF	103.3	103.47	102.87	103.42	315600.0
2008-03-20	AIA	ETF	41.41	41.82	39.9201	40.56	4200.0
2008-03-20	AIQ	ETF	43.0	44.9	42.3	44.7	85400.0
2008-03-20	AIS	ETF	0.9	0.9199	0.8701	0.91	97828.0
2008-03-20	AIVI	ETF	60.2	61.59	59.9	61.3	25700.0
2008-03-20	ARB	ETF	42.75	42.86	42.07	42.49	692900.0
2008-03-20	BBH	ETF	55.02	56.0	54.77	55.9067	556500.0
2008-03-20	BIL	ETF	91.96	91.96	91.88	91.94	46750.0
2008-03-20	BITS	ETF	20.84	21.16	20.84	21.12	6229.0
2008-03-20	BIV	ETF	81.49	81.49	79.35	79.69	56600.0
2008-03-20	BJK	ETF	38.76	38.76	38.39	38.39	2200.0
2008-03-20	BKF	ETF	46.76	46.76	45.0	46.58	89800.0
2008-03-20	BLV	ETF	77.67	78.0	77.51	77.97	32300.0
2008-03-20	BMVP	ETF	15.2833	15.44	15.19	15.4391	45000.0
2008-03-20	BND	ETF	78.34	78.34	77.67	78.01	77400.0
2008-03-20	BNE	ETF	15.6	16.66	15.28	15.28	340000.0
2008-03-20	BRF	ETF	14.58	14.64	14.58	14.62	13000.0
2008-03-20	BSV	ETF	79.27	79.27	78.88	79.03	82400.0
2008-03-20	BTF	ETF	98.8	100.12299999999999	98.75	100.12299999999999	3240.0
2008-03-20	BWX	ETF	28.82	28.82	28.565	28.675	1116326.0
2008-03-20	CBON	ETF	11.69	12.59	11.42	12.25	334946.0
2008-03-20	CDL	ETF	1.4	1.75	1.36	1.53	3057141.0
2008-03-20	CEF	ETF	12.72	12.97	12.16	12.29	3505400.0
2008-03-20	CGO	ETF	15.62	16.15	15.6	16.15	18456.0
2008-03-20	CGW	ETF	22.67	22.88	22.35	22.88	79600.0
2008-03-20	CHB	ETF	9.59	9.97	9.23	9.62	3864446.0
2008-03-20	CHI	ETF	13.16	13.6	13.1	13.34	181500.0
2008-03-20	CHIC	ETF	19.35	19.84	19.18	19.73	691978.0
2008-03-20	CHW	ETF	10.77	11.02	10.61	10.84	178472.0
2008-03-20	CHY	ETF	12.13	12.4	11.94	12.23	229324.0
2008-03-20	CMF	ETF	51.785	52.0	51.64	52.0	8000.0
2008-03-20	CN	ETF	52.41	53.82	50.8599	53.65	466520.0
2008-03-20	CNXT	ETF	0.47	0.522	0.46	0.52	10015777.0
2008-03-20	COW	ETF	41.39	42.09	41.31	41.98	10700.0
2008-03-20	CPI	ETF	18.6	18.6	18.5	18.5	300.0
2008-03-20	CPST	ETF	1.85	1.92	1.82	1.84	1531642.0
2008-03-20	CSA	ETF	15.37	15.57	15.21	15.28	21300.0
2008-03-20	CSD	ETF	22.48	22.97	22.48	22.97	3700.0
2008-03-20	CSQ	ETF	11.46	11.9184	11.46	11.89	422561.0
2008-03-20	CUT	ETF	20.0	20.08	19.75	20.08	17000.0
2008-03-20	CVY	ETF	21.84	22.29	21.84	22.29	13900.0
2008-03-20	CWI	ETF	23.8933	24.2133	23.7	24.0667	51300.0
2008-03-20	DBA	ETF	37.29	37.29	35.83	36.05	7877100.0

> showing 50 of 575 rows — these rows as CSV

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