PREVIEW / etf_daily / 2007-11-07

all etf daily files

  file:    by_date/etf_daily/2007/2007-11-07.parquet
  size:    24 KB
  rows:    531

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-11-07	SPY	ETF	150.44	151.13	147.55	147.91	306639700.0
2007-11-07	QQQ	ETF	54.22	54.58	53.31	53.35	197908188.0
2007-11-07	IWM	ETF	78.9	79.12	77.17	77.48	112492300.0
2007-11-07	DIA	ETF	135.18	135.73	132.93	133.35	18182700.0
2007-11-07	GLD	ETF	83.21	83.24	81.33	82.24	16512900.0
2007-11-07	TLT	ETF	90.54	90.76	90.32	90.72	1456100.0
2007-11-07	ADRE	ETF	56.08	56.84	55.1	55.11	267116.0
2007-11-07	AGG	ETF	100.4	100.42	100.12	100.35	716100.0
2007-11-07	AIQ	ETF	45.3	45.7	43.9	44.05	33360.0
2007-11-07	AIS	ETF	1.16	1.2	1.1201	1.17	204400.0
2007-11-07	AIVI	ETF	75.32	75.97	74.39	74.43	46600.0
2007-11-07	ARB	ETF	50.27	50.78	49.19	49.38	354300.0
2007-11-07	BBH	ETF	59.4833	60.5333	59.0533	59.06	370500.0
2007-11-07	BIL	ETF	91.6	91.8	91.6	91.72	218850.0
2007-11-07	BITS	ETF	26.0404	26.44	25.44	25.8	17102.0
2007-11-07	BIV	ETF	76.19	76.29	76.08	76.28	13500.0
2007-11-07	BLV	ETF	76.19	76.19	75.74	75.85	10800.0
2007-11-07	BMVP	ETF	17.32	17.37	17.03	17.05	60800.0
2007-11-07	BND	ETF	76.22	76.22	75.94	76.11	88700.0
2007-11-07	BNE	ETF	17.1	17.2	16.6	16.75	378300.0
2007-11-07	BRF	ETF	14.59	14.69	14.59	14.65	20400.0
2007-11-07	BSV	ETF	76.35	76.56	76.35	76.54	54200.0
2007-11-07	BTF	ETF	115.5	115.64999999999999	113.8	114.45	1820.0
2007-11-07	BWX	ETF	28.095	28.095	27.0	27.0	278100.0
2007-11-07	CBON	ETF	19.24	19.34	18.89	18.89	98748.0
2007-11-07	CDL	ETF	4.12	4.15	3.82	3.85	3753434.0
2007-11-07	CEF	ETF	11.2	11.2	10.78	10.84	1368100.0
2007-11-07	CGO	ETF	19.31	19.49	19.24	19.24	15700.0
2007-11-07	CGW	ETF	26.1	26.15	25.48	25.56	103500.0
2007-11-07	CHB	ETF	11.18	11.63	11.18	11.33	3420330.0
2007-11-07	CHI	ETF	15.77	15.77	15.0	15.07	335400.0
2007-11-07	CHIC	ETF	13.22	13.46	12.75	12.86	946013.0
2007-11-07	CHW	ETF	14.88	14.88	12.24	12.31	265800.0
2007-11-07	CHY	ETF	13.87	13.87	13.38	13.4	286240.0
2007-11-07	CMF	ETF	51.575	51.6	51.5	51.585	32000.0
2007-11-07	CN	ETF	57.23	58.37	56.05	56.35	351200.0
2007-11-07	CNXT	ETF	1.25	1.26	1.19	1.2	8003793.0
2007-11-07	COW	ETF	48.2	48.32	47.9	47.91	2000.0
2007-11-07	CPI	ETF	23.9	23.9	23.66	23.66	300.0
2007-11-07	CPST	ETF	1.25	1.28	1.18	1.2	4014843.0
2007-11-07	CSA	ETF	16.32	16.48	15.98	16.05	37200.0
2007-11-07	CSD	ETF	28.18	28.34	27.75	27.75	49900.0
2007-11-07	CSM	ETF	1.4725	1.4725	1.4725	1.4725	32400.0
2007-11-07	CSQ	ETF	14.23	14.34	14.07	14.1	283100.0
2007-11-07	CVY	ETF	25.07	25.11	24.64	24.64	21600.0
2007-11-07	CWI	ETF	29.52	29.5867	29.0333	29.0333	39450.0
2007-11-07	CZA	ETF	26.15	26.15	26.15	26.15	2000.0
2007-11-07	DBA	ETF	31.0	31.0	29.7	29.82	648100.0
2007-11-07	DBB	ETF	25.49	25.55	25.19	25.28	28100.0
2007-11-07	DBC	ETF	33.0	33.0	30.8	31.2	511600.0

> showing 50 of 531 rows — these rows as CSV

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