PREVIEW / etf_daily / 2007-08-23

all etf daily files

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

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-23	SPY	ETF	147.34	147.65	145.61	146.52	203915300.0
2007-08-23	QQQ	ETF	47.82	47.85	47.23	47.53	118663363.0
2007-08-23	IWM	ETF	79.95	80.12	78.31	78.61	105471500.0
2007-08-23	DIA	ETF	132.72	133.08	131.62	132.17	14056300.0
2007-08-23	GLD	ETF	65.64	65.8	65.13	65.31	3027400.0
2007-08-23	TLT	ETF	87.09	87.68	87.03	87.42	1618800.0
2007-08-23	ADRE	ETF	44.57	44.79	43.5201	44.15	249699.0
2007-08-23	AGG	ETF	99.16	99.32	99.01	99.3	522300.0
2007-08-23	AIQ	ETF	44.35	46.0	43.8	45.5	29640.0
2007-08-23	AIS	ETF	1.41	1.45	1.38	1.38	242800.0
2007-08-23	ARB	ETF	51.55	51.65	50.44	50.64	249500.0
2007-08-23	BBH	ETF	54.2	54.5367	54.05	54.1233	243000.0
2007-08-23	BIL	ETF	91.98	91.98	91.88	91.96	40250.0
2007-08-23	BITS	ETF	26.8	26.8	26.28	26.4	1359.0
2007-08-23	BIV	ETF	74.78	75.03	74.78	74.92	6800.0
2007-08-23	BLV	ETF	73.63	73.99	73.63	73.9	2700.0
2007-08-23	BMVP	ETF	16.8467	16.8666	16.698	16.7867	83200.0
2007-08-23	BND	ETF	74.92	75.07	74.89	74.97	46600.0
2007-08-23	BNE	ETF	16.87	16.99	16.37	16.79	263500.0
2007-08-23	BRF	ETF	14.53	14.55	14.53	14.55	3600.0
2007-08-23	BSV	ETF	75.62	75.71	75.57	75.57	54000.0
2007-08-23	BTF	ETF	103.3	103.69999999999999	103.3	103.69999999999999	400.0
2007-08-23	CBON	ETF	26.57	26.57	25.25	25.35	94745.0
2007-08-23	CDL	ETF	4.2	4.24	4.07	4.11	1649600.0
2007-08-23	CEF	ETF	9.1	9.13	9.0	9.08	343200.0
2007-08-23	CGO	ETF	16.93	17.35	16.93	17.22	21900.0
2007-08-23	CGW	ETF	24.2	24.22	23.84	24.0	48500.0
2007-08-23	CHB	ETF	11.67	11.8	10.83	10.92	1656500.0
2007-08-23	CHI	ETF	17.02	17.11	16.76	16.84	167900.0
2007-08-23	CHIC	ETF	17.97	18.134	17.4	17.79	305917.0
2007-08-23	CHW	ETF	13.41	13.74	13.25	13.6948	58500.0
2007-08-23	CHY	ETF	14.87	14.91	14.61	14.6399	216400.0
2007-08-23	CN	ETF	48.25	48.25	47.3	47.92	150500.0
2007-08-23	CNXT	ETF	1.16	1.16	1.12	1.14	4453992.0
2007-08-23	CPST	ETF	0.97	1.04	0.9527	1.01	1883062.0
2007-08-23	CSA	ETF	17.57	17.85	17.33	17.59	33400.0
2007-08-23	CSD	ETF	28.75	28.75	28.48	28.61	9400.0
2007-08-23	CSQ	ETF	14.48	14.48	14.23	14.32	354600.0
2007-08-23	CTEC	ETF	101.4	102.10000000000001	99.74999999999999	100.25	6940.200000000001
2007-08-23	CVY	ETF	26.11	26.15	25.87	25.93	53200.0
2007-08-23	CWI	ETF	26.2667	26.2667	25.94	26.0533	25650.0
2007-08-23	CZA	ETF	25.42	25.42	25.3299	25.3299	7100.0
2007-08-23	DBA	ETF	26.75	27.12	26.5	26.6	133300.0
2007-08-23	DBB	ETF	25.57	25.68	25.51	25.58	22200.0
2007-08-23	DBC	ETF	25.5	25.55	25.18	25.33	281600.0
2007-08-23	DBE	ETF	27.42	27.61	27.25	27.48	56100.0
2007-08-23	DBO	ETF	25.75	26.03	25.7	26.03	7800.0
2007-08-23	DBP	ETF	25.6	25.6	25.29	25.34	14400.0
2007-08-23	DBS	ETF	23.27	23.27	22.9901	23.03	7600.0
2007-08-23	DBV	ETF	27.76	27.82	27.55	27.79	152800.0

> showing 50 of 499 rows — these rows as CSV

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