PREVIEW / etf_daily / 2007-01-19

all etf daily files

  file:    by_date/etf_daily/2007/2007-01-19.parquet
  size:    20 KB
  rows:    407

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-19	SPY	ETF	142.54	143.1	142.46	142.82	56973000.0
2007-01-19	QQQ	ETF	43.98	44.2801	43.91	44.17	127584199.0
2007-01-19	IWM	ETF	77.04	77.96	76.87	77.76	49715800.0
2007-01-19	DIA	ETF	125.25	125.71	125.18	125.55	10946400.0
2007-01-19	GLD	ETF	62.52	63.13	62.27	63.0	3258400.0
2007-01-19	TLT	ETF	88.15	88.15	87.87	87.99	882500.0
2007-01-19	AAA	ETF	62.19	62.58	62.01	62.36	11400.0
2007-01-19	ADRE	ETF	37.93	38.4	37.86	38.38	223489.0
2007-01-19	AGG	ETF	99.93	99.93	99.73	99.84	309200.0
2007-01-19	AIQ	ETF	34.1	34.75	32.5	34.35	10480.0
2007-01-19	AIS	ETF	1.18	1.2	1.16	1.2	79500.0
2007-01-19	ARB	ETF	45.92	46.56	45.8	46.4	141800.0
2007-01-19	BAB	ETF	107.15	107.91	107.08	107.6	82600.0
2007-01-19	BBC	ETF	4.8	4.98	4.8	4.9301	149700.0
2007-01-19	BBH	ETF	65.3433	65.8467	65.3433	65.6333	1319700.0
2007-01-19	BITS	ETF	35.08	36.48	35.08	36.0	11681.0
2007-01-19	BNE	ETF	15.31	15.56	15.25	15.44	102400.0
2007-01-19	BOSS	ETF	42.22	43.4	42.22	43.4	100.0
2007-01-19	BRF	ETF	14.42	14.46	14.4	14.4	17500.0
2007-01-19	BTF	ETF	106.6	107.3	106.6	107.24999999999999	1640.0
2007-01-19	CBON	ETF	29.82	32.75	29.82	32.25	384530.0
2007-01-19	CDL	ETF	10.15	10.2	10.06	10.19	274000.0
2007-01-19	CEF	ETF	8.99	9.25	8.99	9.25	377800.0
2007-01-19	CEW	ETF	25.95	25.95	25.95	25.95	100.0
2007-01-19	CGO	ETF	16.85	16.95	16.76	16.86	34400.0
2007-01-19	CHB	ETF	8.37	8.42	8.14	8.23	1835000.0
2007-01-19	CHI	ETF	20.01	20.16	20.01	20.13	58000.0
2007-01-19	CHIC	ETF	32.09	32.11	31.12	31.91	609262.0
2007-01-19	CHY	ETF	17.07	17.26	17.04	17.26	100000.0
2007-01-19	CIL	ETF	25.4	25.45	25.4	25.45	2400.0
2007-01-19	CN	ETF	47.0	47.78	46.64	47.65	91600.0
2007-01-19	CNXT	ETF	1.93	2.04	1.91	2.01	19757458.0
2007-01-19	CPST	ETF	1.07	1.08	1.0	1.02	14128774.0
2007-01-19	CSA	ETF	21.85	21.95	21.85	21.9	2500.0
2007-01-19	CSB	ETF	34.02	34.42	33.99	34.32	9500.0
2007-01-19	CSD	ETF	25.2	25.36	25.19	25.36	3100.0
2007-01-19	CSM	ETF	1.3325	1.3325	1.3325	1.3325	8800.0
2007-01-19	CSQ	ETF	15.65	15.73	15.62	15.7	314800.0
2007-01-19	CTEC	ETF	96.54999999999998	97.24999999999999	95.5	96.75	9608.800000000001
2007-01-19	CVY	ETF	26.35	26.48	26.3	26.48	32100.0
2007-01-19	CWI	ETF	24.3	24.5133	24.3	24.5067	315000.0
2007-01-19	DBA	ETF	25.95	26.0	25.75	25.85	349300.0
2007-01-19	DBB	ETF	23.36	23.61	23.36	23.6	16100.0
2007-01-19	DBC	ETF	22.9	22.98	22.4	22.95	226700.0
2007-01-19	DBE	ETF	22.88	23.29	22.84	23.29	19400.0
2007-01-19	DBO	ETF	22.35	22.79	22.18	22.79	96100.0
2007-01-19	DBP	ETF	25.23	25.29	25.23	25.28	1400.0
2007-01-19	DBS	ETF	25.15	25.43	25.09	25.43	1200.0
2007-01-19	DBV	ETF	26.55	26.55	26.44	26.48	147500.0
2007-01-19	DDM	ETF	6.975	7.02	6.9667	6.9942	741600.0

> showing 50 of 407 rows — these rows as CSV

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