PREVIEW / etf_daily / 2007-12-28

all etf daily files

  file:    by_date/etf_daily/2007/2007-12-28.parquet
  size:    25 KB
  rows:    560

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-28	SPY	ETF	148.54	148.61	146.9	147.3	116398100.0
2007-12-28	QQQ	ETF	52.04	52.16	51.43	51.86	67559859.0
2007-12-28	IWM	ETF	77.92	78.01	76.56	76.56	48207400.0
2007-12-28	DIA	ETF	134.22	134.4	132.82	133.41	7819200.0
2007-12-28	GLD	ETF	82.38	83.02	82.35	83.0	5134700.0
2007-12-28	TLT	ETF	91.65	92.58	91.5	92.48	1967800.0
2007-12-28	ADRE	ETF	55.75	55.9	55.07	55.48	296300.0
2007-12-28	AGG	ETF	100.82	101.21	100.69	101.14	442500.0
2007-12-28	AIA	ETF	48.92	48.97	47.76	48.02	24900.0
2007-12-28	AIQ	ETF	47.65	47.9	46.35	46.6	21710.0
2007-12-28	AIS	ETF	1.0	1.0	0.95	0.98	132785.0
2007-12-28	AIVI	ETF	71.08	71.27	70.98	70.98	24200.0
2007-12-28	ARB	ETF	42.4	43.37	42.03	42.2	241900.0
2007-12-28	BBH	ETF	54.4333	54.6667	54.2467	54.4367	394500.0
2007-12-28	BIL	ETF	91.64	91.66	91.6	91.6	59700.0
2007-12-28	BITS	ETF	24.28	24.6	24.0	24.6	19240.0
2007-12-28	BIV	ETF	77.02	77.14	76.77	77.09	29600.0
2007-12-28	BKF	ETF	60.03	60.04	58.46	58.815	67300.0
2007-12-28	BLV	ETF	75.75	76.44	75.75	76.35	30800.0
2007-12-28	BMVP	ETF	17.48	17.54	17.388	17.4167	28200.0
2007-12-28	BND	ETF	76.65	76.75	76.4	76.72	99000.0
2007-12-28	BNE	ETF	17.88	18.2	17.72	17.77	84300.0
2007-12-28	BRF	ETF	14.67	14.69	14.6	14.61	11600.0
2007-12-28	BSV	ETF	76.86	76.99	76.75	76.83	42800.0
2007-12-28	BTF	ETF	110.0	110.19999999999999	109.1	109.3	640.0
2007-12-28	BWX	ETF	26.695	26.71	26.58	26.71	165934.0
2007-12-28	CBON	ETF	17.5	17.5	16.82	16.84	50184.0
2007-12-28	CDL	ETF	2.07	2.12	2.04	2.08	2692184.0
2007-12-28	CEF	ETF	10.73	10.87	10.73	10.86	314900.0
2007-12-28	CGO	ETF	19.16	19.26	18.99	19.05	20000.0
2007-12-28	CGW	ETF	26.17	26.2899	26.0	26.14	325000.0
2007-12-28	CHB	ETF	9.22	9.52	9.19	9.35	916250.0
2007-12-28	CHI	ETF	14.75	14.89	14.42	14.5	454275.0
2007-12-28	CHIC	ETF	16.14	16.2	15.66	15.87	365065.0
2007-12-28	CHW	ETF	12.46	12.78	12.28	12.66	457150.0
2007-12-28	CHY	ETF	13.2	13.2099	12.96	13.02	512370.0
2007-12-28	CMF	ETF	52.175	52.175	52.1	52.1	1000.0
2007-12-28	CN	ETF	60.64	60.64	58.46	59.12	338935.0
2007-12-28	CNXT	ETF	0.86	0.8795	0.8247	0.8308	6316637.0
2007-12-28	COW	ETF	47.68	47.68	47.2001	47.28	2000.0
2007-12-28	CPST	ETF	1.73	1.75	1.62	1.62	3178274.0
2007-12-28	CSA	ETF	16.17	16.17	15.64	15.78	47800.0
2007-12-28	CSD	ETF	27.04	27.04	26.81	26.84	9200.0
2007-12-28	CSQ	ETF	14.04	14.1	13.88	13.96	314839.0
2007-12-28	CUT	ETF	24.33	24.33	24.14	24.15	230400.0
2007-12-28	CVY	ETF	23.49	23.52	23.24	23.34	45500.0
2007-12-28	CWI	ETF	27.7333	27.7667	27.6	27.7267	93300.0
2007-12-28	CZA	ETF	25.8601	25.89	25.8601	25.89	400.0
2007-12-28	DBA	ETF	33.22	33.34	32.75	32.99	475000.0
2007-12-28	DBB	ETF	22.42	22.47	21.32	22.21	51700.0

> showing 50 of 560 rows — these rows as CSV

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