PREVIEW / etf_daily / 2008-03-19

all etf daily files

  file:    by_date/etf_daily/2008/2008-03-19.parquet
  size:    26 KB
  rows:    572

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-19	SPY	ETF	134.14	134.65	130.04	130.32	345971600.0
2008-03-19	QQQ	ETF	43.51	43.6	42.23	42.26	216157167.0
2008-03-19	IWM	ETF	68.59	68.93	66.25	66.35	132792600.0
2008-03-19	DIA	ETF	124.48	124.82	121.02	121.44	17636700.0
2008-03-19	GLD	ETF	95.65	96.0	92.5	93.04	37594300.0
2008-03-19	TLT	ETF	95.12	97.47	95.12	96.94	5206400.0
2008-03-19	ADRE	ETF	48.38	49.16	46.19	46.28	491220.0
2008-03-19	AGG	ETF	102.77	103.37	102.73	103.06	403300.0
2008-03-19	AIA	ETF	42.31	42.31	40.1	40.1	6700.0
2008-03-19	AIQ	ETF	42.75	43.0	42.4	42.45	42680.0
2008-03-19	AIS	ETF	0.9	0.96	0.9	0.9199	92313.0
2008-03-19	AIVI	ETF	62.22	62.56	60.31	60.31	21400.0
2008-03-19	ARB	ETF	43.2	43.55	42.05	42.06	424500.0
2008-03-19	BBH	ETF	55.7733	56.2933	55.24	55.31	270000.0
2008-03-19	BIL	ETF	91.96	91.96	91.88	91.96	31850.0
2008-03-19	BITS	ETF	20.36	22.72	19.96	20.6	64759.0
2008-03-19	BIV	ETF	80.73	80.73	79.16	79.69	19900.0
2008-03-19	BJK	ETF	38.9	39.0	38.9	38.95	700.0
2008-03-19	BKF	ETF	49.59	49.59	46.75	46.75	19800.0
2008-03-19	BLV	ETF	77.09	77.76	77.09	77.57	16400.0
2008-03-19	BMVP	ETF	15.65	15.66	15.275	15.275	27300.0
2008-03-19	BND	ETF	77.91	78.15	77.73	77.8	144700.0
2008-03-19	BNE	ETF	15.78	16.28	15.66	15.66	238100.0
2008-03-19	BRF	ETF	14.73	14.73	14.55	14.59	33400.0
2008-03-19	BSV	ETF	79.19	79.19	78.85	79.17	67000.0
2008-03-19	BTF	ETF	98.9	99.7	98.75	98.9	3760.0
2008-03-19	BWX	ETF	28.95	29.175	28.88	28.9	235318.0
2008-03-19	CBON	ETF	11.65	11.932	11.455	11.5	98215.0
2008-03-19	CDL	ETF	1.55	1.59	1.38	1.38	1131874.0
2008-03-19	CEF	ETF	14.05	14.05	13.11	13.27	2692000.0
2008-03-19	CGO	ETF	15.96	16.04	15.8	15.8	23800.0
2008-03-19	CGW	ETF	24.48	24.48	22.78	22.78	124875.0
2008-03-19	CHB	ETF	9.88	10.09	9.52	9.52	1521680.0
2008-03-19	CHI	ETF	13.09	13.73	13.09	13.14	184048.0
2008-03-19	CHIC	ETF	19.53	19.55	19.15	19.25	474301.0
2008-03-19	CHW	ETF	10.59	11.03	10.5818	10.73	234988.0
2008-03-19	CHY	ETF	11.77	12.35	11.77	11.95	429010.0
2008-03-19	CMF	ETF	51.495	51.805	51.495	51.805	16200.0
2008-03-19	CN	ETF	54.23	55.0	52.07	52.41	608445.0
2008-03-19	CNXT	ETF	0.42	0.4692	0.41	0.45	5196115.0
2008-03-19	COW	ETF	41.98	41.98	41.3	41.401	20300.0
2008-03-19	CPST	ETF	1.96	1.97	1.85	1.89	1658495.0
2008-03-19	CSA	ETF	15.7	15.7	15.2	15.25	40000.0
2008-03-19	CSD	ETF	23.47	23.47	22.25	22.25	9200.0
2008-03-19	CSQ	ETF	11.63	11.86	11.54	11.55	434498.0
2008-03-19	CUT	ETF	20.75	20.85	20.02	20.02	30000.0
2008-03-19	CVY	ETF	22.36	22.36	21.75	21.75	6600.0
2008-03-19	CWI	ETF	24.6867	24.6867	23.8333	23.8933	73050.0
2008-03-19	DBA	ETF	38.7	38.9	36.8	38.0	10604200.0
2008-03-19	DBB	ETF	25.05	25.05	24.56	24.58	142700.0

> showing 50 of 572 rows — these rows as CSV

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