PREVIEW / etf_daily / 2008-10-17

all etf daily files

  file:    by_date/etf_daily/2008/2008-10-17.parquet
  size:    27 KB
  rows:    614

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-10-17	SPY	ETF	91.99	98.59	91.65	93.21	476649000.0
2008-10-17	QQQ	ETF	31.62	33.65	31.41	32.3	326593086.0
2008-10-17	IWM	ETF	51.55	55.45	50.72	52.2	131845100.0
2008-10-17	DIA	ETF	87.6	92.76	87.16	87.54	44024200.0
2008-10-17	GLD	ETF	77.12	80.78	75.0	77.21	15336700.0
2008-10-17	TLT	ETF	94.69	94.9	93.02	93.87	1691800.0
2008-10-17	AAXJ	ETF	32.51	35.0	32.22	33.14	152500.0
2008-10-17	ACWI	ETF	32.65	34.23	32.1	32.78	64200.0
2008-10-17	ACWX	ETF	30.04	33.29	30.03	31.04	74018.0
2008-10-17	ADRE	ETF	26.47	29.14	26.0801	27.28	770291.0
2008-10-17	AFK	ETF	25.764	25.94	25.764	25.94	454.0
2008-10-17	AGG	ETF	93.38	95.96	92.51	94.09	588500.0
2008-10-17	AIA	ETF	27.49	27.98	26.31	26.6563	80310.0
2008-10-17	AIQ	ETF	40.5	41.8	39.25	40.15	111142.0
2008-10-17	AIS	ETF	0.46	0.53	0.46	0.52	100237.0
2008-10-17	AIVI	ETF	38.26	40.61	38.26	39.66	12500.0
2008-10-17	ARB	ETF	35.69	37.55	35.47	36.17	231216.0
2008-10-17	BAL	ETF	32.69	32.8899	32.69	32.8899	200.0
2008-10-17	BBH	ETF	53.51	56.9633	53.51	55.0333	850200.0
2008-10-17	BIL	ETF	91.88	91.88	91.62	91.64	157650.0
2008-10-17	BITS	ETF	16.64	17.12	16.16	16.4	3138.0
2008-10-17	BIV	ETF	70.58	70.6	69.58	70.38	72900.0
2008-10-17	BJK	ETF	16.73	17.74	16.73	17.73	2000.0
2008-10-17	BKF	ETF	23.54	26.11	23.54	24.6001	65241.0
2008-10-17	BLV	ETF	66.9	66.95	65.79	66.5	32200.0
2008-10-17	BMVP	ETF	10.45	11.14	9.84	10.67	162814.0
2008-10-17	BND	ETF	73.14	73.82	72.51	73.74	304700.0
2008-10-17	BNE	ETF	6.98	7.28	6.0	6.34	210061.0
2008-10-17	BRF	ETF	14.69	14.75	14.69	14.75	3500.0
2008-10-17	BSV	ETF	75.49	75.49	73.51	74.22	99800.0
2008-10-17	BTF	ETF	59.4	64.74999999999999	59.1	63.699999999999996	8206.4
2008-10-17	BWX	ETF	24.965	25.45	24.94	25.16	181452.0
2008-10-17	CBON	ETF	3.74	5.17	3.55	3.57	48041.0
2008-10-17	CDL	ETF	0.2402	0.3	0.19	0.2	2941951.0
2008-10-17	CEF	ETF	9.23	9.66	9.1	9.14	1623200.0
2008-10-17	CGO	ETF	9.11	9.6	9.07	9.36	29228.0
2008-10-17	CGW	ETF	15.92	16.936	15.88	16.72	164709.0
2008-10-17	CHB	ETF	3.45	3.8	3.26	3.38	2055825.0
2008-10-17	CHI	ETF	8.5	9.0	8.41	8.93	244848.0
2008-10-17	CHIC	ETF	8.49	9.95	8.1	8.12	505866.0
2008-10-17	CHW	ETF	6.29	6.5	5.9	6.21	232117.0
2008-10-17	CHY	ETF	8.03	9.1	7.55	8.73	369954.0
2008-10-17	CMF	ETF	45.695	46.255	45.238	45.238	23268.0
2008-10-17	CNXT	ETF	2.52	2.93	2.52	2.6	442578.0
2008-10-17	COW	ETF	35.9	36.2499	35.83	36.09	128942.0
2008-10-17	CPI	ETF	22.0	22.0	22.0	22.0	500.0
2008-10-17	CPST	ETF	1.32	1.42	1.0	1.39	2771922.0
2008-10-17	CSA	ETF	12.0	13.6	11.66	13.02	187973.0
2008-10-17	CSB	ETF	15.0	15.2	14.13	15.2	28750.0
2008-10-17	CSD	ETF	12.95	14.09	12.95	13.73	29100.0

> showing 50 of 614 rows — these rows as CSV

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