PREVIEW / etf_daily / 2007-12-07

all etf daily files

  file:    by_date/etf_daily/2007/2007-12-07.parquet
  size:    25 KB
  rows:    545

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-12-07	SPY	ETF	151.42	151.5	150.55	150.91	148980100.0
2007-12-07	QQQ	ETF	52.29	52.54	52.08	52.33	88992298.0
2007-12-07	IWM	ETF	78.71	78.8	77.88	78.49	59125400.0
2007-12-07	DIA	ETF	136.45	136.77	136.09	136.39	8477600.0
2007-12-07	GLD	ETF	79.01	79.6	78.19	78.6	8328500.0
2007-12-07	TLT	ETF	92.18	92.35	91.38	91.75	2171000.0
2007-12-07	ADRE	ETF	58.19	58.2	57.12	57.48	322927.0
2007-12-07	AGG	ETF	101.26	101.26	100.59	100.86	406200.0
2007-12-07	AIA	ETF	51.47	51.47	50.06	50.16	10800.0
2007-12-07	AIQ	ETF	49.45	49.7	47.55	48.45	27020.0
2007-12-07	AIS	ETF	1.13	1.15	1.11	1.13	72400.0
2007-12-07	AIVI	ETF	75.14	75.26	74.9	74.98	34100.0
2007-12-07	ARB	ETF	42.31	42.99	41.56	42.0	410600.0
2007-12-07	BBH	ETF	57.4033	57.62	56.9567	57.45	652800.0
2007-12-07	BIL	ETF	91.6	91.72	91.6	91.72	43900.0
2007-12-07	BITS	ETF	22.08	22.24	21.2784	21.72	10175.0
2007-12-07	BIV	ETF	77.14	77.14	76.61	76.83	11000.0
2007-12-07	BKF	ETF	61.95	63.75	61.45	61.63	47030.0
2007-12-07	BLV	ETF	76.12	76.12	75.4	75.65	11100.0
2007-12-07	BMVP	ETF	17.54	17.59	17.49	17.52	96801.0
2007-12-07	BND	ETF	76.5	76.76	76.33	76.51	135500.0
2007-12-07	BNE	ETF	18.5	18.55	18.35	18.47	146600.0
2007-12-07	BRF	ETF	14.62	14.62	14.62	14.62	2700.0
2007-12-07	BSV	ETF	77.03	77.1	76.89	76.95	61900.0
2007-12-07	BTF	ETF	116.25	116.69999999999999	116.05	116.19999999999999	2080.0
2007-12-07	BWX	ETF	26.835	26.84	26.71	26.795	105800.0
2007-12-07	CBON	ETF	18.96	19.29	17.59	18.0	78795.0
2007-12-07	CDL	ETF	2.0	2.07	1.93	1.98	2451900.0
2007-12-07	CEF	ETF	10.58	10.63	10.45	10.57	175400.0
2007-12-07	CGO	ETF	19.5	20.0	19.46	19.9	26400.0
2007-12-07	CGW	ETF	26.09	26.171	25.9	26.15	93300.0
2007-12-07	CHB	ETF	9.51	9.63	9.29	9.38	1186862.0
2007-12-07	CHI	ETF	14.6	14.75	14.36	14.53	320600.0
2007-12-07	CHIC	ETF	15.96	16.67	15.9	16.49	333408.0
2007-12-07	CHW	ETF	12.71	12.75	12.55	12.71	401000.0
2007-12-07	CHY	ETF	13.93	13.93	13.58	13.76	219600.0
2007-12-07	CMF	ETF	51.81	51.81	51.5	51.72	6600.0
2007-12-07	CN	ETF	61.02	61.92	60.0	61.07	372500.0
2007-12-07	CNXT	ETF	1.1	1.12	1.08	1.12	3129869.0
2007-12-07	COW	ETF	48.33	48.6	48.22	48.6	6600.0
2007-12-07	CPST	ETF	1.36	1.39	1.3	1.35	3196798.0
2007-12-07	CSA	ETF	16.21	16.73	16.21	16.39	25100.0
2007-12-07	CSD	ETF	27.94	27.94	27.73	27.78	30900.0
2007-12-07	CSQ	ETF	14.34	14.42	14.26	14.42	291100.0
2007-12-07	CUT	ETF	26.24	26.24	25.04	25.1	83000.0
2007-12-07	CVY	ETF	24.84	24.84	24.64	24.64	10900.0
2007-12-07	CWI	ETF	29.5333	29.5333	29.0	29.1067	55800.0
2007-12-07	CZA	ETF	26.44	26.44	26.44	26.44	500.0
2007-12-07	DBA	ETF	31.47	32.08	31.36	32.07	553100.0
2007-12-07	DBB	ETF	23.4	23.91	23.38	23.88	325000.0

> showing 50 of 545 rows — these rows as CSV

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