PREVIEW / etf_daily / 2007-07-20

all etf daily files

  file:    by_date/etf_daily/2007/2007-07-20.parquet
  size:    23 KB
  rows:    496

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-07-20	SPY	ETF	154.89	154.99	152.83	153.5	245502500.0
2007-07-20	QQQ	ETF	50.29	50.36	49.74	50.05	163721225.0
2007-07-20	IWM	ETF	84.38	84.77	82.59	83.25	154037700.0
2007-07-20	DIA	ETF	139.22	139.56	137.88	138.54	19277200.0
2007-07-20	GLD	ETF	67.13	68.0	67.12	67.58	5408600.0
2007-07-20	TLT	ETF	85.38	86.08	85.32	85.96	1459900.0
2007-07-20	ADRE	ETF	49.38	49.55	48.5	48.61	215242.0
2007-07-20	AGG	ETF	98.15	98.58	98.12	98.4	316300.0
2007-07-20	AIQ	ETF	51.15	51.2	49.25	49.45	38840.0
2007-07-20	AIS	ETF	1.77	1.8	1.73	1.78	157600.0
2007-07-20	ARB	ETF	53.89	53.89	52.33	52.5	431400.0
2007-07-20	BBH	ETF	56.2833	56.42	55.6833	56.1867	956100.0
2007-07-20	BIL	ETF	91.86	91.86	91.84	91.84	8000.0
2007-07-20	BITS	ETF	28.2	28.4	27.6	27.68	10074.0
2007-07-20	BIV	ETF	73.9	74.17	73.9	74.07	329300.0
2007-07-20	BLV	ETF	73.17	73.57	73.16	73.44	42400.0
2007-07-20	BMVP	ETF	18.15	18.16	17.94	17.98	24900.0
2007-07-20	BND	ETF	74.22	74.42	74.22	74.34	46300.0
2007-07-20	BNE	ETF	19.75	19.77	19.1	19.45	240700.0
2007-07-20	BOSS	ETF	48.57	48.85	48.57	48.85	300.0
2007-07-20	BRF	ETF	14.54	14.65	14.5	14.52	9600.0
2007-07-20	BSV	ETF	74.93	75.04	74.93	74.96	99400.0
2007-07-20	BTF	ETF	107.79999999999998	107.79999999999998	105.8	106.1	1500.0
2007-07-20	CBON	ETF	26.8	27.36	26.36	26.68	137595.0
2007-07-20	CDL	ETF	6.02	6.12	5.97	5.99	5044124.0
2007-07-20	CEF	ETF	9.69	9.7	9.55	9.55	296600.0
2007-07-20	CGO	ETF	18.65	18.69	18.44	18.48	41000.0
2007-07-20	CGW	ETF	26.36	26.4	25.78	25.92	299200.0
2007-07-20	CHB	ETF	12.32	12.57	11.95	12.43	3068400.0
2007-07-20	CHI	ETF	17.61	17.69	17.5	17.6	173100.0
2007-07-20	CHIC	ETF	23.93	24.21	23.85	23.89	1147324.0
2007-07-20	CHY	ETF	15.31	15.4	15.23	15.34	141900.0
2007-07-20	CN	ETF	53.55	53.68	52.91	53.26	196800.0
2007-07-20	CNXT	ETF	1.44	1.44	1.4	1.42	5734303.0
2007-07-20	CPI	ETF	24.45	26.08	24.3	24.65	9400.0
2007-07-20	CPST	ETF	1.31	1.35	1.27	1.29	2269551.0
2007-07-20	CSA	ETF	18.96	19.0599	18.66	18.86	99700.0
2007-07-20	CSD	ETF	31.54	31.54	31.12	31.25	11100.0
2007-07-20	CSQ	ETF	15.16	15.18	14.93	15.01	303200.0
2007-07-20	CTEC	ETF	107.94999999999999	109.14999999999999	105.35	108.45	8094.6
2007-07-20	CVY	ETF	27.82	27.86	27.51	27.58	19600.0
2007-07-20	CWI	ETF	28.4533	28.4533	28.16	28.1933	8850.0
2007-07-20	CZA	ETF	27.42	27.42	27.42	27.42	100.0
2007-07-20	DBA	ETF	26.54	26.73	26.26	26.38	229100.0
2007-07-20	DBB	ETF	28.4	28.74	28.4	28.73	128600.0
2007-07-20	DBC	ETF	26.4	26.51	26.29	26.4	252200.0
2007-07-20	DBE	ETF	29.5	29.6	29.38	29.38	13800.0
2007-07-20	DBO	ETF	27.84	27.84	27.65	27.68	11100.0
2007-07-20	DBP	ETF	26.68	26.85	26.68	26.76	34100.0
2007-07-20	DBS	ETF	26.27	26.33	26.17	26.17	4800.0

> showing 50 of 496 rows — these rows as CSV

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