reportDate

ratio

endQuaterAffected

dayFrom

dayTo

Cusip

entryId	groupId	EQUITY	CHANGE	CUSIP	DESCRIPTION	ISSUE STATUS CODE	ISSUE TYPE CODE	ADD DATE	EXPIRATION DATE	PAYMENT FREQUENCY CODE	MARGIN FLAG	OPTION FLAG	CONVERTED CUSIP	NASDAQ MARKET CODE	INDEX ISSUER	CHANGE DATE	MERGENT CHANGE DATE	MATURE DATE	undefined1	undefined2	undefined3	undefined4	temp1	temp2	fileName	fileDate	processDate
5548728	5548728	DIVIDEND	ADD	88822Q103		0	0	1	0	.06		00	2024-05-17	2024-05-20	2024-05-28	2024-05-01		0	2024-05-01	?	0	0006915335			20240501.ifs	2024-05-01	2024-05-02
5505371	5505371	DIVIDEND	ADD	88822Q103		0	0	1	0	.06		00	2024-03-08	2024-03-11	2024-03-18	2024-02-27		0	2024-02-29	?	0	0006881242			20240229.ifs	2024-02-29	2024-03-01
5481301	5481301	DIVIDEND	ADD	88822Q103		0	0	1	0	.05		00	2023-11-17	2023-11-20	2023-11-27	2023-10-31		0	2024-01-17	?	0	0006864802			20240117.ifs	2024-01-17	2024-01-18
5348912	5348912	DIVIDEND	ADD	88822Q103		0	0	1	0	.05		00	2023-08-18	2023-08-21	2023-08-28	2023-08-02		0	2023-08-02	?	0	0006766995			20230802.ifs	2023-08-02	2023-08-03
5286570	5286570	DIVIDEND	ADD	88822Q103		0	0	1	0	.05		00	2023-05-19	2023-05-22	2023-05-30	2023-05-03		0	2023-05-03	?	0	0006723550			20230503.ifs	2023-05-03	2023-05-04
5246104	5246104	DIVIDEND	ADD	88822Q103		0	0	1	0	.05		00	2023-03-17	2023-03-20	2023-03-27	2023-03-08		0	2023-03-08	?	0	0006694232			20230308.ifs	2023-03-08	2023-03-09
5135544	5135544	DIVIDEND	ADD	88822Q103		0	0	1	0	.04		00	2022-11-18	2022-11-21	2022-11-28	2022-11-01		0	2022-11-03	?	0	0006610893			20221103.ifs	2022-11-03	2022-11-04
5075911	5075911	DIVIDEND	ADD	88822Q103		0	0	1	0	.04		00	2022-08-19	2022-08-22	2022-08-29	2022-08-08		0	2022-08-08	?	0	0006568643			20220808.ifs	2022-08-08	2022-08-09
5009072	5009072	DIVIDEND	ADD	88822Q103		0	0	1	0	.04		00	2022-05-20	2022-05-23	2022-05-31	2022-05-03		0	2022-05-06	?	0	0006522537			20220506.ifs	2022-05-06	2022-05-07
4968625	4968625	DIVIDEND	ADD	88822Q103		0	0	1	0	.04		00	2022-03-18	2022-03-21	2022-03-28	2022-03-08		0	2022-03-10	?	0	0006492927			20220310.ifs	2022-03-10	2022-03-11
4843856	4843856	DIVIDEND	ADD	88822Q103		0	0	1	0	.04		00	2021-11-19	2021-11-22	2021-11-29	2021-11-02		0	2021-11-04	?	0	0006394995			20211104.ifs	2021-11-04	2021-11-05
4777642	4777642	DIVIDEND	ADD	88822Q103		0	0	1	0	.04		00	2021-08-20	2021-08-23	2021-08-30	2021-08-03		0	2021-08-05	?	0	0006352011			20210805.ifs	2021-08-05	2021-08-06
4700231	4700231	DIVIDEND	ADD	88822Q103		0	0	1	0	.04		00	2021-05-21	2021-05-24	2021-06-01	2021-05-05		0	2021-05-05	?	0	0006306024			20210505.ifs	2021-05-05	2021-05-06
4651337	4651337	DIVIDEND	ADD	88822Q103		0	0	1	0	.04		00	2021-03-19	2021-03-22	2021-03-29	2021-03-11		0	2021-03-11	?	0	0006276542			20210311.ifs	2021-03-11	2021-03-12
4503219	4503219	DIVIDEND	ADD	88822Q103		0	0	1	0	.04		00	2020-11-20	2020-11-23	2020-11-30	2020-11-02		0	2020-11-05	?	0	0006186859			20201105.ifs	2020-11-05	2020-11-06
4436891	4436891	DIVIDEND	ADD	88822Q103		0	0	1	0	.04		00	2020-08-21	2020-08-24	2020-08-31	2020-08-04		0	2020-08-06	?	0	0006142662			20200806.ifs	2020-08-06	2020-08-07
4327543	4327543	DIVIDEND	ADD	88822Q103		0	0	1	0	.04		00	2020-05-15	2020-05-18	2020-05-25	2020-05-05		0	2020-05-07	?	0	0006097302			20200507.ifs	2020-05-07	2020-05-08
4327544	4327544	DIVIDEND	ADD	88822Q103		0	0	1	0	.04		00	2020-05-15	2020-05-18	2020-05-25	2020-05-05		0	2020-05-07	?	0	0006097302			20200507.ifs	2020-05-07	2020-05-08
4237757	4237757	DIVIDEND	ADD	88822Q103		0	0	1	0	.04		00	2020-03-20	2020-03-23	2020-03-30	2020-03-11		0	2020-03-11	?	0	0006068084			20200311.ifs	2020-03-11	2020-03-12
4237783	4237783	DIVIDEND	ADD	88822Q103		0	0	1	0	.04		00	2020-03-20	2020-03-23	2020-03-30	2020-03-11		0	2020-03-11	?	0	0006068084			20200311.ifs	2020-03-11	2020-03-12
4007224	4007224	DIVIDEND	ADD	88822Q103		0	0	1	0	.04		00	2019-11-15	2019-11-18	2019-11-25	2019-11-06		0	2019-11-06	?	0	0005973945			20191106.ifs	2019-11-06	2019-11-07
4007225	4007225	DIVIDEND	ADD	88822Q103		0	0	1	0	.04		00	2019-11-15	2019-11-18	2019-11-25	2019-11-06		0	2019-11-06	?	0	0005973945			20191106.ifs	2019-11-06	2019-11-07
3871589	3871589	DIVIDEND	ADD	88822Q103		0	0	1	0	.04		00	2019-08-16	2019-08-19	2019-08-26	2019-08-05		0	2019-08-05	?	0	0005928619			20190805.ifs	2019-08-05	2019-08-06
3871592	3871592	DIVIDEND	ADD	88822Q103		0	0	1	0	.04		00	2019-08-16	2019-08-19	2019-08-26	2019-08-05		0	2019-08-05	?	0	0005928619			20190805.ifs	2019-08-05	2019-08-06
3719118	3719118	DIVIDEND	ADD	88822Q103		0	0	1	0	.04		00	2019-05-17	2019-05-20	2019-05-27	2019-05-02		0	2019-05-07	?	0	0005882118			20190507.ifs	2019-05-07	2019-05-08
3719131	3719131	DIVIDEND	ADD	88822Q103		0	0	1	0	.04		00	2019-05-17	2019-05-20	2019-05-27	2019-05-02		0	2019-05-07	?	0	0005882118			20190507.ifs	2019-05-07	2019-05-08
3625426	3625426	DIVIDEND	ADD	88822Q103		0	0	1	0	.035		00	2019-03-22	2019-03-25	2019-04-01	2019-03-13		0	2019-03-13	?	0	0005851901			20190313.ifs	2019-03-13	2019-03-14
3625427	3625427	DIVIDEND	ADD	88822Q103		0	0	1	0	.035		00	2019-03-22	2019-03-25	2019-04-01	2019-03-13		0	2019-03-13	?	0	0005851901			20190313.ifs	2019-03-13	2019-03-14
3364109	3364109	DIVIDEND	ADD	88822Q103		0	0	1	0	.035		00	2018-11-16	2018-11-19	2018-11-26	2018-11-01		0	2018-11-06	?	0	0005752802			20181106.ifs	2018-11-06	2018-11-07
3364124	3364124	DIVIDEND	ADD	88822Q103		0	0	1	0	.035		00	2018-11-16	2018-11-19	2018-11-26	2018-11-01		0	2018-11-06	?	0	0005752802			20181106.ifs	2018-11-06	2018-11-07
3232132	3232132	DIVIDEND	ADD	88822Q103		0	0	1	0	.035		00	2018-08-17	2018-08-20	2018-08-27	2018-08-02		0	2018-08-07	?	0	0005706637			20180807.ifs	2018-08-07	2018-08-08
3232133	3232133	DIVIDEND	ADD	88822Q103		0	0	1	0	.035		00	2018-08-17	2018-08-20	2018-08-27	2018-08-02		0	2018-08-07	?	0	0005706637			20180807.ifs	2018-08-07	2018-08-08
3136597	3136597	CORPACTION	ADD	88822Q103	60	#	2018-06-13	88822Q103	60	?															20180613.ifs	2018-06-13	2018-06-14
3136599	3136599	CORPACTIONAUX	ADD	88822Q103	60	2018-06-13	TIPT			TIPT		COM	2018-06-13	?											20180613.ifs	2018-06-13	2018-06-14
3136602	3136602	EQUITY	CHANGE	88822Q103	CL A	0	0	2009-11-02	?	4	no	no		no		2013-07-02	2013-07-03	?							20180613.ifs	2018-06-13	2018-06-14
3136603	3136602	EQUITY	CHANGE	88822Q103	COM	0	0	2009-11-02	?	4	no	no		no		2013-07-02	2018-06-13	?							20180613.ifs	2018-06-13	2018-06-14
3136670	3136670	CORPACTION	ADD	88822Q103	60	#	2018-06-13	88822Q103	60	?															20180613.ifs	2018-06-13	2018-06-14
3136672	3136672	CORPACTIONAUX	ADD	88822Q103	60	2018-06-13	TIPT			TIPT		COM	2018-06-13	?											20180613.ifs	2018-06-13	2018-06-14
3136674	3136674	EQUITY	CHANGE	88822Q103	CL A	0	0	2009-11-02	?	4	no	no		no		2013-07-02	2013-07-03	?							20180613.ifs	2018-06-13	2018-06-14
3136675	3136674	EQUITY	CHANGE	88822Q103	COM	0	0	2009-11-02	?	4	no	no		no		2013-07-02	2018-06-13	?							20180613.ifs	2018-06-13	2018-06-14
3136769	3136769	CORPACTION	DELETE	88822Q103	60	#	2018-06-13	88822Q103	60	?															20180613.ifs	2018-06-13	2018-06-14
3136773	3136772	CORPACTION	DELETE	88822Q103	60	2018-06-13	TIPT			TIPT		COM	2018-06-13	?											20180613.ifs	2018-06-13	2018-06-14
3136843	3136843	CORPACTION	DELETE	88822Q103	60	#	2018-06-13	88822Q103	60	?															20180613.ifs	2018-06-13	2018-06-14
3136847	3136846	CORPACTION	DELETE	88822Q103	60	2018-06-13	TIPT			TIPT		COM	2018-06-13	?											20180613.ifs	2018-06-13	2018-06-14
3083531	3083531	DIVIDEND	ADD	88822Q103		0	0	1	0	.035		00	2018-05-18	2018-05-21	2018-05-29	2018-05-03		0	2018-05-08	?	0	0005659663			20180508.ifs	2018-05-08	2018-05-09
3083788	3083788	DIVIDEND	ADD	88822Q103		0	0	1	0	.035		00	2018-05-18	2018-05-21	2018-05-29	2018-05-03		0	2018-05-08	?	0	0005659663			20180508.ifs	2018-05-08	2018-05-09
2992273	2992273	DIVIDEND	ADD	88822Q103		0	0	1	0	.03		00	2018-03-23	2018-03-26	2018-04-02	2018-03-13		0	2018-03-15	?	0	0005629421			20180315.ifs	2018-03-15	2018-03-16
2992372	2992372	DIVIDEND	ADD	88822Q103		0	0	1	0	.03		00	2018-03-23	2018-03-26	2018-04-02	2018-03-13		0	2018-03-15	?	0	0005629421			20180315.ifs	2018-03-15	2018-03-16
2759316	2759316	DIVIDEND	ADD	88822Q103		0	0	1	0	.03		00	2017-11-17	2017-11-20	2017-11-27	2017-11-07		0	2017-11-07	?	0	0005527930			20171107.ifs	2017-11-07	2017-11-08
2759329	2759329	DIVIDEND	ADD	88822Q103		0	0	1	0	.03		00	2017-11-17	2017-11-20	2017-11-27	2017-11-07		0	2017-11-07	?	0	0005527930			20171107.ifs	2017-11-07	2017-11-08
2646023	2646023	DIVIDEND	ADD	88822Q103		0	0	1	0	.03		00	2017-08-17	2017-08-21	2017-08-28	2017-08-03		0	2017-08-08	?	0	0005481735			20170808.ifs	2017-08-08	2017-08-09
2565807	2565807	DIVIDEND	ADD	88822Q103		0	0	1	0	.03		00	2017-05-18	2017-05-22	2017-05-29	2017-05-11		0	2017-05-11	?	0	0005434509			20170511.ifs	2017-05-11	2017-05-12
2511956	2511956	DIVIDEND	ADD	88822Q103		0	0	1	0	.03		00	2017-03-23	2017-03-27	2017-04-03	2017-03-09		0	2017-03-14	?	0	0005401743			20170314.ifs	2017-03-14	2017-03-15
2446184	2446184	EQUITY	CHANGE	88822Q103	CL A	0	0	2009-11-02	?	0	no	no		no		2013-07-02	2013-07-03	?							20170123.ifs	2017-01-23	2017-01-24
2446185	2446184	EQUITY	CHANGE	88822Q103	CL A	0	0	2009-11-02	?	4	no	no		no		2013-07-02	2013-07-03	?							20170123.ifs	2017-01-23	2017-01-24
2421002	2421002	CORPACTION	ADD	88822Q103	60	#	2017-01-09	88822Q103	60	2017-01-09															20170109.ifs	2017-01-09	2017-01-10
2421003	2421003	CORPACTIONAUX	ADD	88822Q103	60	2017-01-09	TIPT	TIPTREE FINL INC	CL A	TIPT	TIPTREE INC	CL A	?	2017-01-09											20170109.ifs	2017-01-09	2017-01-10
2340781	2340781	DIVIDEND	ADD	88822Q103		0	0	1	0	.025		00	2016-11-17	2016-11-21	2016-11-28	2016-11-08		0	2016-11-08	?	0	0005310264			20161108.ifs	2016-11-08	2016-11-09
2267297	2267297	DIVIDEND	ADD	88822Q103		0	0	1	0	.025		00	2016-08-18	2016-08-22	2016-08-29	2016-08-05		0	2016-08-05	?	0	0005264167			20160805.ifs	2016-08-05	2016-08-06
2193848	2193848	DIVIDEND	ADD	88822Q103		0	0	1	0	.025		00	2016-05-19	2016-05-23	2016-05-30	2016-05-05		0	2016-05-10	?	0	0005217986			20160510.ifs	2016-05-10	2016-05-11
2136198	2136198	DIVIDEND	DELETE	88822Q103		0	0	1	0	.025		00	2016-02-19	2016-03-25	2016-04-01	2016-03-15		0	2016-03-15	?	0	0005187119			20160316.ifs	2016-03-16	2016-03-17
2136199	2136199	DIVIDEND	ADD	88822Q103		0	0	1	0	.025		00	2016-03-22	2016-03-25	2016-04-01	2016-03-15		1	2016-03-15	2016-03-16	0	0005187119			20160316.ifs	2016-03-16	2016-03-17
2135229	2135229	DIVIDEND	ADD	88822Q103		0	0	1	0	.025		00	2016-02-19	2016-03-25	2016-04-01	2016-03-15		0	2016-03-15	?	0	0005187119			20160315.ifs	2016-03-15	2016-03-16
2008726	2008726	DIVIDEND	ADD	88822Q103		0	0	1	0	.025		00	2015-11-19	2015-11-23	2015-11-30	2015-11-13		0	2015-11-13	?	0	0005093262			20151113.ifs	2015-11-13	2015-11-14
1940531	1940531	DIVIDEND	ADD	88822Q103		0	0	1	0	.025		00	2015-08-20	2015-08-24	2015-08-31	2015-08-10		0	2015-08-13	?	0	0005046920			20150813.ifs	2015-08-13	2015-08-14
1864161	1864161	DIVIDEND	ADD	88822Q103		0	0	1	0	.025		00	2015-05-20	2015-05-25	2015-06-01	2015-05-15		0	2015-05-15	?	0	0005000644			20150515.ifs	2015-05-15	2015-05-16
1830483	1830483	DIVIDEND	DELETE	88822Q103		0	0	1	0	.025		00	2015-04-21	2015-04-23	2015-04-09	2015-03-31		0	2015-03-31	?	0	0004977469			20150401.ifs	2015-04-01	2015-04-02
1830484	1830484	DIVIDEND	ADD	88822Q103		0	0	1	0	.025		00	2015-04-07	2015-04-09	2015-04-23	2015-03-26		1	2015-03-31	2015-04-01	0	0004977469			20150401.ifs	2015-04-01	2015-04-02
1826063	1826063	DIVIDEND	ADD	88822Q103		0	0	1	0	.025		00	2015-04-21	2015-04-23	2015-04-09	2015-03-31		0	2015-03-31	?	0	0004977469			20150331.ifs	2015-03-31	2015-04-01
1552188	1552188	DIVIDEND	ADD	88822Q103		0	0	E	0	0		58	?	?	2014-03-05	2014-06-18		0	2014-06-18	?	0	0004797605			20140618.ifs	2014-06-18	2014-06-19
1266819	1266819	DIVIDEND	ADD	88822Q103		0	0	1	0	.02		00	2013-08-20	2013-08-22	2013-09-05	2013-08-08		0	2013-08-19	?	0	0004616293			20130819.ifs	2013-08-19	2013-08-20
1263348	1263348	CORPACTION	ADD	88822Q103	66	X	2013-08-13	88822Q103	60	?															20130813.ifs	2013-08-13	2013-08-14
1263349	1263349	EXCHANGE	ADD	88822Q103	60	2013-08-13	2013-08-13	TIPT	0	0	2013-08-13	?													20130813.ifs	2013-08-13	2013-08-14
1263740	1263740	EQUITY	CHANGE	88822Q103	CL A	N	0	2009-11-02	?	0	no	no		no		2013-07-02	2013-07-03	?							20130813.ifs	2013-08-13	2013-08-14
1263741	1263740	EQUITY	CHANGE	88822Q103	CL A	0	0	2009-11-02	?	0	no	no		no		2013-07-02	2013-07-03	?							20130813.ifs	2013-08-13	2013-08-14
1234384	1234384	EQUITY	CHANGE	88822Q103	COM	N	0	2009-11-02	?	0	no	no		no		2013-07-02	?	?							20130703.ifs	2013-07-03	2013-07-04
1234385	1234384	EQUITY	CHANGE	88822Q103	CL A	N	0	2009-11-02	?	0	no	no		no		2013-07-02	2013-07-03	?							20130703.ifs	2013-07-03	2013-07-04
1234806	1234806	EXCHANGE	ADD	88822Q103	66	2013-07-03	?	CVTR	0	0	2013-07-03	?													20130703.ifs	2013-07-03	2013-07-04
1232371	1232371	EQUITY	ADD	88822Q103	COM	N	0	2009-11-02	?	0	no	no		no		2013-07-02	?	?							20130702.ifs	2013-07-02	2013-07-03

Old Cusip

entryId

groupId

EQUITY

CHANGE

CUSIP

DESCRIPTION

ISSUE STATUS CODE

ISSUE TYPE CODE

ADD DATE

EXPIRATION DATE

PAYMENT FREQUENCY CODE

MARGIN FLAG

OPTION FLAG

CONVERTED CUSIP

NASDAQ MARKET CODE

INDEX ISSUER

CHANGE DATE

MERGENT CHANGE DATE

MATURE DATE

undefined1

undefined2

undefined3

undefined4

temp1

temp2

fileName

fileDate

processDate

BACK UP Institutions before committing
SELECT institutionciklist.institutionid AS theinstitutionID, institutionciklist.institutionCik, institutionciklist.institutionName, institutionciklist.isGuru, all13ffilings. * , current13Fpositions. *
FROM current13Fpositions, all13ffilings, institutionciklist
WHERE current13Fpositions.compid = 151586
AND all13ffilings.entryId = current13Fpositions.linkID
AND all13ffilings.institutionid = institutionciklist.institutionid
AND institutionciklist.alive ='yes'
AND all13ffilings.done ='yes'
AND reportDate >='2012-06-30'
ORDER BY value ASC