PREVIEW / etf_daily / 2007-06-28

all etf daily files

  file:    by_date/etf_daily/2007/2007-06-28.parquet
  size:    22 KB
  rows:    475

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-06-28	SPY	ETF	150.38	151.41	149.67	150.38	157705000.0
2007-06-28	QQQ	ETF	47.52	47.85	47.47	47.52	116596740.0
2007-06-28	IWM	ETF	83.41	84.19	83.3	83.42	87866200.0
2007-06-28	DIA	ETF	134.09	135.1	133.9	134.09	13935600.0
2007-06-28	GLD	ETF	63.98	64.38	63.91	64.26	4231700.0
2007-06-28	TLT	ETF	84.32	84.58	84.18	84.3	3612500.0
2007-06-28	ADRE	ETF	45.05	45.64	45.01	45.34	122423.0
2007-06-28	AGG	ETF	98.21	98.33	98.04	98.17	293500.0
2007-06-28	AIQ	ETF	45.55	48.1	45.3	47.45	74880.0
2007-06-28	AIS	ETF	1.69	1.78	1.69	1.75	203600.0
2007-06-28	ARB	ETF	52.54	52.73	52.23	52.37	244800.0
2007-06-28	BBH	ETF	56.0833	56.5767	56.0767	56.3267	830400.0
2007-06-28	BIL	ETF	91.96	91.96	91.96	91.96	900.0
2007-06-28	BITS	ETF	27.6	29.0	27.6	28.24	19150.0
2007-06-28	BIV	ETF	73.66	73.68	73.42	73.42	11800.0
2007-06-28	BLV	ETF	72.74	72.74	72.63	72.63	5500.0
2007-06-28	BMVP	ETF	17.8533	17.9	17.8033	17.83	33700.0
2007-06-28	BND	ETF	74.16	74.16	73.94	74.03	74300.0
2007-06-28	BNE	ETF	19.71	19.8	19.49	19.72	217600.0
2007-06-28	BRF	ETF	14.48	14.48	14.48	14.48	700.0
2007-06-28	BSV	ETF	74.9	74.94	74.85	74.88	54800.0
2007-06-28	BTF	ETF	107.3	107.75	107.2	107.3	1100.0
2007-06-28	CBON	ETF	27.75	28.72	27.7	28.04	70298.0
2007-06-28	CDL	ETF	6.09	6.49	6.05	6.29	7648699.0
2007-06-28	CEF	ETF	9.0	9.15	9.0	9.07	175900.0
2007-06-28	CGO	ETF	17.8	18.21	17.8	18.11	12200.0
2007-06-28	CGW	ETF	25.55	25.55	25.0	25.3	137100.0
2007-06-28	CHB	ETF	10.18	10.2	9.79	10.06	1545600.0
2007-06-28	CHI	ETF	19.26	19.5	19.15	19.46	70900.0
2007-06-28	CHIC	ETF	26.66	26.9	26.15	26.32	388916.0
2007-06-28	CHY	ETF	15.97	16.1898	15.95	16.1898	111500.0
2007-06-28	CN	ETF	55.4	55.76	55.04	55.71	135700.0
2007-06-28	CNXT	ETF	1.43	1.44	1.3699	1.38	7328552.0
2007-06-28	CPST	ETF	1.16	1.16	1.09	1.1	6638131.0
2007-06-28	CSA	ETF	19.72	20.67	19.72	20.13	71600.0
2007-06-28	CSB	ETF	32.19	32.5	32.1	32.2	105000.0
2007-06-28	CSD	ETF	30.84	30.93	30.73	30.78	21100.0
2007-06-28	CSQ	ETF	15.11	15.24	15.05	15.24	274500.0
2007-06-28	CTEC	ETF	112.44999999999999	112.94999999999999	110.7	111.3	20780.4
2007-06-28	CVY	ETF	27.49	27.65	27.49	27.52	14100.0
2007-06-28	CWI	ETF	27.14	27.2933	27.1133	27.1133	16500.0
2007-06-28	CZA	ETF	27.06	27.06	27.06	27.06	100.0
2007-06-28	DBA	ETF	26.7	26.7	26.2	26.31	466100.0
2007-06-28	DBB	ETF	27.0	27.0	26.52	26.67	17400.0
2007-06-28	DBC	ETF	25.85	25.87	25.66	25.72	280700.0
2007-06-28	DBE	ETF	28.62	28.7	28.4	28.55	24200.0
2007-06-28	DBO	ETF	26.75	26.93	26.59	26.83	33900.0
2007-06-28	DBP	ETF	25.35	25.4	25.32	25.37	4400.0
2007-06-28	DBS	ETF	25.07	25.07	24.42	24.6	15400.0
2007-06-28	DBV	ETF	29.0	29.17	29.0	29.11	369600.0

> showing 50 of 475 rows — these rows as CSV

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