PREVIEW / etf_daily / 2007-08-22

all etf daily files

  file:    by_date/etf_daily/2007/2007-08-22.parquet
  size:    23 KB
  rows:    501

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-08-22	SPY	ETF	146.01	146.8	145.33	146.65	173156700.0
2007-08-22	QQQ	ETF	47.375	47.7	47.27	47.66	115815143.0
2007-08-22	IWM	ETF	79.38	79.79	78.93	79.63	70351700.0
2007-08-22	DIA	ETF	131.58	132.4	131.35	132.29	12808700.0
2007-08-22	GLD	ETF	65.22	65.53	65.17	65.4	4251100.0
2007-08-22	TLT	ETF	87.05	87.31	86.81	87.12	1137800.0
2007-08-22	ADRE	ETF	42.9	43.91	42.9	43.86	154102.0
2007-08-22	AGG	ETF	99.15	99.26	98.96	99.18	545300.0
2007-08-22	AIQ	ETF	43.35	44.3	43.0	44.25	15080.0
2007-08-22	AIS	ETF	1.39	1.42	1.36	1.41	235100.0
2007-08-22	ARB	ETF	51.1	51.45	50.85	51.41	251200.0
2007-08-22	BBH	ETF	53.7067	53.99	53.5567	53.8533	770700.0
2007-08-22	BIL	ETF	92.02	92.02	91.88	92.02	30000.0
2007-08-22	BITS	ETF	25.52	26.72	25.38	26.56	7148.0
2007-08-22	BIV	ETF	74.82	74.99	74.74	74.89	20800.0
2007-08-22	BLV	ETF	73.52	73.77	73.27	73.66	16600.0
2007-08-22	BMVP	ETF	16.6767	16.8233	16.6427	16.78	69600.0
2007-08-22	BND	ETF	74.9	75.05	74.86	74.97	38900.0
2007-08-22	BNE	ETF	16.23	16.95	16.11	16.77	388300.0
2007-08-22	BOSS	ETF	48.0	48.45	48.0	48.45	100.0
2007-08-22	BRF	ETF	14.55	14.6	14.51	14.51	9300.0
2007-08-22	BSV	ETF	75.71	75.8	75.71	75.74	40900.0
2007-08-22	BTF	ETF	103.3	103.3	102.5	103.0	720.0
2007-08-22	CBON	ETF	26.17	26.75	25.58	26.49	49050.0
2007-08-22	CDL	ETF	4.23	4.23	4.12	4.19	2571900.0
2007-08-22	CEF	ETF	9.03	9.15	9.03	9.06	225200.0
2007-08-22	CGO	ETF	16.51	17.22	16.51	16.88	26100.0
2007-08-22	CGW	ETF	23.77	24.0	23.77	24.0	71200.0
2007-08-22	CHB	ETF	11.07	11.67	11.01	11.62	2330400.0
2007-08-22	CHI	ETF	16.7	16.93	16.64	16.87	125700.0
2007-08-22	CHIC	ETF	18.39	18.7	17.71	17.84	510883.0
2007-08-22	CHW	ETF	13.45	13.89	13.22	13.4	124400.0
2007-08-22	CHY	ETF	14.8	14.83	14.61	14.75	167000.0
2007-08-22	CN	ETF	47.0	48.18	46.87	48.06	284100.0
2007-08-22	CNXT	ETF	1.17	1.18	1.1	1.15	11841548.0
2007-08-22	CPI	ETF	25.4	25.4	24.8	24.8	2400.0
2007-08-22	CPST	ETF	0.9995	1.0	0.97	0.98	1335995.0
2007-08-22	CSA	ETF	17.0	17.81	16.85	17.62	40300.0
2007-08-22	CSD	ETF	28.39	28.64	28.39	28.58	8200.0
2007-08-22	CSQ	ETF	14.49	14.49	14.2	14.31	365500.0
2007-08-22	CTEC	ETF	100.29999999999998	101.85	99.55	100.6	35513.0
2007-08-22	CVY	ETF	25.87	26.0	25.85	25.95	11300.0
2007-08-22	CWI	ETF	25.8067	26.0267	25.8067	26.0267	24300.0
2007-08-22	CZA	ETF	25.22	25.25	25.22	25.24	7400.0
2007-08-22	DBA	ETF	26.43	26.72	26.29	26.69	202800.0
2007-08-22	DBB	ETF	25.24	25.39	24.99	25.39	33600.0
2007-08-22	DBC	ETF	25.2	25.32	25.06	25.25	190200.0
2007-08-22	DBE	ETF	27.32	27.42	27.05	27.13	16100.0
2007-08-22	DBO	ETF	25.87	25.9	25.43	25.67	13500.0
2007-08-22	DBP	ETF	25.4	25.41	25.31	25.31	13100.0

> showing 50 of 501 rows — these rows as CSV

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