PREVIEW / etf_daily / 2008-03-06

all etf daily files

  file:    by_date/etf_daily/2008/2008-03-06.parquet
  size:    26 KB
  rows:    571

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-06	SPY	ETF	132.98	133.22	130.55	131.06	247911700.0
2008-03-06	QQQ	ETF	43.09	43.27	42.1	42.17	152752159.0
2008-03-06	IWM	ETF	67.91	68.18	65.93	66.17	104781300.0
2008-03-06	DIA	ETF	122.2	122.39	120.31	120.8	13426700.0
2008-03-06	GLD	ETF	96.98	97.29	95.26	96.5	18543500.0
2008-03-06	TLT	ETF	91.82	92.44	91.67	92.11	1342600.0
2008-03-06	ADRE	ETF	52.25	52.25	50.47	50.49	590431.0
2008-03-06	AGG	ETF	101.56	101.71	101.27	101.29	1161200.0
2008-03-06	AIA	ETF	43.3	43.37	42.51	42.8301	1700.0
2008-03-06	AIQ	ETF	48.4	48.8	47.75	47.95	56060.0
2008-03-06	AIS	ETF	1.02	1.02	0.95	1.02	116800.0
2008-03-06	AIVI	ETF	62.55	62.61	61.37	61.41	88800.0
2008-03-06	ARB	ETF	41.8	43.0	41.7	41.92	292300.0
2008-03-06	BBH	ETF	57.4867	57.9767	56.5933	56.6567	172500.0
2008-03-06	BIL	ETF	91.74	91.78	91.7	91.74	41600.0
2008-03-06	BITS	ETF	20.664	20.96	20.664	20.76	1988.0
2008-03-06	BIV	ETF	78.45	78.76	78.39	78.56	48400.0
2008-03-06	BJK	ETF	40.85	40.85	40.73	40.73	400.0
2008-03-06	BKF	ETF	53.25	53.25	51.35	51.35	22300.0
2008-03-06	BLV	ETF	75.4	75.62	75.19	75.41	47400.0
2008-03-06	BMVP	ETF	15.72	15.72	15.42	15.42	55800.0
2008-03-06	BND	ETF	76.95	76.96	76.67	76.71	187600.0
2008-03-06	BNE	ETF	13.03	13.36	12.95	13.04	190100.0
2008-03-06	BRF	ETF	14.68	14.68	14.61	14.61	13650.0
2008-03-06	BSV	ETF	78.85	78.92	78.7	78.76	109200.0
2008-03-06	BTF	ETF	104.25	104.25	103.05	103.35000000000001	1460.0
2008-03-06	BWX	ETF	28.255	28.43	28.255	28.42	369498.0
2008-03-06	CBON	ETF	11.53	11.54	11.01	11.21	69678.0
2008-03-06	CDL	ETF	1.4	1.45	1.35	1.35	1165839.0
2008-03-06	CEF	ETF	14.06	14.06	13.7	13.88	1049800.0
2008-03-06	CGO	ETF	16.25	16.25	15.87	16.06	18200.0
2008-03-06	CGW	ETF	23.7	23.94	23.29	23.48	49500.0
2008-03-06	CHB	ETF	8.46	8.6	8.05	8.14	2274997.0
2008-03-06	CHI	ETF	14.37	14.37	14.25	14.35	108550.0
2008-03-06	CHIC	ETF	19.67	19.86	19.1	19.17	520066.0
2008-03-06	CHW	ETF	11.47	11.5	11.3	11.3	124449.0
2008-03-06	CHY	ETF	13.34	13.34	13.13	13.3	183700.0
2008-03-06	CMF	ETF	51.165	51.45	51.105	51.34	46640.0
2008-03-06	CN	ETF	61.57	62.2399	59.91	59.92	351606.0
2008-03-06	CNXT	ETF	0.5	0.5099	0.461	0.461	2099847.0
2008-03-06	COW	ETF	42.98	43.21	42.68	42.75	71400.0
2008-03-06	CPI	ETF	19.1	19.1	19.0	19.0	600.0
2008-03-06	CPST	ETF	2.1	2.28	2.06	2.17	11147342.0
2008-03-06	CSA	ETF	15.88	15.94	14.93	15.09	62100.0
2008-03-06	CSD	ETF	22.79	22.79	22.33	22.35	66600.0
2008-03-06	CSQ	ETF	12.01	12.1199	11.88	11.91	308395.0
2008-03-06	CUT	ETF	21.8	21.8	21.25	21.27	50900.0
2008-03-06	CVY	ETF	22.06	22.06	21.69	21.72	26600.0
2008-03-06	CWI	ETF	25.28	25.28	24.8067	24.8067	44850.0
2008-03-06	DBA	ETF	42.37	42.68	40.61	41.44	3968400.0

> showing 50 of 571 rows — these rows as CSV

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