企業作成のN+1問題を解消する

Dividend::Recent.update_us_to_latest を経由して実行される Company::Save.create_for_us_with_api がN+1だったので修正
修正後の実行ログ
irb(main):003:0> Dividend::Recent.update_us_to_latest
   (2.7ms)  SELECT "companies"."symbol" FROM "companies" WHERE "companies"."symbol" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154, $155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165, $166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176, $177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187, $188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209, $210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220, $221, $222, $223, $224, $225, $226, $227, $228, $229, $230, $231, $232, $233, $234, $235, $236, $237, $238, $239, $240, $241, $242, $243, $244, $245, $246, $247, $248, $249, $250, $251, $252, $253, $254, $255, $256, $257, $258, $259, $260, $261, $262, $263, $264, $265, $266, $267, $268, $269, $270, $271, $272, $273, $274, $275, $276, $277, $278, $279, $280, $281, $282, $283, $284, $285, $286, $287, $288, $289, $290, $291, $292, $293, $294, $295, $296, $297, $298, $299, $300, $301, $302, $303, $304, $305, $306, $307, $308, $309, $310, $311, $312, $313, $314, $315, $316, $317, $318, $319, $320, $321, $322, $323, $324, $325, $326, $327, $328, $329, $330, $331, $332, $333, $334, $335, $336, $337, $338, $339, $340, $341, $342, $343, $344, $345, $346, $347, $348, $349, $350, $351, $352, $353, $354, $355, $356, $357, $358, $359, $360, $361, $362, $363, $364, $365, $366, $367, $368, $369, $370, $371, $372, $373, $374, $375, $376, $377, $378, $379, $380, $381, $382, $383, $384, $385, $386, $387, $388, $389, $390, $391, $392, $393, $394, $395, $396, $397, $398, $399, $400, $401, $402, $403, $404, $405, $406, $407, $408, $409, $410, $411, $412, $413, $414, $415, $416, $417, $418, $419, $420, $421, $422, $423, $424, $425, $426, $427, $428, $429, $430, $431, $432, $433, $434, $435, $436, $437, $438, $439, $440, $441, $442, $443, $444, $445, $446, $447, $448, $449, $450, $451, $452, $453, $454, $455, $456, $457, $458, $459, $460, $461, $462, $463, $464, $465, $466, $467, $468, $469, $470, $471, $472, $473, $474, $475, $476, $477, $478, $479, $480, $481, $482, $483, $484, $485, $486, $487, $488, $489, $490, $491, $492, $493, $494, $495, $496, $497, $498, $499, $500, $501, $502, $503, $504, $505, $506, $507, $508, $509, $510, $511, $512, $513, $514, $515, $516, $517, $518, $519, $520, $521, $522, $523, $524, $525, $526, $527, $528, $529, $530, $531, $532, $533, $534, $535, $536, $537, $538, $539, $540, $541, $542, $543, $544, $545, $546, $547, $548, $549, $550, $551, $552, $553, $554, $555, $556, $557, $558, $559, $560, $561, $562, $563, $564, $565, $566, $567, $568, $569, $570, $571, $572, $573, $574, $575, $576, $577, $578, $579, $580, $581, $582, $583, $584, $585, $586, $587, $588, $589, $590, $591, $592, $593, $594, $595, $596, $597, $598, $599, $600, $601, $602, $603, $604, $605, $606, $607, $608, $609, $610, $611, $612, $613, $614, $615, $616, $617, $618, $619, $620, $621, $622, $623, $624, $625, $626, $627, $628, $629, $630, $631, $632, $633, $634, $635, $636, $637, $638, $639, $640, $641, $642, $643, $644, $645, $646, $647, $648, $649, $650, $651, $652, $653, $654, $655, $656, $657, $658, $659, $660, $661, $662, $663, $664, $665, $666, $667, $668, $669, $670, $671, $672, $673, $674, $675, $676, $677, $678, $679, $680, $681, $682, $683, $684, $685, $686, $687, $688, $689, $690, $691, $692, $693, $694, $695, $696, $697, $698, $699, $700, $701, $702, $703, $704, $705, $706, $707, $708, $709, $710, $711, $712, $713, $714, $715, $716, $717, $718, $719, $720, $721, $722, $723, $724, $725, $726, $727, $728, $729, $730, $731, $732, $733, $734, $735, $736, $737, $738, $739, $740, $741, $742, $743, $744, $745, $746, $747, $748, $749, $750, $751, $752, $753, $754, $755, $756, $757, $758, $759, $760, $761, $762, $763, $764, $765, $766, $767, $768, $769, $770, $771, $772, $773, $774, $775, $776, $777, $778, $779, $780, $781, $782, $783, $784, $785, $786, $787, $788, $789, $790, $791, $792, $793, $794, $795, $796, $797, $798, $799, $800, $801, $802, $803, $804, $805, $806, $807)  [["symbol", "MAIN"], ["symbol", "NUS"], ["symbol", "PDM"], ["symbol", "SMG"], ["symbol", "WEF.TO"], ["symbol", "WEYS"], 省略, ["symbol", "LPX"]]
  Company Bulk Insert (43.2ms)  INSERT INTO "companies" ("symbol","name","currency","exchange","exchange_short_name","industry","sector","country","image","ipo_date","created_at","updated_at") VALUES ('ABC', 'AmerisourceBergen Corporation', 'USD', 'New York Stock Exchange', 'NYSE', 'Medical Distribution', 'Healthcare', 'US', 'https://financialmodelingprep.com/image-stock/ABC.png', '1993-12-16', '2021-08-11 12:36:22.034483', '2021-08-11 12:36:22.034517'), ('ABR', 'Arbor Realty Trust, Inc.', 'USD', 'New York Stock Exchange', 'NYSE', 'REIT—Mortgage', 'Real Estate', 'US', 'https://financialmodelingprep.com/image-stock/ABR.png', '2004-04-07', '2021-08-11 12:36:22.034612', '2021-08-11 12:36:22.034629'), ('ABST', 'Absolute Software Corporation', 'USD', 'Nasdaq Global Select', 'NASDAQ', 'Software—Application', 'Technology', 'CA', 'https://financialmodelingprep.com/image-stock/ABST.png', '2020-10-26', '2021-08-11 12:36:22.034702', '2021-08-11 12:36:22.034722'), ('ACC', 'American Campus Communities, Inc.', 'USD', 'New York Stock Exchange', 'NYSE', 'REIT—Residential', 'Real Estate', 'US', 'https://financialmodelingprep.com/image-stock/ACC.png', '2004-08-12', '2021-08-11 12:36:22.034840', '2021-08-11 12:36:22.034854'), ('ACCO', 'ACCO Brands Corporation', 'USD', 'New York Stock Exchange', 'NYSE', 'Business Equipment & Supplies', 'Industrials', 'US', 'https://financialmodelingprep.com/image-stock/ACCO.png', '2005-08-05', '2021-08-11 12:36:22.034932', '2021-08-11 12:36:22.034944'), 省略, ('ZION', 'Zions Bancorporation, National Association', 'USD', 'Nasdaq Global Select', 'NASDAQ', 'Banks—Regional', 'Financial Services', 'US', 'https://financialmodelingprep.com/image-stock/ZION.png', '1966-01-01', '2021-08-11 12:36:22.098307', '2021-08-11 12:36:22.098319'), ('ZTR', 'Virtus Total Return Fund Inc.', 'USD', 'New York Stock Exchange', 'NYSE', 'Closed-End Fund - Equity', 'Financial Services', 'US', 'https://financialmodelingprep.com/image-stock/ZTR.png', '1988-09-23', '2021-08-11 12:36:22.098383', '2021-08-11 12:36:22.098395') ON CONFLICT  DO NOTHING RETURNING "id"
   (6.0ms)  SELECT "companies"."symbol" FROM "companies" WHERE "companies"."exchange_short_name" IN ($1, $2) AND "companies"."symbol" IN ($3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154, $155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165, $166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176, $177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187, $188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209, $210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220, $221, $222, $223, $224, $225, $226, $227, $228, $229, $230, $231, $232, $233, $234, $235, $236, $237, $238, $239, $240, $241, $242, $243, $244, $245, $246, $247, $248, $249, $250, $251, $252, $253, $254, $255, $256, $257, $258, $259, $260, $261, $262, $263, $264, $265, $266, $267, $268, $269, $270, $271, $272, $273, $274, $275, $276, $277, $278, $279, $280, $281, $282, $283, $284, $285, $286, $287, $288, $289, $290, $291, $292, $293, $294, $295, $296, $297, $298, $299, $300, $301, $302, $303, $304, $305, $306, $307, $308, $309, $310, $311, $312, $313, $314, $315, $316, $317, $318, $319, $320, $321, $322, $323, $324, $325, $326, $327, $328, $329, $330, $331, $332, $333, $334, $335, $336, $337, $338, $339, $340, $341, $342, $343, $344, $345, $346, $347, $348, $349, $350, $351, $352, $353, $354, $355, $356, $357, $358, $359, $360, $361, $362, $363, $364, $365, $366, $367, $368, $369, $370, $371, $372, $373, $374, $375, $376, $377, $378, $379, $380, $381, $382, $383, $384, $385, $386, $387, $388, $389, $390, $391, $392, $393, $394, $395, $396, $397, $398, $399, $400, $401, $402, $403, $404, $405, $406, $407, $408, $409, $410, $411, $412, $413, $414, $415, $416, $417, $418, $419, $420, $421, $422, $423, $424, $425, $426, $427, $428, $429, $430, $431, $432, $433, $434, $435, $436, $437, $438, $439, $440, $441, $442, $443, $444, $445, $446, $447, $448, $449, $450, $451, $452, $453, $454, $455, $456, $457, $458, $459, $460, $461, $462, $463, $464, $465, $466, $467, $468, $469, $470, $471, $472, $473, $474, $475, $476, $477, $478, $479, $480, $481, $482, $483, $484, $485, $486, $487, $488, $489, $490, $491, $492, $493, $494, $495, $496, $497, $498, $499, $500, $501, $502, $503, $504, $505, $506, $507, $508, $509, $510, $511, $512, $513, $514, $515, $516, $517, $518, $519, $520, $521, $522, $523, $524, $525, $526, $527, $528, $529, $530, $531, $532, $533, $534, $535, $536, $537, $538, $539, $540, $541, $542, $543, $544, $545, $546, $547, $548, $549, $550, $551, $552, $553, $554, $555, $556, $557, $558, $559, $560, $561, $562, $563, $564, $565, $566, $567, $568, $569, $570, $571, $572, $573, $574, $575, $576, $577, $578, $579, $580, $581, $582, $583, $584, $585, $586, $587, $588, $589, $590, $591, $592, $593, $594, $595, $596, $597, $598, $599, $600, $601, $602, $603, $604, $605, $606, $607, $608, $609, $610, $611, $612, $613, $614, $615, $616, $617, $618, $619, $620, $621, $622, $623, $624, $625, $626, $627, $628, $629, $630, $631, $632, $633, $634, $635, $636, $637, $638, $639, $640, $641, $642, $643, $644, $645, $646, $647, $648, $649, $650, $651, $652, $653, $654, $655, $656, $657, $658, $659, $660, $661, $662, $663, $664, $665, $666, $667, $668, $669, $670, $671, $672, $673, $674, $675, $676, $677, $678, $679, $680, $681, $682, $683, $684, $685, $686, $687, $688, $689, $690, $691, $692, $693, $694, $695, $696, $697, $698, $699, $700, $701, $702, $703, $704, $705, $706, $707, $708, $709, $710, $711, $712, $713, $714, $715, $716, $717, $718, $719, $720, $721, $722, $723, $724, $725, $726, $727, $728, $729, $730, $731, $732, $733, $734, $735, $736, $737, $738, $739, $740, $741, $742, $743, $744, $745, $746, $747, $748, $749, $750, $751, $752, $753, $754, $755, $756, $757, $758, $759, $760, $761, $762, $763, $764, $765, $766, $767, $768, $769, $770, $771, $772, $773, $774, $775, $776, $777, $778, $779, $780, $781, $782, $783, $784, $785, $786, $787, $788, $789, $790, $791, $792, $793, $794, $795, $796, $797, $798, $799, $800, $801, $802, $803, $804, $805, $806, $807, $808, $809)  [["exchange_short_name", "NYSE"], ["exchange_short_name", "NASDAQ"], ["symbol", "MAIN"], ["symbol", "NUS"], ["symbol", "PDM"], ["symbol", "SMG"], ["symbol", "WEF.TO"], ["symbol", "WEYS"], ["symbol", "PIPR"], ["symbol", "PSEC"], ["symbol", "NBHC"], ["symbol", "HII"], ["symbol", "MLHR"], ["symbol", "EVR"], ["symbol", "FBHS"], ["symbol", "ALTM"], ["symbol", "CBT"], ["symbol", "NEE"], ["symbol", "ACCO"], ["symbol", "CF.TO"], ["symbol", "B"], ["symbol", "VOYA"], ["symbol", "SBAC"], ["symbol", "SPGI"], ["symbol", "RUS.TO"], ["symbol", "RGP"], ["symbol", "PHX"], ["symbol", "GIL.TO"], ["symbol", "LMAT"], ["symbol", "AMAT"], ["symbol", "FBP"], ["symbol", "Y.TO"], ["symbol", "RBA.TO"], ["symbol", "KEN"], ["symbol", "ZIM"], ["symbol", "RM"], ["symbol", "FLMN"], ["symbol", "CDW"], ["symbol", "YUMC"], ["symbol", "ALA.TO"], ["symbol", "PPL.TO"], ["symbol", "RHI"], ["symbol", "SLF.TO"], ["symbol", "EFR"], ["symbol", "EVG"], ["symbol", "EOT"], ["symbol", "ETX"], ["symbol", "EOS"], ["symbol", "ETY"], ["symbol", "ETJ"], ["symbol", "EVT"], ["symbol", "EFT"], ["symbol", "EOI"], ["symbol", "CEM"], ["symbol", "CTR"], ["symbol", "EMO"], ["symbol", "BGB"], ["symbol", "BSL"], ["symbol", "BGX"], ["symbol", "BWG"], ["symbol", "JNJ"], ["symbol", "XPER"], ["symbol", "VTRS"], ["symbol", "WIW"], ["symbol", "WIA"], ["symbol", "WEA"], ["symbol", "IGI"], ["symbol", "HYI"], ["symbol", "HIX"], ["symbol", "GDO"], ["symbol", "EHI"], ["symbol", "DMO"], ["symbol", "MMU"], ["symbol", "HIO"], ["symbol", "EMD"], ["symbol", "SBI"], ["symbol", "WDI"], ["symbol", "PPT"], ["symbol", "NHF"], ["symbol", "HIE"], ["symbol", "HFRO"], ["symbol", "HGLB"], ["symbol", "PFD"], ["symbol", "BGCP"], ["symbol", "FLC"], ["symbol", "FFC"], ["symbol", "DFP"], ["symbol", "BC"], ["symbol", "EDUC"], ["symbol", "ENR"], ["symbol", "EXG"], ["symbol", "ETW"], ["symbol", "EXD"], ["symbol", "ETV"], ["symbol", "ETB"], ["symbol", "ETG"], ["symbol", "ETO"], ["symbol", "HVT"], ["symbol", "HL"], ["symbol", "LTC"], ["symbol", "GOOD"], ["symbol", "NLOK"], ["symbol", "UPS"], ["symbol", "GAIN"], ["symbol", "LAND"], ["symbol", "IPL.TO"], ["symbol", "AEIS"], ["symbol", "FHB"], ["symbol", "NATH"], ["symbol", "GLAD"], ["symbol", "R"], ["symbol", "TSCO"], ["symbol", "TIPT"], ["symbol", "KEY.TO"], ["symbol", "GSL"], ["symbol", "DLX"], ["symbol", "ATO"], ["symbol", "SBLK"], ["symbol", "BGH"], ["symbol", "EIT-UN.TO"], ["symbol", "MGPI"], ["symbol", "MCHP"], ["symbol", "ZZZ.TO"], ["symbol", "GSK"], ["symbol", "USPH"], ["symbol", "TKR"], ["symbol", "SNA"], ["symbol", "SWM"], ["symbol", "MNRL"], ["symbol", "CCOI"], ["symbol", "DEX"], ["symbol", "EVRG"], ["symbol", "HCSG"], ["symbol", "PRI"], ["symbol", "RTX"], ["symbol", "IEP"], ["symbol", "MG.TO"], ["symbol", "MTRN"], ["symbol", "NMRK"], ["symbol", "OLY.TO"], ["symbol", "PFC"], ["symbol", "CBFV"], ["symbol", "CTSH"], ["symbol", "CMI"], ["symbol", "FSS"], ["symbol", "FDBC"], ["symbol", "FWRD"], ["symbol", "HMM-A.TO"], ["symbol", "HCI"], ["symbol", "TTEK"], ["symbol", "USLM"], ["symbol", "WBA"], ["symbol", "HSY"], ["symbol", "MGU"], ["symbol", "X.TO"], ["symbol", "QBR-B.TO"], ["symbol", "SWN"], ["symbol", "CORE"], ["symbol", "BBSI"], ["symbol", "PCSB"], ["symbol", "PBI"], ["symbol", "IAG.TO"], ["symbol", "MTX"], ["symbol", "MCO"], ["symbol", "OBNK"], ["symbol", "OTIS"], ["symbol", "PRK"], ["symbol", "RPRX"], ["symbol", "SHW"], ["symbol", "TEL"], ["symbol", "RXN"], ["symbol", "BBWI"], ["symbol", "UMPQ"], ["symbol", "IBOC"], ["symbol", "CGNX"], ["symbol", "MIXT"], ["symbol", "HSBC"], ["symbol", "PCF"], ["symbol", "SWCH"], ["symbol", "WD"], ["symbol", "TRI.TO"], ["symbol", "BG"], ["symbol", "CNP"], ["symbol", "CVX"], ["symbol", "DFS"], ["symbol", "FTS.TO"], ["symbol", "GFF"], ["symbol", "HTBI"], ["symbol", "K.TO"], ["symbol", "LFUS"], ["symbol", "BWXT"], ["symbol", "NRP"], ["symbol", "MAC"], ["symbol", "MSFT"], ["symbol", "NLSN"], ["symbol", "APO"], ["symbol", "FTT.TO"], ["symbol", "SUNS"], ["symbol", "MHI"], ["symbol", "MAV"], ["symbol", "PHT"], ["symbol", "PHD"], ["symbol", "ADTN"], ["symbol", "EFX.TO"], ["symbol", "PRMW"], ["symbol", "AVA"], ["symbol", "HE"], ["symbol", "RMD"], ["symbol", "SBSI"], ["symbol", "UTF"], ["symbol", "RNP"], ["symbol", "PTA"], ["symbol", "PSF"], ["symbol", "LDP"], ["symbol", "FOF"], ["symbol", "ADX"], ["symbol", "AFL"], ["symbol", "BKH"], ["symbol", "CRD.B"], ["symbol", "L"], ["symbol", "CRD-B"], ["symbol", "ESXB"], ["symbol", "ED"], ["symbol", "FMBH"], ["symbol", "HRZN"], ["symbol", "MRO"], ["symbol", "MPC"], ["symbol", "EQIX"], ["symbol", "CRD.A"], ["symbol", "PEO"], ["symbol", "DMB"], ["symbol", "JACK"], ["symbol", "MCR"], ["symbol", "CXE"], ["symbol", "MIN"], ["symbol", "CXH"], ["symbol", "MMT"], ["symbol", "FDP"], ["symbol", "ZUM.TO"], ["symbol", "VMC"], ["symbol", "TGT"], ["symbol", "SHYF"], ["symbol", "ORA"], ["symbol", "SGC"], ["symbol", "WCN.TO"], ["symbol", "ADM"], ["symbol", "SXC"], ["symbol", "PSX"], ["symbol", "ALC.TO"], ["symbol", "AMOT"], ["symbol", "AMAL"], ["symbol", "GGB"], ["symbol", "PHI"], ["symbol", "SSSS"], ["symbol", "POWL"], ["symbol", "PFLT"], ["symbol", "CAS.TO"], ["symbol", "CSL"], ["symbol", "SEM"], ["symbol", "PCAR"], ["symbol", "AGO"], ["symbol", "ICL"], ["symbol", "RQI"], ["symbol", "ITUB"], ["symbol", "RGA"], ["symbol", "NHTC"], ["symbol", "ETH"], ["symbol", "APAM"], ["symbol", "BHB"], ["symbol", "CORR"], ["symbol", "HP"], ["symbol", "LNN"], ["symbol", "NBLY.TO"], ["symbol", "OXSQ"], ["symbol", "AMGN"], ["symbol", "ENGH.TO"], ["symbol", "GWRS"], ["symbol", "SPOK"], ["symbol", "PFB.TO"], ["symbol", "REYN"], ["symbol", "SWKS"], ["symbol", "XFLT"], ["symbol", "FINS"], ["symbol", "DYFN"], ["symbol", "SMM"], ["symbol", "GPRK"], ["symbol", "HNNA"], ["symbol", "JRSH"], ["symbol", "MFC.TO"], ["symbol", "RMAX"], ["symbol", "SBRA"], ["symbol", "GNK"], ["symbol", "PACW"], ["symbol", "IVH"], ["symbol", "SOR"], ["symbol", "OPP"], ["symbol", "RMI"], ["symbol", "RFMZ"], ["symbol", "RSF"], ["symbol", "RIV"], ["symbol", "MCFE"], ["symbol", "RMM"], ["symbol", "RFM"], ["symbol", "PGZ"], ["symbol", "OXLC"], ["symbol", "GNT"], ["symbol", "GUT"], ["symbol", "GDV"], ["symbol", "PTMN"], ["symbol", "SCU"], ["symbol", "PFSI"], ["symbol", "AJX"], ["symbol", "BLW"], ["symbol", "MPC.TO"], ["symbol", "ACD.TO"], ["symbol", "SZC"], ["symbol", "SRV"], ["symbol", "MMD"], ["symbol", "POU.TO"], ["symbol", "SSRM.TO"], ["symbol", "BTZ"], ["symbol", "BHK"], ["symbol", "BTA"], ["symbol", "MUI"], ["symbol", "BHV"], ["symbol", "BGIO"], ["symbol", "BFZ"], ["symbol", "CII"], ["symbol", "BDJ"], ["symbol", "EGF"], ["symbol", "BGT"], ["symbol", "BMEZ"], ["symbol", "BME"], ["symbol", "BIGZ"], ["symbol", "BIT"], ["symbol", "BTT"], ["symbol", "BFK"], ["symbol", "BLE"], ["symbol", "BCX"], ["symbol", "BST"], ["symbol", "BSTZ"], ["symbol", "BBN"], ["symbol", "BUI"], ["symbol", "VVR"], ["symbol", "IHTA"], ["symbol", "VTA"], ["symbol", "IHIT"], ["symbol", "TEI"], ["symbol", "CQXL"], ["symbol", "PIF.TO"], ["symbol", "SII.TO"], ["symbol", "BYM"], ["symbol", "MUE"], ["symbol", "MHD"], ["symbol", "BNY"], ["symbol", "HYT"], ["symbol", "BGR"], ["symbol", "BOE"], ["symbol", "BGY"], ["symbol", "FRA"], ["symbol", "AGCO"], ["symbol", "ALE"], ["symbol", "ALSN"], ["symbol", "ACC"], ["symbol", "ABC"], ["symbol", "BGSF"], ["symbol", "TECH"], ["symbol", "BCAT"], ["symbol", "DSU"], ["symbol", "BKT"], ["symbol", "BKN"], ["symbol", "MUA"], ["symbol", "MUC"], ["symbol", "MFL"], ["symbol", "MUJ"], ["symbol", "MHN"], ["symbol", "MVT"], ["symbol", "MVF"], ["symbol", "MYC"], ["symbol", "MCA"], ["symbol", "MYD"], ["symbol", "MIY"], ["symbol", "MYJ"], ["symbol", "MYN"], ["symbol", "MPA"], ["symbol", "MQT"], ["symbol", "MYI"], ["symbol", "MQY"], ["symbol", "BOKF"], ["symbol", "BAH"], ["symbol", "CF"], ["symbol", "CHE"], ["symbol", "CHD"], ["symbol", "CNA"], ["symbol", "CNS"], ["symbol", "CNOB"], ["symbol", "DAC"], ["symbol", "DCI"], ["symbol", "DTF"], ["symbol", "DRE"], ["symbol", "EXPI"], ["symbol", "FTAI"], ["symbol", "GIC"], ["symbol", "GSBD"], ["symbol", "AJX"], ["symbol", "GCBC"], ["symbol", "HR"], ["symbol", "HTLF"], ["symbol", "HIW"], ["symbol", "IP"], ["symbol", "VBF"], ["symbol", "VCV"], ["symbol", "VLT"], ["symbol", "OIA"], ["symbol", "VMO"], ["symbol", "VKQ"], ["symbol", "VPV"], ["symbol", "IQI"], ["symbol", "VGM"], ["symbol", "VTN"], ["symbol", "IIM"], ["symbol", "JEF"], ["symbol", "KMPR"], ["symbol", "KKR"], ["symbol", "KLAC"], ["symbol", "MNR"], ["symbol", "MSA"], ["symbol", "MUR"], ["symbol", "OMP"], ["symbol", "OAS"], ["symbol", "OSK"], ["symbol", "PZZA"], ["symbol", "PFSI"], ["symbol", "PECO"], ["symbol", "SWX"], ["symbol", "SII"], ["symbol", "SSRM"], ["symbol", "SMP"], ["symbol", "RGR"], ["symbol", "TFX"], ["symbol", "SO"], ["symbol", "GROW"], ["symbol", "UMH"], ["symbol", "WSTG"], ["symbol", "WWD"], ["symbol", "AWR"], ["symbol", "AIT"], ["symbol", "ABR"], ["symbol", "ARR"], ["symbol", "BWFG"], ["symbol", "CC"], ["symbol", "RTLR"], ["symbol", "ROK"], ["symbol", "RYI"], ["symbol", "SBR"], ["symbol", "GIM"], ["symbol", "SJM"], ["symbol", "JOE"], ["symbol", "TSBK"], ["symbol", "TFC"], ["symbol", "UTL"], ["symbol", "V"], ["symbol", "WMT"], ["symbol", "WEC"], ["symbol", "WAL"], ["symbol", "WAB"], ["symbol", "WRK"], ["symbol", "WING"], ["symbol", "NBN"], ["symbol", "NUW"], ["symbol", "NEA"], ["symbol", "NXJ"], ["symbol", "EQH"], ["symbol", "EVA"], ["symbol", "NET-UN.TO"], ["symbol", "EMR"], ["symbol", "ETN"], ["symbol", "EBMT"], ["symbol", "DUK"], ["symbol", "DAN"], ["symbol", "DALN"], ["symbol", "UAN"], ["symbol", "ENB.TO"], ["symbol", "CTVA"], ["symbol", "CHCT"], ["symbol", "NRK"], ["symbol", "AMSWA"], ["symbol", "BSM"], ["symbol", "LEO"], ["symbol", "BP"], ["symbol", "BRKL"], ["symbol", "BFST"], ["symbol", "CGO"], ["symbol", "XEC"], ["symbol", "CTAS"], ["symbol", "FIX"], ["symbol", "NAN"], ["symbol", "JPT"], ["symbol", "NSL"], ["symbol", "NBB"], ["symbol", "DIV.TO"], ["symbol", "NRT"], ["symbol", "NXST"], ["symbol", "SJR-B.TO"], ["symbol", "SNC.TO"], ["symbol", "NKX"], ["symbol", "JGH"], ["symbol", "JPC"], ["symbol", "JPI"], ["symbol", "JRI"], ["symbol", "JSD"], ["symbol", "RNW.TO"], ["symbol", "JCO"], ["symbol", "NMS"], ["symbol", "JLS"], ["symbol", "NZF"], ["symbol", "NP"], ["symbol", "NWG"], ["symbol", "MSCI"], ["symbol", "MOG.B"], ["symbol", "MSBI"], ["symbol", "MSEX"], ["symbol", "MSVB"], ["symbol", "MMS"], ["symbol", "MAS"], ["symbol", "LPLA"], ["symbol", "LAD"], ["symbol", "LLY"], ["symbol", "KR"], ["symbol", "JBGS"], ["symbol", "JBL"], ["symbol", "IVZ"], ["symbol", "HON"], ["symbol", "HTH"], ["symbol", "HWKN"], ["symbol", "GGM"], ["symbol", "GBAB"], ["symbol", "GOF"], ["symbol", "GWB"], ["symbol", "GRC"], ["symbol", "FCFS"], ["symbol", "FMO"], ["symbol", "XOM"], ["symbol", "EXC"], ["symbol", "WTRG"], ["symbol", "MOG-A"], ["symbol", "RDS.B"], ["symbol", "RDS.A"], ["symbol", "MOG.A"], ["symbol", "AW-UN.TO"], ["symbol", "COHN"], ["symbol", "MCFE"], ["symbol", "ISD"], ["symbol", "GHY"], ["symbol", "KIO"], ["symbol", "SDHY"], ["symbol", "SEB"], ["symbol", "AVK"], ["symbol", "CPZ"], ["symbol", "CSQ"], ["symbol", "CHI"], ["symbol", "CCD"], ["symbol", "CHW"], ["symbol", "NAD"], ["symbol", "NVG"], ["symbol", "NMZ"], ["symbol", "JQC"], ["symbol", "JPS"], ["symbol", "JHAA"], ["symbol", "NPCT"], ["symbol", "NDMO"], ["symbol", "NEV"], ["symbol", "NMCO"], ["symbol", "NAC"], ["symbol", "JHB"], ["symbol", "JEMD"], ["symbol", "JRO"], ["symbol", "JFR"], ["symbol", "NKG"], ["symbol", "NID"], ["symbol", "NIQ"], ["symbol", "AHC"], ["symbol", "ADS"], ["symbol", "AIRC"], ["symbol", "AZN"], ["symbol", "AUB"], ["symbol", "RILY"], ["symbol", "BCS"], ["symbol", "BSET"], ["symbol", "DMF"], ["symbol", "DSM"], ["symbol", "ENB"], ["symbol", "FNWB"], ["symbol", "NAZ"], ["symbol", "NCA"], ["symbol", "NXC"], ["symbol", "NMT"], ["symbol", "NOM"], ["symbol", "JMM"], ["symbol", "NMI"], ["symbol", "NUV"], ["symbol", "NNY"], ["symbol", "NXN"], ["symbol", "NUO"], ["symbol", "NQP"], ["symbol", "NIM"], ["symbol", "NXP"], ["symbol", "NXQ"], ["symbol", "NXR"], ["symbol", "NPV"], ["symbol", "ODC"], ["symbol", "OGS"], ["symbol", "OTTR"], ["symbol", "PSO"], ["symbol", "PSTL"], ["symbol", "PSMT"], ["symbol", "FRST"], ["symbol", "PVBC"], ["symbol", "PFS"], ["symbol", "RS"], ["symbol", "RIO"], ["symbol", "SAL"], ["symbol", "SBFG"], ["symbol", "SIGI"], ["symbol", "SJR"], ["symbol", "SHBI"], ["symbol", "SMBC"], ["symbol", "SSBI"], ["symbol", "TAIT"], ["symbol", "SCHW"], ["symbol", "EML"], ["symbol", "ACV"], ["symbol", "DSL"], ["symbol", "FCCY"], ["symbol", "COG"], ["symbol", "COLM"], ["symbol", "CWBC"], ["symbol", "FANG"], ["symbol", "DEA"], ["symbol", "EVN"], ["symbol", "EVY"], ["symbol", "ECVT"], ["symbol", "ENBL"], ["symbol", "ETR"], ["symbol", "EQNR"], ["symbol", "HTBK"], ["symbol", "PDT"], ["symbol", "MGY"], ["symbol", "MTDR"], ["symbol", "MTG"], ["symbol", "OPY"], ["symbol", "PBFX"], ["symbol", "PCM"], ["symbol", "PTY"], ["symbol", "PHK"], ["symbol", "RCS"], ["symbol", "PROV"], ["symbol", "SSB"], ["symbol", "SCCO"], ["symbol", "SBUX"], ["symbol", "TPX"], ["symbol", "TEX"], ["symbol", "TBNK"], ["symbol", "TJX"], ["symbol", "VNOM"], ["symbol", "ZTR"], ["symbol", "WELL"], ["symbol", "WLKP"], ["symbol", "ZION"], ["symbol", "VGI"], ["symbol", "POOL"], ["symbol", "DBL"], ["symbol", "DLY"], ["symbol", "NCV"], ["symbol", "NCZ"], ["symbol", "CBH"], ["symbol", "AIO"], ["symbol", "PCN"], ["symbol", "PZC"], ["symbol", "PCK"], ["symbol", "PYN"], ["symbol", "PNF"], ["symbol", "PNI"], ["symbol", "PMF"], ["symbol", "PMX"], ["symbol", "PML"], ["symbol", "PFN"], ["symbol", "PKO"], ["symbol", "PGP"], ["symbol", "PDO"], ["symbol", "PDI"], ["symbol", "PCI"], ["symbol", "PCQ"], ["symbol", "HPF"], ["symbol", "HPS"], ["symbol", "HPI"], ["symbol", "HTD"], ["symbol", "EFL"], ["symbol", "EVF"], ["symbol", "BFIN"], ["symbol", "AUDC"], ["symbol", "ASTE"], ["symbol", "CSTR"], ["symbol", "ABST"], ["symbol", "ABST.TO"], ["symbol", "BRO"], ["symbol", "MTFC"], ["symbol", "GHM"], ["symbol", "ARCB"], ["symbol", "8065.HK"], ["symbol", "8098.HK"], ["symbol", "IIFLWAM.NS"], ["symbol", "ISEC.NS"], ["symbol", "HONAUT.NS"], ["symbol", "EMSN.SW"], ["symbol", "DCF"], ["symbol", "RA"], ["symbol", "EIC"], ["symbol", "WETF"], ["symbol", "WINA"], ["symbol", "WNEB"], ["symbol", "WTBA"], ["symbol", "UVSP"], ["symbol", "SASR"], ["symbol", "NFBK"], ["symbol", "MCBC"], ["symbol", "MDC"], ["symbol", "LARK"], ["symbol", "HOMB"], ["symbol", "HTGC"], ["symbol", "EBTC"], ["symbol", "ECC"], ["symbol", "DLB"], ["symbol", "TACO"], ["symbol", "COLB"], ["symbol", "KMT"], ["symbol", "JBSS"], ["symbol", "INVH"], ["symbol", "ISBC"], ["symbol", "IBM"], ["symbol", "HMST"], ["symbol", "HBT"], ["symbol", "HBI"], ["symbol", "GABC"], ["symbol", "DHI"], ["symbol", "CLR"], ["symbol", "STZ.B"], ["symbol", "STZ"], ["symbol", "CDR"], ["symbol", "BY"], ["symbol", "DHF"], ["symbol", "BKR"], ["symbol", "AWK"], ["symbol", "AEP"], ["symbol", "EDI"], ["symbol", "EDF"], ["symbol", "1523.HK"], ["symbol", "BRW"], ["symbol", "AWC.DE"], ["symbol", "SMWN.DE"], ["symbol", "HN9.DE"], ["symbol", "AEP.DE"], ["symbol", "68V.DE"], ["symbol", "IBM.L"], ["symbol", "VARN.SW"], ["symbol", "CIPLA.NS"], ["symbol", "ANUP.NS"], ["symbol", "ATFL.NS"], ["symbol", "ALKEM.NS"], ["symbol", "EICHERMOT.NS"], ["symbol", "GRAPHITE.NS"], ["symbol", "WELCORP.NS"], ["symbol", "LGI"], ["symbol", "IBM.DE"], ["symbol", "CSA"], ["symbol", "CSB"], ["symbol", "VSMV"], ["symbol", "CDL"], ["symbol", "CDC"], ["symbol", "CSF"], ["symbol", "0854.HK"], ["symbol", "PRIMESECU.NS"], ["symbol", "CFA"], ["symbol", "CFO"], ["symbol", "QQQN"], ["symbol", "CIL"], ["symbol", "COFORGE.NS"], ["symbol", "CID"], ["symbol", "CEY"], ["symbol", "VSDA"], ["symbol", "CIZ"], ["symbol", "UIHC"], ["symbol", "FBMS"], ["symbol", "CG"], ["symbol", "NTB"], ["symbol", "SFBC"], ["symbol", "SON"], ["symbol", "RUSHB"], ["symbol", "RUSHA"], ["symbol", "ROL"], ["symbol", "PPG"], ["symbol", "PAG"], ["symbol", "PGC"], ["symbol", "OLN"], ["symbol", "MWA"], ["symbol", "MPB"], ["symbol", "MET"], ["symbol", "MPX"], ["symbol", "LPX"]]
  Dividend Load (0.9ms)  SELECT "dividends".* FROM "dividends" ORDER BY "dividends"."ex_dividend_on" ASC
  Dividend Bulk Insert (41.3ms)  INSERT INTO "dividends" ("ex_dividend_on","records_on","pays_on","declares_on","symbol","dividend","adjusted_dividend","created_at","updated_at") VALUES ('2021-08-26', '2021-08-27', '2021-09-15', '2021-05-04', 'MAIN', 0.205, 0.205, '2021-08-11 12:36:22.303710', '2021-08-11 12:36:22.303732'), ('2021-08-26', '2021-08-27', '2021-09-08', '2021-08-04', 'NUS', 0.38, 0.38, '2021-08-11 12:36:22.303755', '2021-08-11 12:36:22.303759'), 省略, ('2021-08-09', '2021-08-10', '2021-09-01', NULL, 'LPX', 0.18, 0.18, '2021-08-11 12:36:22.321446', '2021-08-11 12:36:22.321456') RETURNING "id"
=>
#<ActiveRecord::Result:0x0000564222254b70
 @column_types={},
 @columns=["id"],
 @hash_rows=nil,
 @rows=
  [[1],
   [2],
   [3],
   [4],
省略
   [705]]>
irb(main):004:0>
yoshikouki / dividend-portal

企業作成のN+1問題を解消する #52
