PREVIEW / etf_daily / 2008-08-01

all etf daily files

  file:    by_date/etf_daily/2008/2008-08-01.parquet
  size:    27 KB
  rows:    604

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-08-01	SPY	ETF	127.12	127.28	125.46	126.16	248690900.0
2008-08-01	QQQ	ETF	45.52	45.55	44.4	44.88	180377372.0
2008-08-01	IWM	ETF	71.44	71.76	70.32	71.41	107406700.0
2008-08-01	DIA	ETF	114.12	114.26	112.59	113.12	20547400.0
2008-08-01	GLD	ETF	89.5	90.45	89.37	89.57	10893500.0
2008-08-01	TLT	ETF	90.97	91.56	90.83	91.54	1804800.0
2008-08-01	ACWI	ETF	47.8	47.8	47.27	47.3	13900.0
2008-08-01	ACWX	ETF	48.17	59.17	47.53	47.692	24928.0
2008-08-01	ADRE	ETF	47.41	47.54	46.6	46.82	606106.0
2008-08-01	AFK	ETF	40.64	40.64	39.96	40.1	4709.0
2008-08-01	AGG	ETF	100.19	100.19	99.65	99.89	331500.0
2008-08-01	AIA	ETF	41.0	41.0	40.63	40.84	35570.0
2008-08-01	AIQ	ETF	52.15	53.25	48.9	51.55	134834.0
2008-08-01	AIS	ETF	0.79	0.84	0.79	0.84	88059.0
2008-08-01	AIVI	ETF	58.98	58.98	58.04	58.17	27300.0
2008-08-01	ARB	ETF	46.85	47.1	45.61	45.92	404948.0
2008-08-01	BAL	ETF	46.5399	46.54	44.56	44.98	9200.0
2008-08-01	BBH	ETF	66.2733	66.2733	65.03	65.4	749100.0
2008-08-01	BIL	ETF	91.72	91.72	91.66	91.7	44100.0
2008-08-01	BITS	ETF	22.6	22.6	20.96	22.24	5210.0
2008-08-01	BIV	ETF	76.25	76.25	75.89	76.16	74100.0
2008-08-01	BJK	ETF	30.75	30.75	30.15	30.15	1800.0
2008-08-01	BKF	ETF	48.83	48.83	47.79	48.12	34927.0
2008-08-01	BLV	ETF	74.39	74.39	73.63	73.84	5000.0
2008-08-01	BMVP	ETF	14.99	15.05	14.94	15.0	42678.0
2008-08-01	BND	ETF	76.12	76.12	75.6	75.8	393000.0
2008-08-01	BNE	ETF	12.96	12.98	12.29	12.34	209259.0
2008-08-01	BRF	ETF	14.72	14.76	14.72	14.76	2800.0
2008-08-01	BSV	ETF	78.9	78.9	77.14	77.21	102900.0
2008-08-01	BTF	ETF	85.0	85.0	83.75	84.1	8204.6
2008-08-01	BWX	ETF	27.69	27.855	27.445	27.8	330156.0
2008-08-01	CBON	ETF	4.84	5.05	4.41	4.5	324131.0
2008-08-01	CDL	ETF	0.84	0.97	0.81	0.8415	583331.0
2008-08-01	CEF	ETF	12.92	13.0	12.74	12.78	358000.0
2008-08-01	CGO	ETF	15.21	15.21	14.86	15.11	9952.0
2008-08-01	CGW	ETF	23.41	23.41	22.88	23.0	19306.0
2008-08-01	CHB	ETF	3.97	4.11	3.85	3.93	1839032.0
2008-08-01	CHI	ETF	13.3	13.72	13.3	13.71	90401.0
2008-08-01	CHIC	ETF	13.13	13.32	12.89	12.94	503791.0
2008-08-01	CHW	ETF	11.15	11.15	10.87	11.14	78909.0
2008-08-01	CHY	ETF	12.66	13.16	12.66	13.13	103938.0
2008-08-01	CMF	ETF	51.04	51.26	51.04	51.065	4200.0
2008-08-01	CN	ETF	62.67	62.67	61.45	62.01	187461.0
2008-08-01	CNXT	ETF	5.06	5.85	5.06	5.48	748747.0
2008-08-01	COW	ETF	43.88	44.35	43.8	44.0	66485.0
2008-08-01	CPI	ETF	22.95	23.116	22.95	23.116	300.0
2008-08-01	CPST	ETF	3.05	3.1	2.94	2.98	2859575.0
2008-08-01	CSA	ETF	18.83	18.83	18.54	18.62	47867.0
2008-08-01	CSB	ETF	19.0	19.35	18.8	19.305	18142.0
2008-08-01	CSD	ETF	21.05	21.1	21.01	21.1	9100.0

> showing 50 of 604 rows — these rows as CSV

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