PREVIEW / etf_daily / 2007-12-21

all etf daily files

  file:    by_date/etf_daily/2007/2007-12-21.parquet
  size:    25 KB
  rows:    548

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-21	SPY	ETF	147.37	148.42	147.09	148.13	146084400.0
2007-12-21	QQQ	ETF	51.71	51.9	51.48	51.85	107613153.0
2007-12-21	IWM	ETF	77.88	78.6	77.64	78.6	83426900.0
2007-12-21	DIA	ETF	133.4	134.65	133.3	134.34	11031800.0
2007-12-21	GLD	ETF	80.16	80.32	79.92	80.1	4603300.0
2007-12-21	TLT	ETF	92.9	92.92	91.66	91.67	1767600.0
2007-12-21	ADRE	ETF	54.72	55.2534	54.54	55.18	380573.0
2007-12-21	AGG	ETF	101.26	101.26	100.74	100.74	411900.0
2007-12-21	AIA	ETF	48.55	48.56	48.03	48.56	4200.0
2007-12-21	AIQ	ETF	48.0	50.9	47.55	49.4	71340.0
2007-12-21	AIS	ETF	0.97	1.0	0.95	0.97	171590.0
2007-12-21	AIVI	ETF	69.74	69.86	69.12	69.7	74100.0
2007-12-21	ARB	ETF	42.82	43.08	41.97	42.41	581200.0
2007-12-21	BBH	ETF	54.7267	55.0233	54.45	54.7867	926700.0
2007-12-21	BIL	ETF	91.88	91.9	91.82	91.86	64050.0
2007-12-21	BITS	ETF	24.0	24.48	23.76	24.44	8325.0
2007-12-21	BIV	ETF	77.37	78.39	76.78	76.99	93600.0
2007-12-21	BKF	ETF	59.6	60.69	58.87	60.69	28100.0
2007-12-21	BLV	ETF	76.49	76.49	75.86	75.91	7300.0
2007-12-21	BMVP	ETF	17.3267	17.5387	17.3267	17.52	93226.0
2007-12-21	BND	ETF	77.04	77.04	76.44	76.49	3511900.0
2007-12-21	BNE	ETF	18.15	18.45	18.04	18.38	342196.0
2007-12-21	BRF	ETF	14.59	14.62	14.56	14.6	9400.0
2007-12-21	BSV	ETF	77.16	77.17	76.9	76.96	96200.0
2007-12-21	BTF	ETF	109.7	110.25	109.7	110.15	1860.0
2007-12-21	BWX	ETF	26.32	26.33	26.09	26.275	161600.0
2007-12-21	CBON	ETF	17.72	17.97	17.15	17.97	112903.0
2007-12-21	CDL	ETF	2.01	2.15	2.0	2.13	3791471.0
2007-12-21	CEF	ETF	10.35	10.51	10.35	10.47	356100.0
2007-12-21	CGO	ETF	18.45	18.71	18.45	18.71	10400.0
2007-12-21	CGW	ETF	25.14	25.71	25.14	25.71	121482.0
2007-12-21	CHB	ETF	8.42	9.66	8.3	9.59	3850656.0
2007-12-21	CHI	ETF	14.35	14.47	14.12	14.35	399400.0
2007-12-21	CHIC	ETF	15.41	15.58	15.14	15.55	963238.0
2007-12-21	CHW	ETF	12.21	12.34	12.05	12.32	487800.0
2007-12-21	CHY	ETF	12.93	13.0	12.86	12.9	448092.0
2007-12-21	CMF	ETF	52.165	52.165	51.815	51.965	19600.0
2007-12-21	CN	ETF	59.22	61.0	59.22	61.0	322550.0
2007-12-21	CNXT	ETF	0.94	0.94	0.88	0.89	9750611.0
2007-12-21	COW	ETF	47.74	47.75	47.69	47.71	2400.0
2007-12-21	CPI	ETF	24.2	24.35	23.7	23.7	5000.0
2007-12-21	CPST	ETF	1.6	1.63	1.52	1.57	2136149.0
2007-12-21	CSA	ETF	15.97	16.5	15.89	15.96	38200.0
2007-12-21	CSD	ETF	26.99	27.25	26.97	27.23	8300.0
2007-12-21	CSQ	ETF	13.69	13.99	13.68	13.95	393539.0
2007-12-21	CUT	ETF	23.8	24.25	23.78	24.0	26800.0
2007-12-21	CVY	ETF	23.44	23.68	23.44	23.68	19300.0
2007-12-21	CWI	ETF	27.2067	27.3133	27.04	27.3	217500.0
2007-12-21	DBA	ETF	32.46	32.87	32.37	32.8	892500.0
2007-12-21	DBB	ETF	22.14	22.41	22.1	22.23	17100.0

> showing 50 of 548 rows — these rows as CSV

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