PREVIEW / etf_daily / 2007-01-26

all etf daily files

  file:    by_date/etf_daily/2007/2007-01-26.parquet
  size:    20 KB
  rows:    405

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
2007-01-26	SPY	ETF	142.57	142.65	141.58	142.13	67255600.0
2007-01-26	QQQ	ETF	43.81	43.83	43.29	43.57	146289335.0
2007-01-26	IWM	ETF	77.99	78.32	77.16	78.07	56630200.0
2007-01-26	DIA	ETF	125.21	125.28	124.21	124.77	9675900.0
2007-01-26	GLD	ETF	64.16	64.31	63.76	64.17	3493900.0
2007-01-26	TLT	ETF	86.78	87.08	86.65	86.91	1576800.0
2007-01-26	AAA	ETF	60.87	60.98	60.62	60.78	3400.0
2007-01-26	ADRE	ETF	38.62	38.88	38.39	38.81	285281.0
2007-01-26	AGG	ETF	99.46	99.57	99.35	99.53	289500.0
2007-01-26	AIQ	ETF	34.15	35.0	34.1	34.95	20980.0
2007-01-26	AIS	ETF	1.18	1.2	1.15	1.18	161000.0
2007-01-26	ARB	ETF	45.29	45.67	44.92	45.54	59600.0
2007-01-26	BAB	ETF	104.59	104.73	103.49	103.72	62500.0
2007-01-26	BBC	ETF	5.0	5.05	4.9	4.9	120400.0
2007-01-26	BBH	ETF	63.8333	63.85	63.1167	63.5	1723500.0
2007-01-26	BITS	ETF	38.64	41.2	37.96	40.64	23356.0
2007-01-26	BNE	ETF	15.11	15.22	15.0	15.22	79000.0
2007-01-26	BRF	ETF	14.42	14.45	14.39	14.39	3600.0
2007-01-26	BTF	ETF	108.05	108.15950000000001	108.0	108.0	240.0
2007-01-26	CBON	ETF	33.33	33.42	32.67	32.76	190605.0
2007-01-26	CDL	ETF	10.39	10.6	10.32	10.53	398100.0
2007-01-26	CEF	ETF	9.41	9.49	9.35	9.49	347800.0
2007-01-26	CEW	ETF	25.94	25.94	25.94	25.94	1000.0
2007-01-26	CGO	ETF	16.81	17.17	16.81	17.17	30500.0
2007-01-26	CHB	ETF	8.13	8.17	7.81	7.92	1434100.0
2007-01-26	CHI	ETF	20.25	20.39	20.22	20.31	84100.0
2007-01-26	CHIC	ETF	29.17	29.19	28.45	28.83	580179.0
2007-01-26	CHY	ETF	17.37	17.39	17.26	17.34	167600.0
2007-01-26	CIL	ETF	25.36	25.39	25.36	25.39	1600.0
2007-01-26	CN	ETF	48.8	49.15	48.15	49.02	80000.0
2007-01-26	CNXT	ETF	1.9	1.92	1.74	1.8	46118558.0
2007-01-26	CPST	ETF	0.91	0.93	0.8899	0.8999	2068530.0
2007-01-26	CSA	ETF	21.79	21.79	21.5	21.65	11800.0
2007-01-26	CSB	ETF	33.55	33.6	33.2	33.6	21100.0
2007-01-26	CSD	ETF	25.44	25.59	25.36	25.54	13200.0
2007-01-26	CSQ	ETF	15.3	15.47	15.22	15.47	344300.0
2007-01-26	CTEC	ETF	93.05	93.35000000000001	91.25	91.85	8739.800000000001
2007-01-26	CVY	ETF	26.6	26.62	26.44	26.59	33300.0
2007-01-26	CWI	ETF	24.46	24.46	24.3267	24.4267	52800.0
2007-01-26	DBA	ETF	25.95	26.05	25.76	26.04	189600.0
2007-01-26	DBB	ETF	23.97	24.11	23.97	24.02	31100.0
2007-01-26	DBC	ETF	23.48	23.6	23.35	23.58	313600.0
2007-01-26	DBE	ETF	23.87	24.1	23.87	24.1	3800.0
2007-01-26	DBO	ETF	23.32	23.49	23.09	23.49	16900.0
2007-01-26	DBP	ETF	25.73	25.76	25.72	25.73	2300.0
2007-01-26	DBS	ETF	26.4	26.42	26.26	26.35	3400.0
2007-01-26	DBV	ETF	26.4	26.44	26.3	26.42	254600.0
2007-01-26	DDM	ETF	6.9492	6.9492	6.84	6.8917	700800.0
2007-01-26	DEF	ETF	25.55	25.7	25.55	25.69	12800.0
2007-01-26	DES	ETF	19.0633	19.1233	18.89	19.1067	60000.0

> showing 50 of 405 rows — these rows as CSV

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