PREVIEW / etf_daily / 2008-09-26

all etf daily files

  file:    by_date/etf_daily/2008/2008-09-26.parquet
  size:    27 KB
  rows:    610

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-09-26	SPY	ETF	118.83	121.5	118.51	120.85	285917400.0
2008-09-26	QQQ	ETF	40.3	41.4902	40.22	41.08	182678550.0
2008-09-26	IWM	ETF	69.01	70.69	68.79	70.63	94646800.0
2008-09-26	DIA	ETF	108.65	111.6	108.47	111.15	22037400.0
2008-09-26	GLD	ETF	87.03	90.17	86.59	86.64	21980100.0
2008-09-26	TLT	ETF	94.07	94.79	94.07	94.5	1992800.0
2008-09-26	AAXJ	ETF	43.35	43.67	42.96	43.44	3600.0
2008-09-26	ACWI	ETF	43.6	43.94	43.18	43.94	103900.0
2008-09-26	ACWX	ETF	42.29	44.7	42.054	42.55	286440.0
2008-09-26	ADRE	ETF	38.85	39.4	38.75	39.36	153372.0
2008-09-26	AFK	ETF	33.74	34.28	33.74	34.28	1464.0
2008-09-26	AGG	ETF	98.66	99.3	98.15	98.71	473200.0
2008-09-26	AIA	ETF	34.58	35.11	34.58	34.83	15580.0
2008-09-26	AIQ	ETF	54.2	55.0	53.25	54.2	27816.0
2008-09-26	AIS	ETF	0.72	0.74	0.7	0.73	50645.0
2008-09-26	AIVI	ETF	54.22	54.92	54.22	54.8	17000.0
2008-09-26	ARB	ETF	47.06	47.83	46.75	47.17	238943.0
2008-09-26	BBH	ETF	61.9633	63.21	61.36	62.8167	167700.0
2008-09-26	BIL	ETF	92.06	92.26	91.84	92.08	185700.0
2008-09-26	BITS	ETF	21.64	22.44	21.0	22.44	3470.0
2008-09-26	BIV	ETF	74.79	75.35	74.29	74.68	91300.0
2008-09-26	BJK	ETF	26.0	26.0	24.5	24.5	2000.0
2008-09-26	BKF	ETF	37.35	37.35	36.53	37.1899	126824.0
2008-09-26	BLV	ETF	71.68	72.54	71.6	71.68	17400.0
2008-09-26	BMVP	ETF	13.49	14.07	13.33	14.07	32351.0
2008-09-26	BND	ETF	76.6	76.62	76.11	76.12	319500.0
2008-09-26	BNE	ETF	11.57	12.1	11.32	11.98	107196.0
2008-09-26	BRF	ETF	14.73	14.74	14.67	14.67	14004.0
2008-09-26	BSV	ETF	78.68	78.68	77.19	77.52	178000.0
2008-09-26	BTF	ETF	79.5	79.5	76.99499999999999	78.8	5344.0
2008-09-26	BWX	ETF	26.43	27.025	26.43	26.62	319138.0
2008-09-26	CBON	ETF	6.81	7.1	6.8	7.07	50967.0
2008-09-26	CDL	ETF	0.86	0.87	0.75	0.82	462222.0
2008-09-26	CEF	ETF	11.34	11.44	11.01	11.11	1720800.0
2008-09-26	CGO	ETF	11.9	11.9	11.41	11.63	39289.0
2008-09-26	CGW	ETF	21.01	21.04	20.7	21.04	40449.0
2008-09-26	CHB	ETF	5.97	6.25	5.74	6.25	885046.0
2008-09-26	CHI	ETF	10.7	11.69	10.47	11.66	368629.0
2008-09-26	CHIC	ETF	11.17	11.47	11.17	11.44	324861.0
2008-09-26	CHW	ETF	8.55	8.62	8.1	8.62	237121.0
2008-09-26	CHY	ETF	9.77	10.48	9.76	10.42	294507.0
2008-09-26	CMF	ETF	50.315	50.57	50.25	50.25	7298.0
2008-09-26	CN	ETF	43.81	44.98	43.81	44.66	179799.0
2008-09-26	CNXT	ETF	3.25	3.29	3.12	3.27	429008.0
2008-09-26	COW	ETF	40.74	41.01	40.58	40.7	136719.0
2008-09-26	CPST	ETF	1.32	1.33	1.17	1.21	3799684.0
2008-09-26	CSA	ETF	17.1	18.0	16.27	17.67	173978.0
2008-09-26	CSB	ETF	15.65	16.22	14.45	16.05	41297.0
2008-09-26	CSD	ETF	18.65	18.87	18.65	18.87	3500.0
2008-09-26	CSQ	ETF	8.87	9.32	8.72	9.2	562725.0

> showing 50 of 610 rows — these rows as CSV

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