PREVIEW / etf_daily / 2008-04-18

all etf daily files

  file:    by_date/etf_daily/2008/2008-04-18.parquet
  size:    26 KB
  rows:    587

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-04-18	SPY	ETF	138.94	139.56	138.26	138.48	218530600.0
2008-04-18	QQQ	ETF	46.51	46.93	46.22	46.71	133022442.0
2008-04-18	IWM	ETF	72.01	72.27	71.47	71.67	70736400.0
2008-04-18	DIA	ETF	127.96	128.83	127.76	127.86	16943700.0
2008-04-18	GLD	ETF	89.72	90.7	88.96	90.62	11390700.0
2008-04-18	TLT	ETF	92.0	92.88	91.82	92.77	2199700.0
2008-04-18	ACWI	ETF	53.28	53.28	52.2	52.6	9700.0
2008-04-18	ACWX	ETF	53.19	53.6299	53.19	53.51	3130.0
2008-04-18	ADRE	ETF	53.5	53.91	53.24	53.63	344249.0
2008-04-18	AGG	ETF	101.4	102.02	101.18	102.0	620000.0
2008-04-18	AIA	ETF	46.76	46.76	46.271	46.45	19932.0
2008-04-18	AIQ	ETF	40.5	40.95	39.5	40.75	20003.0
2008-04-18	AIS	ETF	0.9	0.93	0.88	0.92	29080.0
2008-04-18	AIVI	ETF	66.92	67.39	66.81	67.19	27000.0
2008-04-18	ARB	ETF	45.67	46.41	45.46	46.32	271600.0
2008-04-18	BBH	ETF	57.1933	57.6633	56.25	56.3033	198300.0
2008-04-18	BIL	ETF	91.78	91.78	91.66	91.68	31800.0
2008-04-18	BITS	ETF	23.44	25.0	23.44	24.72	6708.0
2008-04-18	BIV	ETF	78.0	78.3	77.57	78.2	18200.0
2008-04-18	BJK	ETF	37.11	37.77	37.11	37.66	500.0
2008-04-18	BKF	ETF	54.63	54.84	54.06	54.69	57546.0
2008-04-18	BLV	ETF	75.86	75.86	74.86	75.75	73400.0
2008-04-18	BMVP	ETF	16.03	16.03	15.88	15.88	42394.0
2008-04-18	BND	ETF	76.77	77.06	76.45	76.93	253000.0
2008-04-18	BNE	ETF	17.04	17.22	16.8	16.93	271046.0
2008-04-18	BRF	ETF	14.68	14.71	14.68	14.71	2400.0
2008-04-18	BSV	ETF	78.11	78.17	77.83	78.16	58900.0
2008-04-18	BTF	ETF	103.49999999999999	104.0	103.35000000000001	103.64999999999999	3992.0
2008-04-18	BWX	ETF	28.5	28.56	28.275	28.41	413794.0
2008-04-18	CBON	ETF	12.44	12.8	12.04	12.15	55504.0
2008-04-18	CDL	ETF	1.4	1.43	1.32	1.34	1467449.0
2008-04-18	CEF	ETF	12.92	13.0	12.68	12.88	827900.0
2008-04-18	CGO	ETF	16.44	16.67	16.33	16.41	38153.0
2008-04-18	CGW	ETF	24.58	24.58	23.4	24.47	40637.0
2008-04-18	CHB	ETF	10.55	10.85	10.2	10.37	1166817.0
2008-04-18	CHI	ETF	14.4	14.75	14.36	14.58	98817.0
2008-04-18	CHIC	ETF	16.19	16.95	16.12	16.85	420463.0
2008-04-18	CHW	ETF	11.81	12.07	11.7	11.77	247381.0
2008-04-18	CHY	ETF	13.59	13.68	13.36	13.55	146058.0
2008-04-18	CMF	ETF	52.915	52.915	51.81	52.46	87558.0
2008-04-18	CN	ETF	59.11	59.79	58.65	59.31	248453.0
2008-04-18	CNXT	ETF	0.49	0.52	0.48	0.52	2958418.0
2008-04-18	COW	ETF	43.03	43.19	42.8	43.17	147019.0
2008-04-18	CPI	ETF	17.974	18.15	17.974	18.15	400.0
2008-04-18	CPST	ETF	3.02	3.02	2.87	2.91	5511417.0
2008-04-18	CSA	ETF	16.64	16.86	16.52	16.59	22800.0
2008-04-18	CSB	ETF	22.7799	24.65	22.4799	23.0	175200.0
2008-04-18	CSD	ETF	23.79	23.89	23.78	23.78	1800.0
2008-04-18	CSQ	ETF	12.24	12.48	12.24	12.4	383433.0
2008-04-18	CUT	ETF	22.21	22.21	21.79	21.95	32100.0

> showing 50 of 587 rows — these rows as CSV

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