PREVIEW / etf_daily / 2008-03-18

all etf daily files

  file:    by_date/etf_daily/2008/2008-03-18.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-18	SPY	ETF	130.62	133.69	129.98	133.63	334416600.0
2008-03-18	QQQ	ETF	42.24	43.34	42.11	43.33	216300368.0
2008-03-18	IWM	ETF	66.61	68.18	65.31	68.05	161001200.0
2008-03-18	DIA	ETF	121.81	124.25	121.2	124.05	23106900.0
2008-03-18	GLD	ETF	99.35	99.51	96.35	96.5	20966100.0
2008-03-18	TLT	ETF	95.3	96.16	94.95	95.36	4022300.0
2008-03-18	ADRE	ETF	48.0	49.35	48.0	49.35	611844.0
2008-03-18	AGG	ETF	103.03	103.32	102.55	102.75	398200.0
2008-03-18	AIA	ETF	40.06	41.53	40.06	41.53	40100.0
2008-03-18	AIQ	ETF	42.45	42.55	41.1	42.4	67140.0
2008-03-18	AIS	ETF	0.98	1.02	0.94	0.95	97230.0
2008-03-18	AIVI	ETF	61.74	62.68	61.44	62.62	27700.0
2008-03-18	ARB	ETF	43.87	43.87	42.36	42.8	547800.0
2008-03-18	BBH	ETF	56.1033	56.1033	54.78	55.9133	726900.0
2008-03-18	BIL	ETF	92.96	92.96	91.82	91.94	47400.0
2008-03-18	BITS	ETF	20.24	20.36	19.12	20.36	6780.0
2008-03-18	BIV	ETF	78.35	79.7	78.35	78.65	36400.0
2008-03-18	BJK	ETF	36.47	38.89	35.97	38.89	600.0
2008-03-18	BKF	ETF	48.3012	49.44	48.1701	49.44	14500.0
2008-03-18	BLV	ETF	77.33	77.33	76.37	76.45	4700.0
2008-03-18	BMVP	ETF	15.24	15.5533	15.24	15.55	70100.0
2008-03-18	BND	ETF	79.83	79.83	77.59	77.74	86200.0
2008-03-18	BNE	ETF	14.58	16.24	14.48	16.11	358400.0
2008-03-18	BRF	ETF	14.58	14.58	14.58	14.58	7400.0
2008-03-18	BSV	ETF	79.04	79.2	78.74	78.74	84400.0
2008-03-18	BTF	ETF	98.45	99.89999999999999	98.45	99.89999999999999	3860.0
2008-03-18	BWX	ETF	29.485	29.49	28.94	29.12	305320.0
2008-03-18	CBON	ETF	11.39	11.54	10.88	11.54	130291.0
2008-03-18	CDL	ETF	1.34	1.6	1.34	1.59	1933685.0
2008-03-18	CEF	ETF	14.93	14.93	13.89	14.0	1719200.0
2008-03-18	CGO	ETF	15.4	16.27	15.3	15.71	29800.0
2008-03-18	CGW	ETF	23.32	24.21	23.09	23.61	77883.0
2008-03-18	CHB	ETF	9.19	10.02	9.0	9.68	2643040.0
2008-03-18	CHI	ETF	12.95	13.66	12.95	13.1	224820.0
2008-03-18	CHIC	ETF	19.35	19.7125	19.23	19.42	835004.0
2008-03-18	CHW	ETF	10.75	10.78	10.42	10.59	136833.0
2008-03-18	CHY	ETF	11.73	12.28	11.44	11.85	374100.0
2008-03-18	CMF	ETF	51.775	51.965	51.625	51.625	23000.0
2008-03-18	CN	ETF	54.72	57.52	54.42	57.49	555205.0
2008-03-18	CNXT	ETF	0.4198	0.4397	0.4	0.42	4828668.0
2008-03-18	COW	ETF	41.7	42.11	41.51	42.09	27300.0
2008-03-18	CPI	ETF	18.55	18.55	18.3	18.5	12800.0
2008-03-18	CPST	ETF	1.89	2.0	1.86	1.9816	2422108.0
2008-03-18	CSA	ETF	15.35	15.74	15.27	15.68	53160.0
2008-03-18	CSD	ETF	22.15	22.69	22.13	22.65	17600.0
2008-03-18	CSQ	ETF	11.49	11.64	11.38	11.57	409839.0
2008-03-18	CUT	ETF	21.29	21.29	20.43	20.72	18900.0
2008-03-18	CVY	ETF	21.53	22.09	21.53	22.09	29600.0
2008-03-18	CWI	ETF	24.5467	24.9067	24.4467	24.9067	111450.0
2008-03-18	CZA	ETF	22.51	22.51	22.51	22.51	400.0

> showing 50 of 575 rows — these rows as CSV

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