PREVIEW / etf_daily / 2007-11-12

all etf daily files

  file:    by_date/etf_daily/2007/2007-11-12.parquet
  size:    24 KB
  rows:    528

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-12	SPY	ETF	145.21	146.61	143.7	143.7	243087800.0
2007-11-12	QQQ	ETF	49.92	50.24	48.65	48.73	283215926.0
2007-11-12	IWM	ETF	76.89	78.11	76.03	76.11	106800000.0
2007-11-12	DIA	ETF	130.35	131.65	129.74	129.77	20703800.0
2007-11-12	GLD	ETF	80.41	80.44	78.25	78.3	17297000.0
2007-11-12	TLT	ETF	91.99	91.99	91.35	91.66	460600.0
2007-11-12	ADRE	ETF	54.18	54.18	51.5	51.61	530287.0
2007-11-12	AGG	ETF	100.5	100.84	100.5	100.66	224000.0
2007-11-12	AIQ	ETF	44.25	45.7495	44.25	45.45	69320.0
2007-11-12	AIS	ETF	1.12	1.14	1.07	1.1	400000.0
2007-11-12	AIVI	ETF	72.28	72.78	71.56	71.56	41900.0
2007-11-12	ARB	ETF	48.73	50.96	48.41	50.25	341100.0
2007-11-12	BBH	ETF	58.2967	58.62	57.7867	57.8767	360600.0
2007-11-12	BIL	ETF	91.74	91.78	91.72	91.78	72400.0
2007-11-12	BITS	ETF	25.24	25.24	23.32	24.0	25088.0
2007-11-12	BIV	ETF	76.85	76.85	76.7	76.8	18100.0
2007-11-12	BLV	ETF	76.3	76.49	76.24	76.39	7600.0
2007-11-12	BMVP	ETF	16.93	17.065	16.74	16.74	54750.0
2007-11-12	BND	ETF	76.0	76.47	76.0	76.47	47700.0
2007-11-12	BNE	ETF	16.73	17.12	16.68	16.8	150900.0
2007-11-12	BOSS	ETF	44.01	45.91	44.01	45.91	100.0
2007-11-12	BRF	ETF	14.41	14.68	14.41	14.68	2920.0
2007-11-12	BSV	ETF	76.69	76.8	76.69	76.7	22000.0
2007-11-12	BTF	ETF	111.99999999999999	112.65	110.8	111.05	1480.0
2007-11-12	BWX	ETF	28.015	28.015	27.155	27.225	173400.0
2007-11-12	CBON	ETF	19.56	20.95	19.56	20.08	146977.0
2007-11-12	CDL	ETF	2.69	2.86	2.4	2.7	7207856.0
2007-11-12	CEF	ETF	10.71	10.71	10.33	10.35	637800.0
2007-11-12	CGO	ETF	18.81	18.8699	18.5	18.65	14600.0
2007-11-12	CGW	ETF	25.65	25.65	24.8301	24.93	48700.0
2007-11-12	CHB	ETF	10.39	10.61	10.0	10.1	1757400.0
2007-11-12	CHI	ETF	14.98	15.12	14.78	14.78	217403.0
2007-11-12	CHIC	ETF	13.38	14.21	13.31	13.89	506473.0
2007-11-12	CHW	ETF	12.28	12.46	12.13	12.34	208900.0
2007-11-12	CHY	ETF	13.09	13.3	13.04	13.1	204942.0
2007-11-12	CMF	ETF	51.65	51.65	51.6	51.6	1400.0
2007-11-12	CN	ETF	52.39	52.85	50.5	50.9	392528.0
2007-11-12	CNXT	ETF	1.19	1.2	1.155	1.17	4862846.0
2007-11-12	COW	ETF	48.84	48.84	48.18	48.18	4000.0
2007-11-12	CPST	ETF	1.27	1.27	1.18	1.18	1757113.0
2007-11-12	CSA	ETF	16.35	16.91	16.26	16.39	104700.0
2007-11-12	CSD	ETF	27.28	27.37	26.91	26.93	22200.0
2007-11-12	CSQ	ETF	13.81	13.9299	13.56	13.57	252701.0
2007-11-12	CUT	ETF	24.29	24.4	24.25	24.25	22300.0
2007-11-12	CVY	ETF	24.45	24.73	24.4	24.41	4500.0
2007-11-12	CWI	ETF	28.2533	28.3133	27.9133	27.92	34200.0
2007-11-12	CZA	ETF	25.95	25.95	25.7	25.7	1800.0
2007-11-12	DBA	ETF	29.62	29.74	29.33	29.38	404000.0
2007-11-12	DBB	ETF	24.6	24.6	24.15	24.25	26900.0
2007-11-12	DBC	ETF	30.5	30.91	30.23	30.43	983600.0

> showing 50 of 528 rows — these rows as CSV

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