Skip to content

Instantly share code, notes, and snippets.

@erichnascimento

erichnascimento/BRAZIL_BACEN_BANK_LIST_INSERT.sql

Last active August 25, 2023 21:25
Show Gist options
  • Save erichnascimento/7a356d568d2b7ef8c629813233a4496b to your computer and use it in GitHub Desktop.
Save erichnascimento/7a356d568d2b7ef8c629813233a4496b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
BRAZIL_BACEN_BANK_LIST_INSERT.sql
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('113cd26a-e451-4a86-8fef-e30d353860f3', 'BCO DO BRASIL S.A.', '0', '1', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('2abd0e9c-8a84-406c-8e85-60b9c27ff52d', 'BRB - BCO DE BRASILIA S.A.', '208', '70', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('a67e2928-9a99-4688-b66f-e27a61a0af84', 'SANTINVEST S.A. - CFI', '122327', '539', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('a7c6613f-08b6-4303-8a6a-68f949f8d290', 'CCR SEARA', '204963', '430', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('b7100d66-f3b5-4968-83b3-967f3c0da6fa', 'AGK CC S.A.', '250699', '272', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('e0f27caf-eaf4-4411-9c67-e99d047d9826', 'CONF NAC COOP CENTRAIS UNICRED', '315557', '136', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('be4b7e5e-e195-4d93-b383-23dd1c55d795', 'ÍNDIGO INVESTIMENTOS DTVM LTDA.', '329598', '407', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('96a88d34-76f2-4161-9072-e03b5a4bc1a5', 'CAIXA ECONOMICA FEDERAL', '360305', '104', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('4ce4bdb3-c387-4803-a8fa-dad659758ab5', 'BANCO INTER', '416968', '77', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('f7b999ee-3c1f-491d-95ba-ac8438f07ad8', 'COLUNA S.A. DTVM', '460065', '423', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('6ec32b9b-5f18-480e-926d-1a0d5b42b5a2', 'BCO RIBEIRAO PRETO S.A.', '517645', '741', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('96591bb4-515b-4c9e-b9ee-d867e64783d0', 'BANCO BARI S.A.', '556603', '330', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('8e4f50e8-d5c3-4052-ae29-1e8563214864', 'BCO CETELEM S.A.', '558456', '739', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('763bcd7b-a8c5-4d07-b76c-6e3caf5cbe91', 'EWALLY IP S.A.', '714671', '534', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('e61e2c7d-18be-48f0-b1d1-e46a5367ab79', 'BANCO SEMEAR', '795423', '743', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('a73e1594-c637-4b6c-9e27-8071622d8e4f', 'PLANNER CV S.A.', '806535', '100', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('7ffe7d22-ba15-474b-a8dc-7f3f12b8b726', 'FDO GARANTIDOR CRÉDITOS', '954288', '541', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('7803f83b-112e-470a-987f-88d3d09c28ef', 'BCO B3 S.A.', '997185', '96', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('306c599d-8ef2-4034-bdbb-13da331a61c1', 'BCO RABOBANK INTL BRASIL S.A.', '1023570', '747', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('42bfd584-8fe4-4237-b76d-475046095a89', 'CIELO IP S.A.', '1027058', '362', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('80801f7b-3790-48ec-bcc7-ad3bcca595e7', 'CCR DE ABELARDO LUZ', '1073966', '322', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('709f506c-cc7b-4a43-8d4f-1d2e704e5ea9', 'BCO COOPERATIVO SICREDI S.A.', '1181521', '748', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('9d251af6-137b-4ae8-a571-76bbb7dd3604', 'CREHNOR LARANJEIRAS', '1330387', '350', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('c9aee164-80c1-4f72-ab00-ee742341d25d', 'BCO BNP PARIBAS BRASIL S A', '1522368', '752', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('193dd5b4-8d6b-4357-a9ae-87528516da73', 'CECM COOPERFORTE', '1658426', '379', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('ebef6888-9d14-4402-ac06-1edd417afaf7', 'KIRTON BANK', '1701201', '399', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('c5d2bb81-92b6-4971-a3a3-11ee38af2fac', 'BCO BRASILEIRO DE CRÉDITO S.A.', '1852137', '378', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('0df15dd6-de2c-4b25-a54b-acdad351726e', 'BCO BV S.A.', '1858774', '413', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('98945348-f200-4d20-a422-3c3ababda193', 'BANCO SICOOB S.A.', '2038232', '756', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('4d1aaa97-0a3e-4886-afa1-c29e29fc73bf', 'TRINUS CAPITAL DTVM', '2276653', '360', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('3d96a14c-041d-4ec7-ab41-1f4a70f8d934', 'BCO KEB HANA DO BRASIL S.A.', '2318507', '757', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('c3826d68-91c0-4fa5-a178-b9c561c49e03', 'XP INVESTIMENTOS CCTVM S/A', '2332886', '102', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('a5aba684-c53e-49ac-a1b7-c3c9984443de', 'SISPRIME DO BRASIL - COOP', '2398976', '84', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('3d840fcd-1c70-4f6a-a631-8c6856cfa747', 'CM CAPITAL MARKETS CCTVM LTDA', '2685483', '180', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('20196f08-44da-467e-b500-a121347ab864', 'BCO MORGAN STANLEY S.A.', '2801938', '66', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('105f3c11-c692-4ef2-af03-0c942f0ceab3', 'UBS BRASIL CCTVM S.A.', '2819125', '15', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('222fa643-f209-4b7b-9609-d12bcc11f449', 'TREVISO CC S.A.', '2992317', '143', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('ad701ae0-1594-4f54-b4b3-4cdea06fb4e2', 'HIPERCARD BM S.A.', '3012230', '62', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('d002c35f-2858-445a-a164-c0803dad9fc4', 'BCO. J.SAFRA S.A.', '3017677', '74', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('17e46b22-68d4-4da1-b8db-ae0aff52c8b2', 'UNIPRIME COOPCENTRAL LTDA.', '3046391', '99', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('69459387-00fa-4abc-b41f-312b321feef7', 'BCO TOYOTA DO BRASIL S.A.', '3215790', '387', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('85e6331f-aa89-4f37-b0a3-e7c7a6ea38d4', 'PARATI - CFI S.A.', '3311443', '326', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('7b605d4e-9a58-408e-8462-14789bd8fd35', 'BCO ALFA S.A.', '3323840', '25', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('50278392-dee7-4dfa-8946-494f12e3a4e2', 'BCO ABN AMRO S.A.', '3532415', '75', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('fac1d92a-1290-4797-92dd-55b5f689b378', 'BCO CARGILL S.A.', '3609817', '40', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('44827062-5d1c-43de-a569-0553ef99febc', 'TERRA INVESTIMENTOS DTVM', '3751794', '307', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('c00dc67e-d062-44e3-943c-8a85323aacd7', 'CECM DOS TRAB.PORT. DA G.VITOR', '3844699', '385', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('c7ad932d-9996-435e-9089-4d73234d2142', 'SOCINAL S.A. CFI', '3881423', '425', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('83ab84d0-75b9-4251-897d-8657b44675dc', 'SERVICOOP', '3973814', '190', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('10eb0a85-a57f-4ab1-96f4-f164c39736ae', 'OZ CORRETORA DE CÂMBIO S.A.', '4062902', '296', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('b2392a4e-713d-42dd-b85d-e623011eddd1', 'BANCO BRADESCARD', '4184779', '63', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('2977d66f-1c8b-4117-b424-ac527547688e', 'NOVA FUTURA CTVM LTDA.', '4257795', '191', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('e7da5450-807e-4cda-9276-5fe9dcb014ef', 'FIDUCIA SCMEPP LTDA', '4307598', '382', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('16f1a71d-d7a6-406d-8d4c-88b4a5afc27c', 'GOLDMAN SACHS DO BRASIL BM S.A', '4332281', '64', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('43f7b700-325a-4d0b-9824-0c29051b1260', 'CCM SERV. PÚBLICOS SP', '4546162', '459', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('c914e4d9-f985-4c5e-9b8e-3e4811f71842', 'CREDISIS CENTRAL DE COOPERATIVAS DE CRÉDITO LTDA.', '4632856', '97', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('3223aefc-7d98-4637-90ca-098a01cf9534', 'CCM DESP TRÂNS SC E RS', '4715685', '16', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('2d28c8fd-9b68-4286-8c74-77559334a5df', 'BCO AFINZ S.A. - BM', '4814563', '299', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('2cfbbf90-92d4-481c-b334-497bdf5363e0', 'CECM SERV PUBL PINHÃO', '4831810', '471', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('79099325-51fd-4a11-bfde-7359d2870698', 'PORTOSEG S.A. CFI', '4862600', '468', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('9cba0152-b431-4933-97bf-959dfc7128e6', 'BANCO INBURSA', '4866275', '12', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('acd3fe86-640f-4d29-b9e9-cec5fb6e6934', 'BCO DA AMAZONIA S.A.', '4902979', '3', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('9b1c0df1-0512-4bd0-be4e-f5eec718d186', 'CONFIDENCE CC S.A.', '4913129', '60', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('fdb97c96-1a12-4d3c-83f2-b2eda43c2853', 'BCO DO EST. DO PA S.A.', '4913711', '37', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('f0ec82f6-478b-4ded-93eb-0dbbdf3544eb', 'VIA CERTA FINANCIADORA S.A. - CFI', '5192316', '411', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('24515767-796c-4db4-9ee0-d0693a354913', 'ZEMA CFI S/A', '5351887', '359', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('f37b0fc0-ee7e-49eb-9454-1d5a686158ff', 'CASA CREDITO S.A. SCM', '5442029', '159', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('f01b0878-1727-4791-8de7-f88ee18737d7', 'COOPCENTRAL AILOS', '5463212', '85', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('88153eab-7692-4d9f-aeaf-b71e2402c18a', 'COOP CREDITAG', '5491616', '400', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('c5950547-57c0-45d9-b5bb-93a65cac1291', 'CREDIARE CFI S.A.', '5676026', '429', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('db32c6cc-c698-4baf-ab87-0f75152ff84b', 'PLANNER SOCIEDADE DE CRÉDITO DIRETO', '5684234', '410', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('14bcd49c-5dba-40e9-949c-4a1da8474692', 'CENTRAL COOPERATIVA DE CRÉDITO NO ESTADO DO ESPÍRITO SANTO', '5790149', '114', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('ddaaa4c5-b1aa-4a8e-9ad0-fabb0c0a72c3', 'CECM FABRIC CALÇADOS SAPIRANGA', '5841967', '328', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('ad6e6c8e-f56c-4e4a-b7b3-97bdacbb796d', 'BCO BBI S.A.', '6271464', '36', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('12d6153b-4d67-4b63-a784-8bce737aa512', 'LIGA INVEST DTVM LTDA.', '7138049', '469', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('5a4a6b92-dec3-43c2-86c5-d50a14287c56', 'BCO BRADESCO FINANC. S.A.', '7207996', '394', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('965788d4-44cc-4c21-af41-174e90112c3b', 'BCO DO NORDESTE DO BRASIL S.A.', '7237373', '4', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('3d16702f-43fb-4d29-9128-24b1473df97f', 'HEDGE INVESTMENTS DTVM LTDA.', '7253654', '458', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('2299f4f4-c9dc-4411-9fad-b8f78315ad98', 'BCO CCB BRASIL S.A.', '7450604', '320', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('c0036e3c-66a9-4ce8-902a-575a6441b9fd', 'HS FINANCEIRA', '7512441', '189', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('bef191c0-d60d-40a3-b784-74d9afdb8e19', 'LECCA CFI S.A.', '7652226', '105', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('a13dde0a-6f92-41b7-8dba-88897e5c3934', 'BCO KDB BRASIL S.A.', '7656500', '76', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('80cf474d-722a-4092-af9f-439c74ba5962', 'BANCO TOPÁZIO S.A.', '7679404', '82', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('bfb97a6f-2302-45bf-b8a9-8c0126e6ac3f', 'HSCM SCMEPP LTDA.', '7693858', '312', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('8776ef28-f3e3-4826-921c-dadc4d9d62a6', 'VALOR SCD S.A.', '7799277', '195', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('2e38ecdc-ba86-4b78-bab0-5ca9665583c0', 'POLOCRED SCMEPP LTDA.', '7945233', '93', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('e561fc67-cb33-4267-9e24-a348bb66ccfd', 'CCR DE IBIAM', '8240446', '391', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('001bb168-de0b-4abb-b394-3c9eb9509f25', 'CCR DE SÃO MIGUEL DO OESTE', '8253539', '273', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('b556ef6e-b701-4a88-8627-b8d9b3030beb', 'BCO CSF S.A.', '8357240', '368', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('ab474cbf-524a-457e-a631-c1751aa29075', 'PAGSEGURO INTERNET IP S.A.', '8561701', '290', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('4d6e891d-0640-44aa-bace-be3bc887f228', 'MONEYCORP BCO DE CÂMBIO S.A.', '8609934', '259', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('bdc083d0-b661-4060-9d95-6b1e333787fc', 'F D GOLD DTVM LTDA', '8673569', '395', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('f39cd924-e0dc-48ec-bc8e-dc65a32f77f6', 'EFÍ S.A. - IP', '9089356', '364', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('369dcbfc-4c0a-4296-8457-25a926d735d4', 'ICAP DO BRASIL CTVM LTDA.', '9105360', '157', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('eb5dda4a-7138-4ba2-adb2-27b15c35aa81', 'SOCRED SA - SCMEPP', '9210106', '183', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('fbceb7b5-daa0-4fb5-87dd-d233247a1c29', 'STATE STREET BR S.A. BCO COMERCIAL', '9274232', '14', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('de8f9914-012f-4ae5-992f-581eea2e4be7', 'CARUANA SCFI', '9313766', '130', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('92bfde4d-7ba0-49c3-848a-ccaa1ddb33ff', 'MIDWAY S.A. - SCFI', '9464032', '358', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('019c82aa-f20b-4a90-814f-f02f2f194f9e', 'CODEPE CVC S.A.', '9512542', '127', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('b6852a4f-05e1-4828-973e-ec36b90b4d3d', 'PICPAY BANK - BANCO MÚLTIPLO S.A', '9516419', '79', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('4979bd5b-9c5f-46d0-b7ed-93177a8af7e4', 'MASTER BI S.A.', '9526594', '141', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('adb5f20c-f113-447e-a811-8768ea512c52', 'SUPERDIGITAL I.P. S.A.', '9554480', '340', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('4ba36aae-9c15-4cbb-bf45-50088e8d37bf', 'BANCOSEGURO S.A.', '10264663', '81', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('43731663-f7d5-4baf-b655-eb0cde21bc16', 'BCO YAMAHA MOTOR S.A.', '10371492', '475', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('43624a39-6b91-4b19-8705-6945daed1c34', 'CRESOL CONFEDERAÇÃO', '10398952', '133', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('67e7e65e-82f4-4c06-bc52-f9e2fe545878', 'MERCADO PAGO IP LTDA.', '10573521', '323', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('5a9b8b0d-2e30-40dc-ab96-63e7df97cd5d', 'BCO AGIBANK S.A.', '10664513', '121', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('49d6dc6a-ab89-40ae-a2f8-cfba5706dca9', 'BCO DA CHINA BRASIL S.A.', '10690848', '83', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('406aa643-3ccd-45a3-a822-48ab725fdf5b', 'GET MONEY CC LTDA', '10853017', '138', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('4b87c3c4-2a21-40eb-bb97-a20f71d7498e', 'BCO BANDEPE S.A.', '10866788', '24', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('6b89e6a6-c415-458d-9156-326a03b475a5', 'GLOBAL SCM LTDA', '11165756', '384', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('c5f14b4c-0ea4-46fc-aecd-4ceb09c5dd1f', 'NEON FINANCEIRA - CFI S.A.', '11285104', '426', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('c13bb79d-ecd7-4676-951e-e7020c90d2cb', 'BANCO RANDON S.A.', '11476673', '88', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('bb098285-9a69-483a-b852-537bc0d756c8', 'OM DTVM LTDA', '11495073', '319', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('d1415ce6-905b-4367-b9ca-68967368d3e8', 'BMP SCMEPP LTDA', '11581339', '274', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('76982526-1f8a-489c-bb2e-3524effee3fc', 'TRAVELEX BANCO DE CÂMBIO S.A.', '11703662', '95', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('5cc27f1a-ff6c-4d34-9044-de9f9ff37ee2', 'BANCO FINAXIS', '11758741', '94', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('8be247a2-d89f-4cd4-a135-2f7f616debfb', 'GAZINCRED S.A. SCFI', '11760553', '478', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('ebe86434-95b2-4070-a7c3-4d3776906c4a', 'BCO SENFF S.A.', '11970623', '276', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('43a09e61-e56e-4293-9dff-60f8e0b5a54e', 'MIRAE ASSET CCTVM LTDA', '12392983', '447', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('9440e4d3-2b12-4096-a55e-a11f50492b62', 'BCO DO EST. DE SE S.A.', '13009717', '47', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('ab9ca364-cf83-4736-973c-cdd4e9a93018', 'BEXS BCO DE CAMBIO S.A.', '13059145', '144', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('5143545f-db0e-4bc6-968e-33a354736da9', 'ACESSO SOLUÇÕES DE PAGAMENTO S.A. - INSTITUIÇÃO DE PAGAMENTO', '13140088', '332', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('ba666a5c-1c97-41aa-b703-0832be0babec', 'FITBANK IP', '13203354', '450', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('9acc52cd-aa73-45d9-ab93-8a6fdc509881', 'BR PARTNERS BI', '13220493', '126', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('60ba124d-7b85-4c2a-9ba1-f02b760b40ad', 'ÓRAMA DTVM S.A.', '13293225', '325', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('0a202244-c0eb-4d2f-a02e-2fea0d64f1f1', 'DOCK IP S.A.', '13370835', '301', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('8b4bdb3d-54c4-4dd1-8a3e-4e62c2afe27c', 'BRL TRUST DTVM SA', '13486793', '173', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('de217bbf-1317-4316-93e0-0c8186685d37', 'FRAM CAPITAL DTVM S.A.', '13673855', '331', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('a5ad9840-4654-4f82-bfc1-9652b18a9331', 'BCO WESTERN UNION', '13720915', '119', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('c71a464f-b1f2-4334-a917-ac2c10e341d5', 'HUB IP S.A.', '13884775', '396', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('81ebf11e-89c6-46c3-95bd-4dc9d986c14d', 'CELCOIN IP S.A.', '13935893', '509', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('1785f967-007f-472c-8d92-9de7bb6158be', 'CAMBIONET CC LTDA', '14190547', '309', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('705e2fae-672c-4447-90bf-e5fb3bd11d93', 'PARANA BCO S.A.', '14388334', '254', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('91ce9f70-6dc6-46e1-96bd-db9e2c9400b2', 'BARI CIA HIPOTECÁRIA', '14511781', '268', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('e3bd82ca-18c3-4e0d-929b-8f83b30e8dd6', 'IUGU IP S.A.', '15111975', '401', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('0891360f-8d58-4b20-8f5b-72dc6ac626bb', 'BCO BOCOM BBM S.A.', '15114366', '107', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('51fad4c5-8848-4d68-8a27-7a37752dea11', 'BANCO BESA S.A.', '15124464', '334', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('7313a959-34c5-4ace-8641-cf48847352b2', 'SOCIAL BANK S/A', '15173776', '412', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('bf82d7d7-9e1d-4ac1-be5d-6eb071cb665a', 'BCO WOORI BANK DO BRASIL S.A.', '15357060', '124', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('6fff370a-e69c-44e2-8f3c-48ad37f5dcd1', 'FACTA S.A. CFI', '15581638', '149', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('14bf04b3-1d77-476c-980d-cf78727f28b4', 'STONE IP S.A.', '16501555', '197', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('24476730-4dc0-4b7d-b31c-7375f4b7529d', 'ID CTVM', '16695922', '439', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('083dd423-f4b8-471c-afc9-3c1dd5af4e7d', 'AMAZÔNIA CC LTDA.', '16927221', '313', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('088ce4f8-b43a-4ed9-972a-8843f3e89d26', 'BROKER BRASIL CC LTDA.', '16944141', '142', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('f1097aab-0952-48ef-84fc-6d81aa034bd5', 'PINBANK IP', '17079937', '529', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('4e3d5d56-d665-473b-86b0-abeb7aca1551', 'BCO MERCANTIL DO BRASIL S.A.', '17184037', '389', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('5af7cf4f-5f17-4fab-83eb-aaa11bf9a621', 'BCO ITAÚ BBA S.A.', '17298092', '184', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('213384e9-2590-492c-9b35-20ce0d3286f0', 'BCO TRIANGULO S.A.', '17351180', '634', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('a34ffbde-6824-4d26-b4e2-ca3980cc3fea', 'SENSO CCVM S.A.', '17352220', '545', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('7761c196-874c-4bb6-ae8c-2ac477edf0e8', 'ICBC DO BRASIL BM S.A.', '17453575', '132', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('0f6c1c4b-5391-480c-a8b3-d5f17bde0c79', 'VIPS CC LTDA.', '17772370', '298', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('5e16e0ed-d9b5-475c-888a-d08c24bf0f28', 'BMS SCD S.A.', '17826860', '377', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('479f2c2d-fc8f-44a5-a6c1-52278b204223', 'CREFAZ SCMEPP LTDA', '18188384', '321', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('a4f9560d-98c9-4a4b-a0b0-cc5bd26436de', 'NU PAGAMENTOS - IP', '18236120', '260', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('c2a3d22c-2532-4525-a45b-7c6d2064ed99', 'CDC SCD S.A.', '18394228', '470', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('258ba795-d192-4f3a-82df-382fc11fd177', 'UBS BRASIL BI S.A.', '18520834', '129', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('6f3e2cf0-b513-48a4-ba97-66b0f43a658e', 'BRAZA BANK S.A. BCO DE CÂMBIO', '19307785', '128', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('025ba941-a4fc-4623-b982-701a48513b34', 'LAMARA SCD S.A.', '19324634', '416', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('469afa52-9e50-4cb1-a4df-62bc4d8b8238', 'ASAAS IP S.A.', '19540550', '461', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('6260d863-259d-4c94-aae0-7bfd1d281d5a', 'PARMETAL DTVM LTDA', '20155248', '194', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('fa54a610-645f-46be-b055-80dd257d991a', 'NEON PAGAMENTOS S.A. IP', '20855875', '536', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('2cb94235-2d49-469c-9677-b77852b0e913', 'EBANX IP LTDA.', '21018182', '383', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('0c66fbf1-7470-407a-a6cc-d18af93ef018', 'CARTOS SCD S.A.', '21332862', '324', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('31938102-9514-4e45-944e-cc1df9131c94', 'VORTX DTVM LTDA.', '22610500', '310', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('61a4d6df-4c93-433b-b2f9-ea6f8ea3e648', 'PICPAY', '22896431', '380', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('097ba12f-cd5b-4abd-8c77-b41b0a09a18c', 'WILL FINANCEIRA S.A.CFI', '23862762', '280', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('8597bc0b-2927-4663-b988-5ec12a48009d', 'GUITTA CC LTDA', '24074692', '146', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('9648c0ee-f20b-4085-8a0f-7b1d1a97c8cd', 'FFA SCMEPP LTDA.', '24537861', '343', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('ddf93125-5483-4b19-babb-d57afd76340b', 'COOP DE PRIMAVERA DO LESTE', '26563270', '279', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('0027597a-0f1e-4db7-a006-5723456be7f1', 'BANCO DIGIO', '27098060', '335', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('f9b0c8fa-ed65-455e-beea-36cef6b0e1b4', 'AL5 S.A. CFI', '27214112', '349', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('08225e2e-5e23-43f5-841f-1f14bf6e7994', 'CRED-UFES', '27302181', '427', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('4a001bd5-1f2f-4638-b74e-9346bc661357', 'REALIZE CFI S.A.', '27351731', '374', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('e4ac7407-d471-403f-9892-94aa1d415597', 'GENIAL INVESTIMENTOS CVM S.A.', '27652684', '278', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('1b4e5ee7-5082-480e-8e76-29ef72f054b4', 'IB CCTVM S.A.', '27842177', '271', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('8778dba9-38f9-44f0-82cb-8ecaef171e16', 'BCO BANESTES S.A.', '28127603', '21', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('8e34c06d-d5aa-4458-a855-6cc6a3eaa46c', 'BCO ABC BRASIL S.A.', '28195667', '246', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('f5e15fdf-83a5-42c8-a60a-afc4a4b16efa', 'BS2 DTVM S.A.', '28650236', '292', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('6e6dc05f-abee-49a4-945b-7d0bf5be0e45', 'SCOTIABANK BRASIL', '29030467', '751', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('2b95f64d-7b42-472b-8681-2cf007d041ed', 'TORO CTVM S.A.', '29162769', '352', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('5630b37a-8be2-4e9c-a6a5-0e4f7d432883', 'BANCO BTG PACTUAL S.A.', '30306294', '208', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('d7ec6d0f-cbdc-43b3-b781-1b2d840eceaf', 'NU FINANCEIRA S.A. CFI', '30680829', '386', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('c40f8c43-1082-42f6-b4f6-5a09ac2ec4e3', 'BCO MODAL S.A.', '30723886', '746', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('10493732-2906-49b8-9b53-201786af1fd1', 'U4C INSTITUIÇÃO DE PAGAMENTO S.A.', '30980539', '546', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('d29a61e0-2d48-425f-9bbb-6e8bbcf9f7f6', 'BCO CLASSICO S.A.', '31597552', '241', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('59daed5e-8d63-44d5-a319-d8fae7d5dbe3', 'IDEAL CTVM S.A.', '31749596', '398', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('9cd1f030-25a7-48df-b436-6db2fee14111', 'BCO C6 S.A.', '31872495', '336', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('03fc68d0-dba0-45e2-bd6d-321af812302a', 'BCO GUANABARA S.A.', '31880826', '612', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('f9025bfa-e872-4122-bdc2-458770a322ee', 'BCO INDUSTRIAL DO BRASIL S.A.', '31895683', '604', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('8e5068bc-ae84-427a-9dce-9c429a9da244', 'BCO CREDIT SUISSE S.A.', '32062580', '505', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('b470860b-5a4f-4306-9592-43ed09a25981', 'QI SCD S.A.', '32402502', '329', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('4d9b50ca-72b3-48bd-89b9-7e63e8df8187', 'FAIR CC S.A.', '32648370', '196', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('ece9f14a-13d2-4007-9b89-c22328b363c6', 'CREDITAS SCD', '32997490', '342', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('cbb1889a-7598-4437-a123-504b7430a768', 'BCO LA NACION ARGENTINA', '33042151', '300', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('bcac129e-8f80-47fb-a6c6-cbcff42c2214', 'CITIBANK N.A.', '33042953', '477', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('ada95704-b2e7-42f2-b8d2-35533700feaa', 'BCO CEDULA S.A.', '33132044', '266', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('19f1b55b-eb38-420d-ba09-44240423d665', 'BCO BRADESCO BERJ S.A.', '33147315', '122', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('8f975b69-36b2-4fde-b48c-661ad6079099', 'BCO J.P. MORGAN S.A.', '33172537', '376', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('562b1ac0-6f0e-4ab8-86e9-cff18e15ca40', 'BCO XP S.A.', '33264668', '348', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('d3ff843b-f124-425c-b443-3d9d6ffc6836', 'BCO CAIXA GERAL BRASIL S.A.', '33466988', '473', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('53db629e-5296-4ff6-875c-9c9938dadb44', 'BCO CITIBANK S.A.', '33479023', '745', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('917e34ff-291a-4815-84cc-cc0bc2b155a2', 'BCO RODOBENS S.A.', '33603457', '120', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('b20f917c-f483-4277-80b5-3c600d5c67e6', 'BCO FATOR S.A.', '33644196', '265', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('6f8e06ea-53fc-4edb-8799-a33b62a43c53', 'BNDES', '33657248', '7', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('f6122251-89a0-4723-8f03-6f63fb9bc6ea', 'ATIVA S.A. INVESTIMENTOS CCTVM', '33775974', '188', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('6ab4c28a-293b-4869-884f-1a0ae041cc0b', 'BGC LIQUIDEZ DTVM LTDA', '33862244', '134', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('b576b153-9439-43e0-87c4-8b2c1f3d3274', 'BANCO ITAÚ CONSIGNADO S.A.', '33885724', '29', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('f9e6e76a-4790-487e-be43-ef7c6462d31e', 'MASTER S/A CCTVM', '33886862', '467', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('f5fcc00f-f7eb-4001-871f-c58e48311a90', 'BANCO MASTER', '33923798', '243', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('4598d9ea-7415-4282-b439-78386e066a4a', 'LISTO SCD S.A.', '34088029', '397', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('b6813140-3312-4a92-8f74-9a153e28572a', 'HAITONG BI DO BRASIL S.A.', '34111187', '78', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('aded2cfa-2c95-49f4-8731-eec29a3a5e3c', 'INTERCAM CC LTDA', '34265629', '525', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('b51f5a78-1a97-4703-bedd-75570f4482b8', 'ÓTIMO SCD S.A.', '34335592', '355', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('96ec1027-a426-4603-94ad-108df0debe5a', 'VITREO DTVM S.A.', '34711571', '367', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('9b00f77a-bb82-41b2-89e1-4888db334e36', 'REAG DTVM S.A.', '34829992', '528', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('e81de889-1352-41d5-b12d-5ea5f3459dd6', 'PLANTAE CFI', '35551187', '445', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('13a8677f-a030-4e95-9512-2f76f050b6dd', 'UP.P SEP S.A.', '35977097', '373', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('8a7339ac-00b4-4300-9ed5-40eefe8f645e', 'OLIVEIRA TRUST DTVM S.A.', '36113876', '111', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('e391bc43-d568-4493-989f-5178bfbdb781', 'FINVEST DTVM', '36266751', '512', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('90cb5bc3-b531-4846-859f-f58bf295a841', 'QISTA S.A. CFI', '36583700', '516', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('5b012052-060b-4932-80e6-56cd0d99db0d', 'BONUSPAGO SCD S.A.', '36586946', '408', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('92c190b2-d908-40e8-b93f-950e0e87ca9b', 'MAF DTVM SA', '36864992', '484', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('cb072590-1e13-4466-8238-0cc22190ea06', 'COBUCCIO S.A. SCFI', '36947229', '402', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('b1529c8b-c650-46cb-8d2c-7e5dca869667', 'SCFI EFÍ S.A.', '37229413', '507', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('8213d511-e40f-4155-b0de-8a35802be9ec', 'SUMUP SCD S.A.', '37241230', '404', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('c6b103ed-e19c-4beb-9474-2c2da70e3eb7', 'ZIPDIN SCD S.A.', '37414009', '418', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('7fd1a1cc-fd7e-4b45-b90a-6c98d136dba9', 'LEND SCD S.A.', '37526080', '414', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('ed724da4-4e7e-4b6e-a88c-27df66ab2921', 'DM', '37555231', '449', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('d757c1b1-4d6c-492d-b3fc-4cd3cfe747df', 'MERCADO CRÉDITO SCFI S.A.', '37679449', '518', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('2bf4bc06-682e-4cf1-b0f9-6bab74404f91', 'ACCREDITO SCD S.A.', '37715993', '406', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('001bca91-e385-4acb-ac1b-4a4e4796182a', 'CORA SCD S.A.', '37880206', '403', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('95ccd88e-0c8b-4875-9d8a-5b8ed69fd361', 'NUMBRS SCD S.A.', '38129006', '419', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('807728f4-e27e-40b5-8c48-29ad53f3e590', 'DELCRED SCD S.A.', '38224857', '435', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('9e1697ae-66e9-4f7f-b06d-a195b245b30c', 'FÊNIX DTVM LTDA.', '38429045', '455', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('a4489a3f-c4a4-40f2-8b5e-ba2b8ee67c95', 'CC LAR CREDI', '39343350', '421', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('4715d350-9977-47cd-969e-028c80a34000', 'CREDIHOME SCD', '39416705', '443', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('81d5255b-5f46-406d-bdb6-c3ca091479e3', 'MARU SCD S.A.', '39519944', '535', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('1b16b7fa-12b6-414b-97ee-5791ba37eaff', 'UY3 SCD S/A', '39587424', '457', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('b495ee22-b48c-4220-9d88-a61a4e5fb34c', 'CREDSYSTEM SCD S.A.', '39664698', '428', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('b6926e19-b7ff-4afc-b23f-5fa99814b023', 'HEMERA DTVM LTDA.', '39669186', '448', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('3e69be38-b96a-4975-81bc-806b072d8cf0', 'CREDIFIT SCD S.A.', '39676772', '452', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('79899d62-0feb-4a4c-8384-36608998eea9', 'FFCRED SCD S.A.', '39738065', '510', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('7adc4f1f-5d72-46e1-b583-50e42cd3971b', 'STARK SCD S.A.', '39908427', '462', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('1a1ad7e1-121a-4ba1-b083-497d389e0dd8', 'CAPITAL CONSIG SCD S.A.', '40083667', '465', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('eae68751-bd53-43b1-b756-8eea33d2353e', 'PORTOPAR DTVM LTDA', '40303299', '306', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('f281e222-d316-423f-bac8-f26c303f2abd', 'AZUMI DTVM', '40434681', '463', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('7dbf49df-26e0-4063-bc22-e67b063701f5', 'J17 - SCD S/A', '40475846', '451', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('4014eae7-1167-4b66-a3f6-04553b5d0be1', 'TRINUS SCD S.A.', '40654622', '444', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('e449fe67-d3de-4792-906a-997484beccd5', 'LIONS TRUST DTVM', '40768766', '519', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('e7cf8ece-7a2e-4a45-a5b7-0340b78c5f3c', 'MÉRITO DTVM LTDA.', '41592532', '454', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('44dff363-a40d-4768-aac9-84a9521e5cdc', 'UNAVANTI SCD S/A', '42047025', '460', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('f60612e6-5ec3-4e21-bb37-d5020af2b630', 'RJI', '42066258', '506', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('d792a648-cc45-4fcb-81b9-329cb7c491d9', 'SBCASH SCD', '42259084', '482', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('accfcb65-081a-4532-bd5e-2dc8619df259', 'BNY MELLON BCO S.A.', '42272526', '17', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('0ed7f353-b9ea-4311-a32f-3b60068bdb03', 'PEFISA S.A. - C.F.I.', '43180355', '174', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('89f32a19-8073-4e76-8b27-4d7c339365ba', 'SUPERLÓGICA SCD S.A.', '43599047', '481', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('cf754ba8-f225-4558-a255-4fa6d57c27b5', 'PEAK SEP S.A.', '44019481', '521', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('51180245-a4ae-4c3a-b810-05c8014ca5c4', 'BR-CAPITAL DTVM S.A.', '44077014', '433', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('83364026-5550-45f1-86c8-e88e518b3ee4', 'BCO LA PROVINCIA B AIRES BCE', '44189447', '495', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('62557ddd-c7c8-4ac5-a1e9-deba854250b2', 'HR DIGITAL SCD', '44292580', '523', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('ab9c1b4e-b433-492a-b1b1-829b60d5d361', 'ATICCA SCD S.A.', '44478623', '527', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('8b732ec2-8bdd-40e6-9a7f-b66850710906', 'MAGNUM SCD', '44683140', '511', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('8219458e-95c9-4fa5-a2e9-0cae9795ddad', 'ATF CREDIT SCD S.A.', '44728700', '513', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('2c85f26d-976a-4f57-a62c-7a7f8c9992bf', 'BANCO GENIAL', '45246410', '125', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('ca4b541a-a9e4-4e2c-8154-f1b65ba25c46', 'EAGLE SCD S.A.', '45745537', '532', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('c693b158-dfb3-4dd0-b597-c217825dc080', 'MICROCASH SCMEPP LTDA.', '45756448', '537', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('c5fcfaf7-f6b8-4461-9223-ed90aa8ee18e', 'WNT CAPITAL DTVM', '45854066', '524', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('555a1356-39f8-42db-a243-808b43cbb94c', 'MONETARIE SCD', '46026562', '526', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('3af2493d-e297-4a29-a03c-6c8bccadacc9', 'JPMORGAN CHASE BANK', '46518205', '488', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('8d721048-b2b4-4f5f-9d0b-84d1c42b1a39', 'RED SCD S.A.', '47593544', '522', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('963ae53a-4d7b-4af7-983b-b9dcef88e588', 'SER FINANCE SCD S.A.', '47873449', '530', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('62ca286d-96e2-4de0-927f-5f95322c9d80', 'BCO ANDBANK S.A.', '48795256', '65', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('2005917a-f35b-400e-8dcf-1734dc2951c2', 'LEVYCAM CCV LTDA', '50579044', '145', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('c74d59b4-c72c-4247-8962-c7026a0fcbe1', 'BCV - BCO, CRÉDITO E VAREJO S.A.', '50585090', '250', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('9c39f892-4d93-40b0-bfca-0cba7e3bd48e', 'BEXS CC S.A.', '52937216', '253', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('8c6111c1-42fb-4322-ae61-526e73ab5217', 'BCO HSBC S.A.', '53518684', '269', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('3d4f66f4-bcf1-41a6-9c31-548ae68ec9fd', 'BCO ARBI S.A.', '54403563', '213', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('de56de6f-7450-49aa-be74-9b1058658c3c', 'INTESA SANPAOLO BRASIL S.A. BM', '55230916', '139', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('cb6bc364-0fa3-4f18-ba9a-b1d9a6121a62', 'BCO TRICURY S.A.', '57839805', '18', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('6e3318d0-6646-456a-bebf-c501f7f0c0fa', 'BCO SAFRA S.A.', '58160789', '422', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('101d75fa-51f3-44d9-87b4-8cf100e51d5d', 'BCO LETSBANK S.A.', '58497702', '630', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('51905c95-e78a-4123-bb66-ce1fa5c90261', 'BCO FIBRA S.A.', '58616418', '224', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('8ad70121-c049-411f-8ad0-cffe744376fb', 'BCO VOLKSWAGEN S.A', '59109165', '393', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('33fdb61b-365a-4623-8acc-1377b4e690e1', 'BCO LUSO BRASILEIRO S.A.', '59118133', '600', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('7f23243a-5431-4649-9979-f9f94f967e5c', 'BCO GM S.A.', '59274605', '390', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('b1b90817-f8a7-4b99-ab10-9457b04dfc71', 'BANCO PAN', '59285411', '623', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('bcf2c6a3-5128-4764-a3d2-690c0cab6dfb', 'BCO VOTORANTIM S.A.', '59588111', '655', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('81883be9-2aff-44b6-b331-7a600f820f7b', 'BCO ITAUBANK S.A.', '60394079', '479', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('2b40e503-4b19-4d44-8a74-830034a651bf', 'BCO MUFG BRASIL S.A.', '60498557', '456', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('405b252f-cff6-4d1b-a021-1d6e4260fc84', 'BCO SUMITOMO MITSUI BRASIL S.A.', '60518222', '464', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('7d662bc8-893d-4195-9686-1f9968bf5c82', 'ITAÚ UNIBANCO S.A.', '60701190', '341', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('e3c5e7f3-22af-421e-a545-c7d24b75907f', 'BCO BRADESCO S.A.', '60746948', '237', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('dcf01cad-5f4e-47a5-845b-c9721d7b1826', 'BCO MERCEDES-BENZ S.A.', '60814191', '381', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('63cdc925-9eb4-4af9-8639-53441e5561c8', 'OMNI BANCO S.A.', '60850229', '613', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('c8f9c400-27d8-47a4-8d95-33a713cf3bdd', 'BCO SOFISA S.A.', '60889128', '637', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('d9a7fc09-a383-4545-ac17-c283f9a54f5b', 'BANCO VOITER', '61024352', '653', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('111f5ecf-52e3-4e31-845f-8a1ddf01e7a2', 'BCO CREFISA S.A.', '61033106', '69', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('07dcd71d-760c-41b3-bf7b-d70cb6fe0347', 'BCO MIZUHO S.A.', '61088183', '370', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('f210de47-69ef-40f9-a714-3a84fdc97382', 'BANCO INVESTCRED UNIBANCO S.A.', '61182408', '249', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('92187c5e-e0a9-4322-9ac5-abd5aba62135', 'BCO BMG S.A.', '61186680', '318', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('c4e20673-3cb3-4932-886a-186747754314', 'BCO C6 CONSIG', '61348538', '626', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('cbb8c527-fd3d-4b5b-8b1e-1be8dd9848c7', 'AVENUE SECURITIES DTVM LTDA.', '61384004', '508', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('599723ec-68af-42bb-8100-93113cf9cefe', 'SAGITUR CC', '61444949', '270', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('a2ee6a90-e62b-4434-924f-df4dc82dd188', 'BCO SOCIETE GENERALE BRASIL', '61533584', '366', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('97cb3663-163c-4533-9a0e-85ec89ef4778', 'NEON CTVM S.A.', '61723847', '113', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('5c3d22e7-6881-428e-aad2-97b56b9c79ea', 'TULLETT PREBON BRASIL CVC LTDA', '61747085', '131', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('225dd1bf-c02e-4e16-a7de-baa71807b3c6', 'C.SUISSE HEDGING-GRIFFO CV S/A', '61809182', '11', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('ea1a1a24-d233-44aa-bcb5-a83d25e44b12', 'BCO PAULISTA S.A.', '61820817', '611', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('f3792d22-3f8b-468f-9bf2-2142d8dd3458', 'BOFA MERRILL LYNCH BM S.A.', '62073200', '755', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('33eb943f-1b14-4704-a704-9b9a6b827fe8', 'CREDISAN CC', '62109566', '89', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('45013204-1dcd-43b8-93b8-803927c04a9a', 'BCO PINE S.A.', '62144175', '643', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('bb5bc919-e599-4278-ac1f-4d448ce6d744', 'NU INVEST CORRETORA DE VALORES S.A.', '62169875', '140', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('88af288d-b3d6-433f-83e2-7aa2d1541889', 'BCO DAYCOVAL S.A', '62232889', '707', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('c4232bb2-4568-4fbd-a671-24ec0fd361fc', 'CAROL DTVM LTDA.', '62237649', '288', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('0b2016b8-93ff-423d-9d5c-b34fcd735104', 'SINGULARE CTVM S.A.', '62285390', '363', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('74bb679f-0c02-45e9-a41c-42433942eeb6', 'RENASCENCA DTVM LTDA', '62287735', '101', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('f828fdb8-4d75-464b-b683-55aa95831944', 'DEUTSCHE BANK S.A.BCO ALEMAO', '62331228', '487', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('170811d6-901a-443f-b82c-a1ba59e9aa22', 'BANCO CIFRA', '62421979', '233', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('39477394-104e-44c6-90e1-f3123c9804d8', 'GUIDE', '65913436', '177', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('a59f0e35-e529-475c-879f-9183be828361', 'TRUSTEE DTVM LTDA.', '67030395', '438', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('704d6961-cdcf-4b2e-8fe5-e2e41fd5fbf5', 'SIMPAUL', '68757681', '365', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('32aff177-b224-4f2b-ba72-70dcebdc76e1', 'BCO RENDIMENTO S.A.', '68900810', '633', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('405fdc89-5fb7-4a52-aea4-e4d95fa8d131', 'BCO BS2 S.A.', '71027866', '218', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('d5fff0c2-dc66-4be3-a768-0c3bfdfced79', 'LASTRO RDV DTVM LTDA', '71590442', '293', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('a47f6a19-2ebe-4165-be53-1a7125d91d86', 'FRENTE CC S.A.', '71677850', '285', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('bd4f509f-ed19-4577-bc16-eaae1cc86d1b', 'B&T CC LTDA.', '73622748', '80', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('2abd64a7-e4a0-43cc-9bc2-e8c7e2d759c0', 'NOVO BCO CONTINENTAL S.A. - BM', '74828799', '753', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('cd014a70-363d-4868-b92b-6ebcbc802c5e', 'BCO CRÉDIT AGRICOLE BR S.A.', '75647891', '222', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('33d1264e-6d60-4dea-986c-20a7b1e63e64', 'CCR COOPAVEL', '76461557', '281', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('2adb9c18-1755-4ac9-94cc-7a3121346ee7', 'BANCO SISTEMA', '76543115', '754', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('5770dd23-27e0-4385-9937-963cbee8d89c', 'DOURADA CORRETORA', '76641497', '311', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('a3bba75e-32c4-4479-a243-7889386bb70b', 'CREDIALIANÇA CCR', '78157146', '98', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('2f88d707-a729-4e83-932b-428cb6fcc0d2', 'BCO VR S.A.', '78626983', '610', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('9b605545-cf48-416d-bbae-47e26627f408', 'BCO OURINVEST S.A.', '78632767', '712', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('5f651baf-f482-4301-9552-4df03f2b24ee', 'BCO RNX S.A.', '80271455', '720', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('289ada36-7b63-4fa4-bbae-490406a3d8b6', 'CREDICOAMO', '81723108', '10', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('fc9745a0-6f0c-4e8e-8304-02c6691dca46', 'CREDIBRF COOP', '82096447', '440', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('5b518890-e144-475d-a3cc-68a75117c8ae', 'MAGNETIS - DTVM', '87963450', '442', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('2f5a2e7f-5406-4070-b710-d2a43cf9c87f', 'RB INVESTIMENTOS DTVM LTDA.', '89960090', '283', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('703b3077-b2d5-4a95-ba3a-a3ddea5d2e50', 'BCO SANTANDER (BRASIL) S.A.', '90400888', '33', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('58141193-e155-4b43-8887-38d40ebd2c5c', 'BANCO JOHN DEERE S.A.', '91884981', '217', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('d6bbf020-0e62-45d0-9943-e6c15977674e', 'BCO DO ESTADO DO RS S.A.', '92702067', '41', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('e6c72ebe-97cb-44ea-b4a0-b7e6a8475684', 'ADVANCED CC LTDA', '92856905', '117', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('100e2473-7e4c-4429-82be-562d734d6ed3', 'BCO DIGIMAIS S.A.', '92874270', '654', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('43974dc1-42ac-45df-917e-8b62f4034192', 'WARREN CVMC LTDA', '92875780', '371', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('09563a30-39b0-473b-b858-d35b6ddf00bf', 'BANCO ORIGINAL', '92894922', '212', '2023-08-25 12:04:04.798226', null);
INSERT INTO public.banks (id, name, ispb_code, compensation_code, created_at, updated_at) VALUES ('2a252e0a-2672-4573-b28c-8eeaf8eb50fc', 'EFX CC LTDA.', '94968518', '289', '2023-08-25 12:04:04.798226', null);
@erichnascimento
Copy link
Author

Script

DROP TABLE IF EXISTS banks;
TRUNCATE TABLE banks;

CREATE TABLE banks (
    id UUID NOT NULL PRIMARY KEY,
    name TEXT NOT NULL,
    ispb_code TEXT NOT NULL,
    compensation_code TEXT NOT NULL,
    created_at TIMESTAMP NOT NULL DEFAULT NOW(),
    updated_at TIMESTAMP
);

CREATE EXTENSION IF NOT EXISTS "uuid-ossp";

WITH banks_data AS (
    SELECT '



0	BCO DO BRASIL S.A.	1	Sim	RSFN	Banco do Brasil S.A.	22/04/2002
208	BRB - BCO DE BRASILIA S.A.	70	Sim	RSFN	BRB - BANCO DE BRASILIA S.A.	22/04/2002
38121	Selic                              	n/a	Não	RSFN	Banco Central do Brasil - Selic	22/04/2002
38166	Bacen                              	n/a	Não	RSFN	Banco Central do Brasil	22/04/2002
122327	SANTINVEST S.A. - CFI	539	Não	RSFN	SANTINVEST S.A. - CREDITO, FINANCIAMENTO E INVESTIMENTOS	17/04/2023
204963	CCR SEARA	430	Não	RSFN	COOPERATIVA DE CREDITO RURAL SEARA - CREDISEARA	27/08/2021
250699	AGK CC S.A.	272	Não	RSFN	AGK CORRETORA DE CAMBIO S.A.	21/11/2018
315557	CONF NAC COOP CENTRAIS UNICRED	136	Sim	RSFN	CONFEDERAÇÃO NACIONAL DAS COOPERATIVAS CENTRAIS UNICRED LTDA. - UNICRED DO BRASI	28/07/2014
329598	ÍNDIGO INVESTIMENTOS DTVM LTDA.	407	Não	RSFN	ÍNDIGO INVESTIMENTOS DISTRIBUIDORA DE TÍTULOS E VALORES MOBILIÁRIOS LTDA.	22/02/2021
360305	CAIXA ECONOMICA FEDERAL	104	Sim	RSFN	CAIXA ECONOMICA FEDERAL	22/04/2002
394460	STN                                	n/a	Não	RSFN	Secretaria do Tesouro Nacional - STN	22/04/2002
416968	BANCO INTER	77	Sim	RSFN	Banco Inter S.A.	15/08/2008
460065	COLUNA S.A. DTVM	423	Não	RSFN	COLUNA S/A DISTRIBUIDORA DE TITULOS E VALORES MOBILIÁRIOS	07/06/2021
517645	BCO RIBEIRAO PRETO S.A.	741	Sim	RSFN	BANCO RIBEIRAO PRETO S.A.	22/04/2002
556603	BANCO BARI S.A.	330	Não	RSFN	BANCO BARI DE INVESTIMENTOS E FINANCIAMENTOS S.A.	22/07/2019




' AS csv
), banks_csv AS (
    SELECT UNNEST(string_to_array(banks_data.csv, E'\n')) AS csv_rows
    FROM banks_data
), banks_raw AS (
    SELECT banks_csv.csv_rows AS csv_row
    FROM banks_csv
    WHERE csv_rows <> ''
), banks_as_column AS (
    SELECT 
        split_part(banks_raw.csv_row, E'\t', 1) AS ispb_code, 
        split_part(banks_raw.csv_row, E'\t', 2) AS name,
        split_part(banks_raw.csv_row, E'\t', 3) AS compensation_code,
        split_part(banks_raw.csv_row, E'\t', 4) AS is_participant,
        split_part(banks_raw.csv_row, E'\t', 5) AS main_access,
        split_part(banks_raw.csv_row, E'\t', 6) AS long_name,
        split_part(banks_raw.csv_row, E'\t', 7) AS operating_since
    FROM banks_raw
)
INSERT INTO banks (id, name, ispb_code, compensation_code)
SELECT 
    uuid_generate_v4() AS id,
    name,
    ispb_code,
    compensation_code
FROM banks_as_column
WHERE compensation_code <> 'n/a';

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment