PREVIEW / etf_daily / 2007-12-17

all etf daily files

  file:    by_date/etf_daily/2007/2007-12-17.parquet
  size:    25 KB
  rows:    549

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-12-17	SPY	ETF	146.61	146.87	144.86	145.07	177269400.0
2007-12-17	QQQ	ETF	50.78	50.9881	49.71	49.73	134377521.0
2007-12-17	IWM	ETF	74.82	75.21	73.75	73.85	71635600.0
2007-12-17	DIA	ETF	132.99	133.15	131.69	131.93	10828800.0
2007-12-17	GLD	ETF	78.13	78.79	77.81	78.13	6495900.0
2007-12-17	TLT	ETF	91.07	91.54	90.93	91.42	2046200.0
2007-12-17	ADRE	ETF	52.56	53.15	51.38	51.53	550847.0
2007-12-17	AGG	ETF	100.68	100.77	100.36	100.53	550800.0
2007-12-17	AIA	ETF	47.25	47.25	45.19	45.19	25100.0
2007-12-17	AIQ	ETF	45.15	45.4	44.45	44.8	47485.0
2007-12-17	AIS	ETF	1.01	1.04	0.95	1.0	192900.0
2007-12-17	AIVI	ETF	70.04	70.04	68.96	68.96	101000.0
2007-12-17	ARB	ETF	41.41	41.49	40.7	40.86	380300.0
2007-12-17	BBH	ETF	54.5033	54.6567	53.5233	53.7633	913200.0
2007-12-17	BIL	ETF	91.74	91.84	91.72	91.78	44750.0
2007-12-17	BITS	ETF	22.88	23.84	22.64	22.84	5610.0
2007-12-17	BIV	ETF	76.57	76.83	76.55	76.83	38600.0
2007-12-17	BKF	ETF	56.77	56.77	55.15	55.94	17200.0
2007-12-17	BLV	ETF	75.28	75.58	75.15	75.58	19100.0
2007-12-17	BMVP	ETF	17.2133	17.28	17.0733	17.0733	22572.0
2007-12-17	BND	ETF	76.3	76.49	76.27	76.49	144700.0
2007-12-17	BNE	ETF	17.39	17.72	17.33	17.33	95400.0
2007-12-17	BOSS	ETF	39.69	39.69	39.28	39.28	100.0
2007-12-17	BSV	ETF	76.78	76.98	76.78	76.98	90900.0
2007-12-17	BTF	ETF	112.14999999999999	112.79999999999998	110.8	110.85000000000001	1960.0
2007-12-17	BWX	ETF	26.155	26.3	26.155	26.26	172600.0
2007-12-17	CBON	ETF	16.5	17.54	16.5	16.97	99006.0
2007-12-17	CDL	ETF	2.13	2.13	1.92	1.99	2625762.0
2007-12-17	CEF	ETF	10.49	10.49	10.23	10.36	479900.0
2007-12-17	CGO	ETF	19.16	19.18	18.8	18.93	29600.0
2007-12-17	CGW	ETF	25.04	25.04	24.54	24.78	99400.0
2007-12-17	CHB	ETF	8.36	8.38	8.0	8.0	1434600.0
2007-12-17	CHI	ETF	13.99	14.13	13.85	13.99	284300.0
2007-12-17	CHIC	ETF	15.07	15.1	14.77	14.98	422628.0
2007-12-17	CHW	ETF	12.42	12.63	12.26	12.6	565333.0
2007-12-17	CHY	ETF	13.18	13.19	12.91	12.96	314860.0
2007-12-17	CMF	ETF	51.92	51.92	51.92	51.92	400.0
2007-12-17	CN	ETF	60.5	60.87	59.31	59.5	352300.0
2007-12-17	CNXT	ETF	0.92	0.96	0.9	0.95	22939633.0
2007-12-17	COW	ETF	47.6	47.65	47.6	47.61	2000.0
2007-12-17	CPST	ETF	1.57	1.57	1.42	1.42	2751799.0
2007-12-17	CSA	ETF	16.1001	16.16	15.75	15.8	23900.0
2007-12-17	CSD	ETF	26.97	26.97	26.65	26.65	11200.0
2007-12-17	CSQ	ETF	13.87	14.01	13.78	13.81	390920.0
2007-12-17	CUT	ETF	23.01	23.39	23.0	23.0	29400.0
2007-12-17	CVY	ETF	23.55	23.57	23.21	23.21	23400.0
2007-12-17	CWI	ETF	27.5933	27.5933	26.9667	27.0467	162750.0
2007-12-17	CZA	ETF	25.76	25.76	25.59	25.59	5600.0
2007-12-17	DBA	ETF	31.93	32.2	31.35	31.7	580100.0
2007-12-17	DBB	ETF	21.87	21.87	21.19	21.51	68600.0

> showing 50 of 549 rows — these rows as CSV

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