select '0xdac17f958d2ee523a2206206994597c13d831ec7' as contract_address,'usdt' as symbol ,'Ethereum' as chain union all

select '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' as contract_address,'usdc' as symbol ,'Ethereum' as chain union all

select '0x6b175474e89094c44da98b954eedeac495271d0f' as contract_address,'dai' as symbol ,'Ethereum' as chain union all

select '0x0000000000085d4780b73119b644ae5ecd22b376' as contract_address,'tusd' as symbol ,'Ethereum' as chain union all

select '0x7b4b0b9b024109d182dcf3831222fbda81369423' as contract_address,'busd' as symbol ,'Ethereum' as chain union all

select '0x0c10bf8fcb7bf5412187a595ab97a3609160b5c6' as contract_address,'usdd' as symbol ,'Ethereum' as chain union all

select '0x853d955acef822db058eb8505911ed77f175b99e' as contract_address,'frax' as symbol ,'Ethereum' as chain union all

select '0x8e870d67f660d95d5be530380d0ec0bd388289e1' as contract_address,'usdp' as symbol ,'Ethereum' as chain union all

select '0xc5f0f7b66764f6ec8c8dff7ba683102295e16409' as contract_address,'fdusd' as symbol ,'Ethereum' as chain union all

select '0x056fd409e1d7a124bd7017459dfea2f387b6d5cd' as contract_address,'gusd' as symbol ,'Ethereum' as chain union all

select '0x5f98805a4e8be255a32880fdec7f6728c6568ba0' as contract_address,'lusd' as symbol ,'Ethereum' as chain union all

select '0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913' as contract_address,'usdc' as symbol ,'Base' as chain union all

select '0x833589fcd6edb6e08f4c7c32d4f71b54bda02913' as contract_address,'usdc' as symbol ,'Base' as chain union all

select '0xda3de145054ed30ee937865d31b500505c4bdfe7' as contract_address,'USD+' as symbol ,'Base' as chain union all

select '0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca' as contract_address,'USDbC' as symbol ,'Base' as chain union all

select '0xb79dd08ea68a908a97220c76d19a6aa9cbde4376' as contract_address,'USD+v2' as symbol ,'Base' as chain union all

select '0x50c5725949a6f0c72e6c4a641f24049a917db0cb' as contract_address,'DAI' as symbol ,'Base' as chain union all

select '0x4a3a6dd60a34bb2aba60d73b4c88315e9ceb6a3d' as contract_address,'MIN' as symbol ,'Base' as chain union all

select '0x65a2508c429a6078a7bc2f7df81ab575bd9d9275' as contract_address,'DAI+' as symbol ,'Base' as chain

),

deployedBots AS

SELECT

TO_ADDRESS as address,

RANK() OVER (ORDER BY BLOCK_NUMBER ASC ) AS botVersion,

BLOCK_NUMBER as deploymentBlockNumber,

BLOCK_TIMESTAMP as deploymentTimestamp,

FROM_ADDRESS as deployer,

TX_HASH as deploymentTxHash

,'Ethereum' as chain

FROM ethereum.core.fact_traces

WHERE TYPE in ('create','CREATE')