PREVIEW / etf_daily / 2007-02-27

all etf daily files

  file:    by_date/etf_daily/2007/2007-02-27.parquet
  size:    21 KB
  rows:    444

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-02-27	SPY	ETF	143.88	144.2	139.0	139.5	274466500.0
2007-02-27	QQQ	ETF	44.36	44.48	43.06	43.19	318067859.0
2007-02-27	IWM	ETF	80.36	80.94	77.47	78.05	136636000.0
2007-02-27	DIA	ETF	125.34	126.44	120.5	121.6	32106200.0
2007-02-27	GLD	ETF	67.34	68.33	65.07	65.41	15208600.0
2007-02-27	TLT	ETF	89.74	91.26	89.6	90.56	3243200.0
2007-02-27	AAA	ETF	61.8	61.8	60.075	60.4	12400.0
2007-02-27	ADRE	ETF	39.18	39.18	36.92	37.49	1498523.0
2007-02-27	AGG	ETF	100.92	101.67	100.56	100.92	379300.0
2007-02-27	AIQ	ETF	36.25	37.85	35.5	36.1	76100.0
2007-02-27	AIS	ETF	1.24	1.24	1.15	1.18	203300.0
2007-02-27	ARB	ETF	45.18	45.6	44.69	44.8	199100.0
2007-02-27	BAB	ETF	106.12	106.91	101.82	102.9	152100.0
2007-02-27	BBC	ETF	4.33	4.35	4.11	4.1799	220300.0
2007-02-27	BBH	ETF	61.75	61.8633	60.4133	60.8067	1108800.0
2007-02-27	BITS	ETF	41.44	42.8	40.2	41.08	56474.0
2007-02-27	BNE	ETF	15.96	16.0	15.44	15.45	153900.0
2007-02-27	BRF	ETF	14.53	14.54	14.51	14.51	5900.0
2007-02-27	BTF	ETF	112.79999999999998	112.79999999999998	110.39999999999999	110.64999999999999	2380.0
2007-02-27	CBON	ETF	32.2	32.34	30.93	30.93	58744.0
2007-02-27	CDL	ETF	10.35	10.38	10.29	10.3	435400.0
2007-02-27	CEF	ETF	9.73	9.93	9.47	9.55	657200.0
2007-02-27	CGO	ETF	16.62	16.79	15.92	16.25	56200.0
2007-02-27	CHB	ETF	8.42	8.46	8.1	8.35	3331300.0
2007-02-27	CHI	ETF	20.28	20.29	20.0	20.0899	81100.0
2007-02-27	CHIC	ETF	30.11	30.21	29.05	29.48	489293.0
2007-02-27	CHY	ETF	17.0	17.04	16.74	16.9	129900.0
2007-02-27	CIL	ETF	25.45	25.5	25.45	25.5	1600.0
2007-02-27	CN	ETF	45.37	49.0	44.48	45.55	288300.0
2007-02-27	CNXT	ETF	2.02	2.02	1.97	1.99	12424710.0
2007-02-27	CPST	ETF	0.96	0.97	0.89	0.895	4719076.0
2007-02-27	CSA	ETF	22.87	22.87	20.64	21.56	78700.0
2007-02-27	CSB	ETF	32.85	32.98	31.62	31.96	30000.0
2007-02-27	CSD	ETF	26.41	26.41	25.71	25.84	27500.0
2007-02-27	CSM	ETF	1.36	1.36	1.275	1.315	237600.0
2007-02-27	CSQ	ETF	15.32	15.32	12.0	14.77	897900.0
2007-02-27	CTEC	ETF	84.85	85.1	80.64999999999999	81.35	15281.6
2007-02-27	CVY	ETF	26.98	27.01	26.36	26.66	39400.0
2007-02-27	CWI	ETF	25.1533	25.2	24.2867	24.5	307950.0
2007-02-27	DBA	ETF	27.02	27.04	26.3	26.53	573900.0
2007-02-27	DBB	ETF	24.7	25.05	24.58	24.7	35700.0
2007-02-27	DBC	ETF	25.03	25.34	24.76	24.83	192300.0
2007-02-27	DBE	ETF	26.12	26.61	26.05	26.05	42700.0
2007-02-27	DBO	ETF	25.31	25.95	25.19	25.25	16800.0
2007-02-27	DBP	ETF	27.15	27.59	26.25	26.45	21800.0
2007-02-27	DBS	ETF	28.5	28.75	25.88	27.8	33500.0
2007-02-27	DBV	ETF	26.3	26.47	26.09	26.24	159800.0
2007-02-27	DDM	ETF	7.0125	7.0125	6.4733	6.5417	6498000.0
2007-02-27	DEF	ETF	26.04	26.04	25.4	25.54	24000.0
2007-02-27	DES	ETF	19.4533	19.47	19.0367	19.0933	71400.0

> showing 50 of 444 rows — these rows as CSV

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