PREVIEW / etf_daily / 2008-07-18

all etf daily files

  file:    by_date/etf_daily/2008/2008-07-18.parquet
  size:    27 KB
  rows:    606

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-07-18	SPY	ETF	126.17	126.42	125.15	125.98	267030100.0
2008-07-18	QQQ	ETF	45.17	45.17	44.59	44.59	160660977.0
2008-07-18	IWM	ETF	69.76	69.85	68.53	68.88	99585800.0
2008-07-18	DIA	ETF	114.6	115.1	113.7	114.95	21164900.0
2008-07-18	GLD	ETF	94.22	94.93	94.02	94.17	8585100.0
2008-07-18	TLT	ETF	90.76	91.2	90.3	90.45	3475200.0
2008-07-18	ACWI	ETF	50.61	50.61	47.53	47.94	6000.0
2008-07-18	ACWX	ETF	48.81	48.9	48.69	48.82	5849.0
2008-07-18	ADRE	ETF	47.73	48.27	47.52	47.84	886475.0
2008-07-18	AFK	ETF	41.5	41.5	40.0	41.0	8060.0
2008-07-18	AGG	ETF	99.34	99.68	98.98	98.98	438400.0
2008-07-18	AIA	ETF	40.0001	42.0	40.0	40.45	61321.0
2008-07-18	AIQ	ETF	43.2	43.5	42.8	43.3	20620.0
2008-07-18	AIS	ETF	0.69	0.7	0.64	0.7	57958.0
2008-07-18	AIVI	ETF	59.82	60.14	59.58	60.08	24500.0
2008-07-18	ARB	ETF	46.68	47.79	46.27	47.72	289411.0
2008-07-18	BAL	ETF	45.216	45.67	45.216	45.67	2100.0
2008-07-18	BBH	ETF	60.7133	60.7133	59.1667	59.55	1025700.0
2008-07-18	BIL	ETF	91.8	91.88	91.76	91.84	71950.0
2008-07-18	BITS	ETF	23.88	23.96	22.4	23.64	4650.0
2008-07-18	BIV	ETF	75.91	76.04	75.5	75.65	59400.0
2008-07-18	BJK	ETF	30.93	30.93	29.7	30.06	1800.0
2008-07-18	BKF	ETF	50.36	50.36	49.1	49.19	51023.0
2008-07-18	BLV	ETF	73.49	73.49	73.01	73.14	5200.0
2008-07-18	BMVP	ETF	14.65	14.8	14.65	14.79	49494.0
2008-07-18	BND	ETF	75.51	75.65	75.15	75.29	110400.0
2008-07-18	BNE	ETF	11.95	12.01	11.6	11.72	95956.0
2008-07-18	BRF	ETF	14.72	14.72	14.72	14.72	3700.0
2008-07-18	BSV	ETF	77.14	77.22	76.85	76.99	99100.0
2008-07-18	BTF	ETF	82.6	85.2505	81.64999999999999	85.2505	16882.8
2008-07-18	BWX	ETF	28.0	28.0	27.775	27.78	171852.0
2008-07-18	CBON	ETF	3.75	3.77	3.51	3.73	189994.0
2008-07-18	CDL	ETF	0.77	0.92	0.7401	0.8	1353036.0
2008-07-18	CEF	ETF	13.37	13.41	13.12	13.27	651800.0
2008-07-18	CGO	ETF	15.07	15.07	14.8	15.01	21171.0
2008-07-18	CGW	ETF	22.9	23.0	22.6301	22.97	27120.0
2008-07-18	CHB	ETF	3.45	3.45	2.88	2.93	5192128.0
2008-07-18	CHI	ETF	13.3	13.61	13.24	13.31	227913.0
2008-07-18	CHIC	ETF	17.58	17.62	16.51	16.89	361059.0
2008-07-18	CHW	ETF	10.9	10.9	10.68	10.84	94960.0
2008-07-18	CHY	ETF	12.29	12.65	12.27	12.51	196410.0
2008-07-18	CMF	ETF	51.595	51.595	51.3625	51.455	21856.0
2008-07-18	CN	ETF	62.04	62.83	61.6	62.55	428187.0
2008-07-18	COW	ETF	42.99	43.495	42.97	43.19	317872.0
2008-07-18	CPST	ETF	3.65	3.7	3.46	3.56	3952691.0
2008-07-18	CSA	ETF	18.28	18.49	18.04	18.2	32742.0
2008-07-18	CSB	ETF	17.05	19.43	16.2	16.81	57140.0
2008-07-18	CSD	ETF	20.84	20.85	20.82	20.85	4100.0
2008-07-18	CSQ	ETF	10.7	10.82	10.6536	10.75	318320.0
2008-07-18	CUT	ETF	18.22	18.42	18.22	18.25	5000.0

> showing 50 of 606 rows — these rows as CSV

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