PREVIEW / etf_daily / 2008-10-06

all etf daily files

  file:    by_date/etf_daily/2008/2008-10-06.parquet
  size:    27 KB
  rows:    618

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-06	SPY	ETF	107.15	107.62	100.64	104.72	610637500.0
2008-10-06	QQQ	ETF	35.26	35.53	32.91	34.86	394158016.0
2008-10-06	IWM	ETF	60.56	60.72	56.38	59.72	172301800.0
2008-10-06	DIA	ETF	100.86	101.44	95.21	99.9	49877900.0
2008-10-06	GLD	ETF	85.84	86.45	84.25	84.28	21675700.0
2008-10-06	TLT	ETF	98.74	99.86	98.62	99.17	2906200.0
2008-10-06	AAXJ	ETF	38.58	38.58	36.48	37.02	1100.0
2008-10-06	ACWI	ETF	38.05	38.05	35.45	37.0	126800.0
2008-10-06	ACWX	ETF	36.01	36.01	33.53	35.02	138383.0
2008-10-06	ADRE	ETF	30.83	31.22	28.72	30.99	1052250.0
2008-10-06	AFK	ETF	28.42	28.42	27.58	27.9	4204.0
2008-10-06	AGG	ETF	98.62	99.45	95.55	98.65	798300.0
2008-10-06	AIA	ETF	30.14	30.14	28.47	29.274	38337.0
2008-10-06	AIQ	ETF	49.1	49.5	45.35	46.1	73145.0
2008-10-06	AIS	ETF	0.62	0.68	0.6	0.66	94058.0
2008-10-06	AIVI	ETF	47.01	47.02	43.6	45.39	155800.0
2008-10-06	ARB	ETF	39.68	42.18	39.36	41.92	411553.0
2008-10-06	BAL	ETF	34.43	34.43	33.67	33.744	1100.0
2008-10-06	BBH	ETF	59.17	60.12	54.59	56.2667	929400.0
2008-10-06	BIL	ETF	92.72	92.72	91.6	91.94	324050.0
2008-10-06	BITS	ETF	20.32	20.4	16.0	20.4	19516.0
2008-10-06	BIV	ETF	74.31	74.54	73.65	73.82	37900.0
2008-10-06	BJK	ETF	21.16	21.45	19.45	19.75	1600.0
2008-10-06	BKF	ETF	27.76	29.2348	25.921	28.16	181498.0
2008-10-06	BLV	ETF	71.56	73.0	71.56	72.52	58400.0
2008-10-06	BMVP	ETF	12.42	12.42	11.58	12.14	275657.0
2008-10-06	BND	ETF	76.01	76.25	75.0	75.38	326900.0
2008-10-06	BNE	ETF	9.06	9.29	8.6	9.15	210662.0
2008-10-06	BOSS	ETF	17.5	17.5	15.75	15.75	400.0
2008-10-06	BRF	ETF	14.66	14.66	14.66	14.66	8800.0
2008-10-06	BSV	ETF	77.52	77.87	76.42	76.95	149000.0
2008-10-06	BTF	ETF	75.0	75.0	66.55	71.25	15827.400000000001
2008-10-06	BWX	ETF	25.87	26.525	25.755	26.165	208018.0
2008-10-06	CBON	ETF	6.58	6.58	5.5	5.53	60930.0
2008-10-06	CDL	ETF	0.65	0.65	0.45	0.55	889129.0
2008-10-06	CEF	ETF	10.65	10.87	10.25	10.32	2716700.0
2008-10-06	CGO	ETF	10.42	10.42	8.85	9.3	68083.0
2008-10-06	CGW	ETF	17.86	17.86	16.48	17.55	222996.0
2008-10-06	CHB	ETF	4.82	4.9	3.93	4.55	2373974.0
2008-10-06	CHI	ETF	9.5	9.7	8.33	8.91	438499.0
2008-10-06	CHIC	ETF	9.6	9.79	9.24	9.54	692494.0
2008-10-06	CHW	ETF	7.2	7.3	6.0	6.9	509887.0
2008-10-06	CHY	ETF	9.5	9.5	8.44	9.25	1217277.0
2008-10-06	CMF	ETF	49.86	50.95	49.2675	49.5	21278.0
2008-10-06	CN	ETF	35.11	38.5	35.11	38.23	477692.0
2008-10-06	CNXT	ETF	3.28	3.35	2.93	3.29	719721.0
2008-10-06	COW	ETF	38.28	38.2801	36.32	37.09	154171.0
2008-10-06	CPST	ETF	1.25	1.27	1.15	1.18	4132763.0
2008-10-06	CSA	ETF	15.32	15.64	14.62	14.76	177072.0
2008-10-06	CSB	ETF	13.15	13.7	12.25	13.0	29772.0

> showing 50 of 618 rows — these rows as CSV

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