PREVIEW / etf_daily / 2007-07-18

all etf daily files

  file:    by_date/etf_daily/2007/2007-07-18.parquet
  size:    22 KB
  rows:    494

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-18	SPY	ETF	154.23	154.8	153.3	154.47	237887400.0
2007-07-18	QQQ	ETF	49.94	50.17	49.64	50.17	144915875.0
2007-07-18	IWM	ETF	84.07	84.33	83.09	84.27	97201600.0
2007-07-18	DIA	ETF	139.33	139.7	138.28	139.33	20804700.0
2007-07-18	GLD	ETF	66.11	66.8	65.9	66.62	5238700.0
2007-07-18	TLT	ETF	84.93	85.54	84.81	85.21	1836800.0
2007-07-18	ADRE	ETF	48.9	48.97	48.159	48.63	213506.0
2007-07-18	AGG	ETF	97.95	98.32	97.93	98.17	226700.0
2007-07-18	AIQ	ETF	52.15	53.05	50.75	52.65	30140.0
2007-07-18	AIS	ETF	1.7	1.7	1.65	1.68	176300.0
2007-07-18	ARB	ETF	53.0	54.6	52.92	54.43	656700.0
2007-07-18	BBH	ETF	55.9	56.25	55.8833	56.23	222600.0
2007-07-18	BIL	ETF	91.76	91.78	91.7	91.78	5450.0
2007-07-18	BITS	ETF	28.3596	28.56	27.88	28.08	15332.0
2007-07-18	BIV	ETF	73.66	73.93	73.61	73.79	19800.0
2007-07-18	BLV	ETF	72.9	73.18	72.9	72.99	7000.0
2007-07-18	BMVP	ETF	18.117	18.226	18.063	18.213	70600.0
2007-07-18	BND	ETF	74.09	74.25	74.02	74.16	51500.0
2007-07-18	BNE	ETF	20.22	20.37	19.94	20.16	270600.0
2007-07-18	BRF	ETF	14.47	14.54	14.47	14.487	5300.0
2007-07-18	BSV	ETF	74.83	74.97	74.81	74.94	41900.0
2007-07-18	BTF	ETF	108.1	108.1	107.35	107.65	3180.0
2007-07-18	CBON	ETF	26.79	26.95	26.36	26.8	69615.0
2007-07-18	CDL	ETF	6.1	6.19	6.07	6.14	2988272.0
2007-07-18	CEF	ETF	9.27	9.57	9.25	9.56	400200.0
2007-07-18	CGO	ETF	18.21	18.33	18.01	18.29	19800.0
2007-07-18	CGW	ETF	25.98	26.05	25.75	25.96	68100.0
2007-07-18	CHB	ETF	10.68	12.12	10.63	11.96	6613671.0
2007-07-18	CHI	ETF	17.78	17.78	17.36	17.49	334300.0
2007-07-18	CHIC	ETF	23.62	23.74	23.24	23.52	361544.0
2007-07-18	CHY	ETF	15.55	15.59	15.13	15.3	344700.0
2007-07-18	CN	ETF	53.39	53.71	52.77	53.3	59400.0
2007-07-18	CNXT	ETF	1.43	1.5	1.4	1.45	19118290.0
2007-07-18	CPI	ETF	24.0	24.2	24.0	24.2	30100.0
2007-07-18	CPST	ETF	1.25	1.26	1.22	1.22	2040718.0
2007-07-18	CSA	ETF	18.63	18.63	18.26	18.32	19600.0
2007-07-18	CSB	ETF	32.3299	32.35	32.01	32.3	18900.0
2007-07-18	CSD	ETF	31.24	31.3	31.06	31.3	20600.0
2007-07-18	CSQ	ETF	15.1	15.19	15.0	15.19	447700.0
2007-07-18	CTEC	ETF	109.3	109.94999999999999	107.4505	109.25	11341.6
2007-07-18	CVY	ETF	27.79	27.8	27.64	27.8	33900.0
2007-07-18	CWI	ETF	28.2	28.2867	28.08	28.28	19500.0
2007-07-18	CZA	ETF	27.61	27.61	27.61	27.61	3000.0
2007-07-18	DBA	ETF	26.35	26.57	26.27	26.57	197000.0
2007-07-18	DBB	ETF	27.28	27.6	27.25	27.6	16700.0
2007-07-18	DBC	ETF	26.03	26.34	25.97	26.32	230600.0
2007-07-18	DBE	ETF	28.98	29.43	28.87	29.35	27900.0
2007-07-18	DBO	ETF	27.34	27.66	27.23	27.66	15700.0
2007-07-18	DBP	ETF	26.04	26.42	26.04	26.4	10100.0
2007-07-18	DBS	ETF	25.41	26.1	25.41	25.95	48100.0

> showing 50 of 494 rows — these rows as CSV

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