PREVIEW / etf_daily / 2006-09-22

all etf daily files

  file:    by_date/etf_daily/2006/2006-09-22.parquet
  size:    18 KB
  rows:    367

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
2006-09-22	SPY	ETF	131.67	131.68	131.0	131.47	65966800.0
2006-09-22	QQQ	ETF	40.15	40.16	39.7	39.87	101037130.0
2006-09-22	IWM	ETF	72.16	72.18	71.06	71.54	59289900.0
2006-09-22	DIA	ETF	115.26	115.26	114.67	115.01	5824500.0
2006-09-22	GLD	ETF	58.7	58.75	57.99	58.5	3320300.0
2006-09-22	TLT	ETF	89.32	89.7	89.32	89.68	1428600.0
2006-09-22	AAA	ETF	58.28	58.28	57.7501	58.14	8900.0
2006-09-22	ADRE	ETF	31.5	31.6044	31.25	31.37	285137.0
2006-09-22	AFK	ETF	25.1	25.11	25.01	25.04	5700.0
2006-09-22	AGG	ETF	100.13	100.24	100.05	100.06	271000.0
2006-09-22	AIQ	ETF	41.5	42.0	40.85	41.05	11100.0
2006-09-22	AIS	ETF	1.2	1.2	1.13	1.13	93000.0
2006-09-22	ARB	ETF	37.47	37.47	36.95	37.16	80600.0
2006-09-22	BAB	ETF	81.14	81.41	80.78	81.17	26500.0
2006-09-22	BBC	ETF	10.4	10.76	10.3801	10.65	116900.0
2006-09-22	BBH	ETF	59.5167	59.56	59.0633	59.4833	617700.0
2006-09-22	BITS	ETF	31.88	34.52	31.3604	34.08	121794.0
2006-09-22	BNE	ETF	14.6	14.7	14.43	14.65	173200.0
2006-09-22	BRF	ETF	14.25	14.26	14.25	14.26	4200.0
2006-09-22	BTF	ETF	94.7	94.7	94.55	94.55	480.0
2006-09-22	CBON	ETF	32.36	32.36	31.44	31.5	52223.0
2006-09-22	CDL	ETF	9.63	9.63	9.4	9.52	194400.0
2006-09-22	CEF	ETF	8.09	8.16	8.07	8.09	469200.0
2006-09-22	CEW	ETF	25.31	25.41	25.31	25.41	300.0
2006-09-22	CFO	ETF	9.72	9.72	9.72	9.72	10400.0
2006-09-22	CGO	ETF	15.14	15.27	15.12	15.21	25100.0
2006-09-22	CHB	ETF	7.01	7.16	6.96	7.01	1123600.0
2006-09-22	CHI	ETF	19.65	19.74	19.52	19.7	101500.0
2006-09-22	CHIC	ETF	25.95	26.1	25.14	25.77	575166.0
2006-09-22	CHY	ETF	16.68	16.77	16.53	16.55	140800.0
2006-09-22	CIL	ETF	25.61	25.61	25.61	25.61	400.0
2006-09-22	CIZ	ETF	21.9001	21.95	21.9001	21.95	600.0
2006-09-22	CN	ETF	35.0	35.0	34.62	34.76	39400.0
2006-09-22	CNXT	ETF	1.815	1.82	1.75	1.77	10416046.0
2006-09-22	COMB	ETF	10.0	10.0	10.0	10.0	7000.0
2006-09-22	CPI	ETF	24.15	24.26	24.15	24.26	3300.0
2006-09-22	CPST	ETF	1.26	1.34	1.24	1.26	3972503.0
2006-09-22	CSA	ETF	21.0	21.08	20.69	20.87	15700.0
2006-09-22	CSB	ETF	29.64	30.05	29.34	29.74	30300.0
2006-09-22	CSQ	ETF	14.67	14.67	14.51	14.6	363300.0
2006-09-22	CTEC	ETF	59.85	62.5	59.0	62.300000000000004	16953.2
2006-09-22	CVY	ETF	24.86	24.86	24.71	24.78	12800.0
2006-09-22	CYB	ETF	6.3	6.45	6.25	6.45	35600.0
2006-09-22	DBC	ETF	23.49	23.49	23.13	23.2	296500.0
2006-09-22	DBV	ETF	24.76	24.8	24.71	24.8	18100.0
2006-09-22	DDM	ETF	6.4225	6.4275	6.3692	6.3958	680400.0
2006-09-22	DES	ETF	17.8467	17.8633	17.71	17.8167	167700.0
2006-09-22	DEW	ETF	55.62	55.62	55.39	55.4	2300.0
2006-09-22	DFE	ETF	55.86	55.86	55.86	55.86	200.0
2006-09-22	DFJ	ETF	49.59	49.59	49.33	49.33	700.0

> showing 50 of 367 rows — these rows as CSV

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