PREVIEW / etf_daily / 2007-07-09

all etf daily files

  file:    by_date/etf_daily/2007/2007-07-09.parquet
  size:    22 KB
  rows:    486

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-09	SPY	ETF	153.16	153.36	152.62	153.1	72348100.0
2007-07-09	QQQ	ETF	48.9	48.98	48.72	48.89	66774416.0
2007-07-09	IWM	ETF	84.96	85.74	84.42	84.72	56954300.0
2007-07-09	DIA	ETF	136.39	136.69	136.13	136.48	9688800.0
2007-07-09	GLD	ETF	65.0	65.68	64.99	65.38	5280800.0
2007-07-09	TLT	ETF	83.87	83.93	83.68	83.78	795400.0
2007-07-09	ADRE	ETF	47.92	48.18	47.841	47.9	210728.0
2007-07-09	AGG	ETF	97.71	97.73	97.52	97.68	232100.0
2007-07-09	AIQ	ETF	50.05	51.05	49.75	50.9	31300.0
2007-07-09	AIS	ETF	1.68	1.7	1.62	1.7	242900.0
2007-07-09	ARB	ETF	54.14	54.56	53.83	54.15	299700.0
2007-07-09	BBH	ETF	55.8333	56.33	55.8333	56.1	328500.0
2007-07-09	BIL	ETF	91.6	91.68	91.6	91.68	3950.0
2007-07-09	BITS	ETF	27.52	28.44	27.52	27.56	21670.0
2007-07-09	BIV	ETF	73.18	73.2	73.04	73.18	5500.0
2007-07-09	BLV	ETF	72.27	72.27	72.14	72.15	2500.0
2007-07-09	BMVP	ETF	18.26	18.27	18.16	18.24	39400.0
2007-07-09	BND	ETF	73.72	73.74	73.65	73.71	34900.0
2007-07-09	BNE	ETF	19.9	19.9	19.39	19.46	166300.0
2007-07-09	BRF	ETF	14.52	14.52	14.49	14.49	600.0
2007-07-09	BSV	ETF	74.53	74.64	74.53	74.63	47700.0
2007-07-09	BTF	ETF	109.04999999999998	109.49999999999999	109.04999999999998	109.49999999999999	100.0
2007-07-09	CBON	ETF	27.39	27.44	27.19	27.28	50892.0
2007-07-09	CDL	ETF	6.35	6.58	6.33	6.53	4208866.0
2007-07-09	CEF	ETF	9.22	9.3	9.09	9.15	270100.0
2007-07-09	CGO	ETF	18.41	18.41	18.15	18.15	21200.0
2007-07-09	CGW	ETF	25.84	25.99	25.8	25.9	161100.0
2007-07-09	CHB	ETF	10.01	10.01	9.65	9.69	1289800.0
2007-07-09	CHI	ETF	19.57	19.6	19.41	19.6	76200.0
2007-07-09	CHIC	ETF	25.94	25.95	25.05	25.39	1013050.0
2007-07-09	CHY	ETF	16.46	16.49	16.41	16.43	97800.0
2007-07-09	CN	ETF	56.0	56.11	55.64	55.67	69800.0
2007-07-09	CNXT	ETF	1.49	1.53	1.48	1.53	9979739.0
2007-07-09	CPST	ETF	1.12	1.25	1.11	1.23	12433378.0
2007-07-09	CSA	ETF	19.94	19.95	19.5	19.64	20200.0
2007-07-09	CSB	ETF	32.55	32.6	32.16	32.24	181100.0
2007-07-09	CSD	ETF	31.28	31.34	31.15	31.26	36900.0
2007-07-09	CSM	ETF	1.435	1.435	1.435	1.435	8000.0
2007-07-09	CSQ	ETF	15.46	15.54	15.44	15.51	215300.0
2007-07-09	CTEC	ETF	111.19999999999999	112.5	111.19999999999999	111.54999999999998	18242.4
2007-07-09	CVY	ETF	28.0	28.07	27.95	27.98	21500.0
2007-07-09	CWI	ETF	28.1333	28.2067	28.08	28.1467	20550.0
2007-07-09	CZA	ETF	27.6	27.67	27.54	27.67	5000.0
2007-07-09	DBA	ETF	26.5	26.72	26.4	26.64	276700.0
2007-07-09	DBB	ETF	27.7	27.77	27.54	27.69	25400.0
2007-07-09	DBC	ETF	26.28	26.37	26.18	26.29	156000.0
2007-07-09	DBE	ETF	29.46	29.63	29.46	29.55	34600.0
2007-07-09	DBO	ETF	27.71	27.82	27.58	27.67	20600.0
2007-07-09	DBP	ETF	25.89	25.93	25.8	25.85	15600.0
2007-07-09	DBS	ETF	25.22	25.26	25.04	25.08	27000.0

> showing 50 of 486 rows — these rows as CSV

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