PREVIEW / etf_daily / 2007-08-08

all etf daily files

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

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-08	SPY	ETF	148.41	150.59	147.34	149.83	274930600.0
2007-08-08	QQQ	ETF	48.51	49.06	48.4	48.84	165283054.0
2007-08-08	IWM	ETF	77.89	80.1	77.82	79.52	259607000.0
2007-08-08	DIA	ETF	135.39	136.96	134.88	136.55	27549800.0
2007-08-08	GLD	ETF	66.73	67.54	66.18	66.77	4252100.0
2007-08-08	TLT	ETF	86.89	86.89	85.86	86.16	6453000.0
2007-08-08	ADRE	ETF	45.5	46.778	45.49	46.35	228969.0
2007-08-08	AGG	ETF	98.48	98.49	98.17	98.36	277200.0
2007-08-08	AIQ	ETF	42.65	42.8	41.9	42.65	169900.0
2007-08-08	AIS	ETF	1.53	1.57	1.49	1.5	307500.0
2007-08-08	ARB	ETF	54.59	55.63	53.46	54.33	1333600.0
2007-08-08	BBH	ETF	54.8367	55.3333	54.3933	55.3333	858900.0
2007-08-08	BIL	ETF	91.66	91.68	91.6	91.62	19750.0
2007-08-08	BITS	ETF	25.0	28.72	24.4	25.84	75200.0
2007-08-08	BIV	ETF	74.3	74.3	74.04	74.16	6100.0
2007-08-08	BLV	ETF	73.14	73.21	72.91	73.2	15100.0
2007-08-08	BMVP	ETF	16.8633	16.8633	16.52	16.6833	129900.0
2007-08-08	BND	ETF	74.43	74.47	74.23	74.36	40900.0
2007-08-08	BNE	ETF	15.34	15.34	14.58	15.25	662000.0
2007-08-08	BRF	ETF	14.5	14.51	14.5	14.51	10700.0
2007-08-08	BSV	ETF	75.08	75.09	74.9	75.04	65100.0
2007-08-08	BTF	ETF	102.24999999999999	104.1	102.245	104.1	740.0
2007-08-08	CBON	ETF	23.48	24.05	22.83	23.23	191911.0
2007-08-08	CDL	ETF	4.41	4.63	4.36	4.63	6308630.0
2007-08-08	CEF	ETF	9.31	9.37	9.25	9.36	233000.0
2007-08-08	CGO	ETF	16.83	16.97	16.74	16.74	26600.0
2007-08-08	CGW	ETF	24.88	25.29	24.88	25.23	340000.0
2007-08-08	CHB	ETF	11.83	11.98	10.9	11.65	5096506.0
2007-08-08	CHI	ETF	16.9	17.19	16.87	17.12	129900.0
2007-08-08	CHIC	ETF	17.48	18.19	17.05	17.44	1571077.0
2007-08-08	CHW	ETF	13.75	14.05	13.55	13.99	99300.0
2007-08-08	CHY	ETF	14.72	15.07	14.72	15.01	187400.0
2007-08-08	CN	ETF	49.0	50.0	48.94	49.7	158600.0
2007-08-08	CNXT	ETF	1.24	1.29	1.22	1.28	7113288.0
2007-08-08	CPST	ETF	1.1	1.13	1.09	1.11	2076823.0
2007-08-08	CSA	ETF	16.79	17.46	16.79	17.0	67500.0
2007-08-08	CSD	ETF	28.84	29.44	28.84	29.44	36600.0
2007-08-08	CSQ	ETF	14.31	14.6	14.31	14.5	243700.0
2007-08-08	CTEC	ETF	100.39999999999999	103.55	97.85	102.44999999999999	67531.2
2007-08-08	CVY	ETF	26.14	26.47	25.97	26.21	65600.0
2007-08-08	CWI	ETF	27.0667	27.3467	27.0667	27.1733	24900.0
2007-08-08	CZA	ETF	25.7	25.7	25.47	25.47	10100.0
2007-08-08	DBA	ETF	26.3	26.58	26.3	26.52	134300.0
2007-08-08	DBB	ETF	26.7	26.99	26.7	26.94	32400.0
2007-08-08	DBC	ETF	25.6	25.85	25.54	25.64	174000.0
2007-08-08	DBE	ETF	27.91	28.32	27.91	28.16	51800.0
2007-08-08	DBO	ETF	25.77	27.01	25.77	26.68	27600.0
2007-08-08	DBP	ETF	26.34	26.45	26.29	26.29	5600.0
2007-08-08	DBS	ETF	25.88	25.88	25.77	25.84	1200.0
2007-08-08	DBV	ETF	28.86	28.95	28.8	28.86	227100.0

> showing 50 of 497 rows — these rows as CSV

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