PREVIEW / etf_daily / 2008-07-25

all etf daily files

  file:    by_date/etf_daily/2008/2008-07-25.parquet
  size:    27 KB
  rows:    607

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-25	SPY	ETF	125.89	126.49	125.17	125.48	219131000.0
2008-07-25	QQQ	ETF	44.98	45.48	44.76	45.27	111616700.0
2008-07-25	IWM	ETF	70.69	71.41	70.21	70.68	112551100.0
2008-07-25	DIA	ETF	113.89	114.36	113.15	113.17	19459200.0
2008-07-25	GLD	ETF	91.03	91.73	90.53	91.69	7599500.0
2008-07-25	TLT	ETF	90.55	90.84	90.0	90.14	3765300.0
2008-07-25	ACWI	ETF	47.75	48.01	47.7	47.74	25500.0
2008-07-25	ACWX	ETF	48.48	48.5092	48.2	48.38	17817.0
2008-07-25	ADRE	ETF	46.02	46.7	46.02	46.56	427082.0
2008-07-25	AFK	ETF	38.88	40.0	38.88	39.5	2962.0
2008-07-25	AGG	ETF	99.8	99.82	99.31	99.46	394300.0
2008-07-25	AIA	ETF	41.42	41.79	41.42	41.43	24420.0
2008-07-25	AIQ	ETF	44.85	45.3	44.25	45.15	27893.0
2008-07-25	AIS	ETF	0.62	0.7	0.62	0.68	91000.0
2008-07-25	AIVI	ETF	59.97	60.45	59.82	60.06	27400.0
2008-07-25	ARB	ETF	45.59	46.22	45.04	45.63	359100.0
2008-07-25	BAL	ETF	46.01	46.65	46.01	46.627	2401.0
2008-07-25	BBH	ETF	64.9467	65.6967	64.9167	65.6633	489000.0
2008-07-25	BIL	ETF	91.84	91.84	91.78	91.84	56100.0
2008-07-25	BITS	ETF	23.2	23.44	22.24	22.88	1825.0
2008-07-25	BIV	ETF	75.87	76.13	75.69	75.78	32800.0
2008-07-25	BJK	ETF	31.5	31.73	30.7	31.01	1400.0
2008-07-25	BKF	ETF	48.0	48.14	47.404	47.86	26695.0
2008-07-25	BLV	ETF	73.37	73.37	72.96	72.96	5600.0
2008-07-25	BMVP	ETF	14.6667	14.8537	14.6667	14.7967	24143.0
2008-07-25	BND	ETF	75.62	75.69	75.26	75.31	127300.0
2008-07-25	BNE	ETF	12.32	12.51	12.09	12.2	108128.0
2008-07-25	BRF	ETF	14.75	14.75	14.75	14.75	5629.0
2008-07-25	BSV	ETF	77.17	77.21	77.0	77.17	59700.0
2008-07-25	BTF	ETF	82.69999999999999	82.85	81.75	82.2	6540.0
2008-07-25	BWX	ETF	27.715	27.75	27.55	27.71	227674.0
2008-07-25	CBON	ETF	3.32	3.68	2.95	3.5	452247.0
2008-07-25	CDL	ETF	0.99	1.09	0.96	0.98	861977.0
2008-07-25	CEF	ETF	12.99	13.02	12.78	12.88	524500.0
2008-07-25	CGO	ETF	14.75	15.11	14.75	15.11	19765.0
2008-07-25	CGW	ETF	23.51	24.53	23.37	23.48	57593.0
2008-07-25	CHB	ETF	3.55	3.88	3.55	3.76	2790558.0
2008-07-25	CHI	ETF	13.32	13.36	13.26	13.35	93688.0
2008-07-25	CHIC	ETF	12.72	13.0	12.48	12.73	913885.0
2008-07-25	CHW	ETF	10.91	11.0	10.83	10.96	111398.0
2008-07-25	CHY	ETF	12.74	12.828	12.62	12.74	104204.0
2008-07-25	CMF	ETF	51.215	51.215	51.215	51.215	2000.0
2008-07-25	CN	ETF	57.85	58.5	57.45	58.13	217054.0
2008-07-25	COW	ETF	43.5	43.6	43.32	43.49	40122.0
2008-07-25	CPST	ETF	3.02	3.09	2.87	2.96	4339541.0
2008-07-25	CSA	ETF	18.38	18.85	18.05	18.67	29600.0
2008-07-25	CSB	ETF	18.2	18.35	18.1	18.21	25133.0
2008-07-25	CSD	ETF	20.75	20.96	20.75	20.95	7900.0
2008-07-25	CSQ	ETF	10.96	11.05	10.9436	11.0	233498.0
2008-07-25	CUT	ETF	18.55	18.55	18.3	18.32	14000.0

> showing 50 of 607 rows — these rows as CSV

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