PREVIEW / etf_daily / 2007-11-08

all etf daily files

  file:    by_date/etf_daily/2007/2007-11-08.parquet
  size:    24 KB
  rows:    534

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-11-08	SPY	ETF	147.99	148.4	145.07	147.16	374509900.0
2007-11-08	QQQ	ETF	53.14	53.33	50.8	51.73	380626329.0
2007-11-08	IWM	ETF	78.13	78.16	75.82	77.71	120883000.0
2007-11-08	DIA	ETF	133.52	133.6	130.83	132.45	38375700.0
2007-11-08	GLD	ETF	82.43	83.63	81.73	82.23	17356200.0
2007-11-08	TLT	ETF	90.65	90.94	90.43	90.56	2179600.0
2007-11-08	ADRE	ETF	55.41	56.36	53.9	56.02	776982.0
2007-11-08	AGG	ETF	100.51	100.57	100.28	100.45	469700.0
2007-11-08	AIQ	ETF	44.35	46.35	43.4	46.25	47860.0
2007-11-08	AIS	ETF	1.17	1.17	1.09	1.1	553300.0
2007-11-08	AIVI	ETF	74.97	75.25	74.0	74.94	68500.0
2007-11-08	ARB	ETF	49.79	49.9	48.22	49.62	355400.0
2007-11-08	BBH	ETF	59.5267	60.3767	59.2267	59.66	834900.0
2007-11-08	BIL	ETF	91.68	91.74	91.64	91.66	147400.0
2007-11-08	BITS	ETF	25.6	25.84	24.8	25.44	16726.0
2007-11-08	BIV	ETF	76.4	76.54	76.31	76.37	15900.0
2007-11-08	BLV	ETF	76.07	76.15	75.92	75.93	5300.0
2007-11-08	BMVP	ETF	17.0133	17.2267	16.89	17.1633	78600.0
2007-11-08	BND	ETF	76.34	76.34	76.11	76.2	552500.0
2007-11-08	BNE	ETF	16.85	17.16	16.6	16.81	237000.0
2007-11-08	BRF	ETF	14.69	14.72	14.67	14.68	2800.0
2007-11-08	BSV	ETF	76.58	76.74	76.5	76.6	30900.0
2007-11-08	BTF	ETF	114.45	114.45	112.5	113.14999999999999	3180.0
2007-11-08	BWX	ETF	27.05	27.13	27.0452	27.11	252200.0
2007-11-08	CBON	ETF	19.02	19.81	18.66	19.49	166798.0
2007-11-08	CDL	ETF	3.83	4.21	3.75	3.86	6466330.0
2007-11-08	CEF	ETF	11.17	11.17	10.76	10.95	696800.0
2007-11-08	CGO	ETF	19.25	19.25	18.23	18.89	42900.0
2007-11-08	CGW	ETF	25.6	25.61	25.16	25.52	89400.0
2007-11-08	CHB	ETF	11.37	11.39	10.29	10.7	2350100.0
2007-11-08	CHI	ETF	14.98	15.52	14.9	15.12	280201.0
2007-11-08	CHIC	ETF	12.95	13.13	12.27	13.0	778394.0
2007-11-08	CHW	ETF	12.4	12.86	12.01	12.41	290100.0
2007-11-08	CHY	ETF	13.35	13.61	13.16	13.26	248810.0
2007-11-08	CMF	ETF	51.555	51.625	51.535	51.61	9000.0
2007-11-08	CN	ETF	56.5	56.87	53.01	55.79	252533.0
2007-11-08	CNXT	ETF	1.19	1.225	1.14	1.19	9291269.0
2007-11-08	COW	ETF	48.09	48.16	48.09	48.16	700.0
2007-11-08	CPI	ETF	23.5	23.9	23.5	23.9	500.0
2007-11-08	CPST	ETF	1.22	1.29	1.18	1.23	4025661.0
2007-11-08	CSA	ETF	16.15	16.61	16.02	16.15	121400.0
2007-11-08	CSD	ETF	27.85	27.95	27.21	27.66	26100.0
2007-11-08	CSM	ETF	1.4725	1.4725	1.4725	1.4725	16400.0
2007-11-08	CSQ	ETF	14.25	14.25	13.86	14.11	311700.0
2007-11-08	CVY	ETF	24.75	24.81	24.41	24.74	17200.0
2007-11-08	CWI	ETF	29.1667	29.4733	28.78	29.2333	164100.0
2007-11-08	CZA	ETF	26.11	26.2	25.83	26.2	12500.0
2007-11-08	DBA	ETF	29.82	30.03	29.75	29.95	523500.0
2007-11-08	DBB	ETF	25.12	25.28	24.99	25.13	43200.0
2007-11-08	DBC	ETF	31.64	31.64	30.94	31.12	476302.0

> showing 50 of 534 rows — these rows as CSV

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