flipside

    Contract Deployment Locator - EDGE
    mcasto_Contract Deployment Locator - EDGE
    Updated 2 days ago
    WITH contract_deployments AS (
    SELECT
    MODIFIED_TIMESTAMP AS creation_time,
    SYMBOL AS symbol,
    NAME AS name,
    ADDRESS AS contract_address
    FROM base.core.dim_contracts
    WHERE symbol = 'EDGE'
    ),
    total_supply AS (
    SELECT
    CONTRACT_ADDRESS AS contract_address,
    TO_ADDRESS AS receiving_address,
    SUM(AMOUNT) AS total_supply
    FROM base.core.ez_token_transfers
    WHERE FROM_ADDRESS = '0x0000000000000000000000000000000000000000'
    GROUP BY CONTRACT_ADDRESS, TO_ADDRESS
    ),
    supply_sent AS (
    SELECT
    FROM_ADDRESS AS sending_address,
    SUM(AMOUNT) AS supply_sent
    FROM base.core.ez_token_transfers
    WHERE FROM_ADDRESS IN (SELECT receiving_address FROM total_supply)
    AND TO_ADDRESS <> '0x0000000000000000000000000000000000000000'
    GROUP BY FROM_ADDRESS
    )

    SELECT
    contract_deployments.creation_time,
    contract_deployments.symbol,
    contract_deployments.name,
    contract_deployments.contract_address,
    total_supply.receiving_address,
    total_supply.total_supply,
    COALESCE(supply_sent.supply_sent, 0) AS "supply_sent (WIP)"
    Last run: 2 days ago
    CREATION_TIME
    SYMBOL
    NAME
    CONTRACT_ADDRESS
    RECEIVING_ADDRESS
    TOTAL_SUPPLY
    supply_sent (WIP)
    1
    		2025-05-01 20:09:18.622EDGEEDGE0xc8ac2ee07a489046e7f08f34d18db63bd81946230xc8ac2ee07a489046e7f08f34d18db63bd819462310000000001000396748.57585
    2
    		2025-04-22 18:47:43.273EDGEfun EdgeVestor0x0ce8ec901400015c4a05843ce9d65e4a6c95ea680xf66dea7b3e897cd44a5a231c61b6b4423d613259100000000011357683880776.5
    3
    		2025-04-22 18:47:43.273EDGEEdge0x044972c3c3aad9f585c699da4d8baf5aa001656b0x05015bce874f6ef642daa8a147e7574ebc36341f200000000200000010.095043
    4
    		2025-04-22 18:47:43.273EDGEEdge0x4842dfdcef20eacaef46265532475a8787936f730xb847fa13cf26558d9b518f23a0df0b588005dbc2100000000100000005.357011
    5
    		2025-04-22 18:47:43.273EDGEEdge0xbb46b72e6549a4f8815345d6213e7bc6992ddea50xc5942cfda7602e980974df761b5b6de2266bb3b210000000001000000006.92332
    6
    		2025-04-22 18:47:43.273EDGEEdge0x746110818d429b659de038d0efffbbc99859729c0x8d328ff7470b4e1e75d96f88a5b97901b79787bc420690000420690006.556325
    7
    		2025-04-22 18:47:43.273EDGEEdge0x68cd489a03fea3c6400905b3a62664d394ac1dce0x923d88c10caaf586cdd3d5c9d5b5e04f70af6e7f100000000100000000
    8
    		2025-04-22 18:47:43.273EDGEEdge0xf59e8f593ac2217481ef63ad8a470c1ad8eccad90x893663daed2f1e4f231acd9b3b461c2908a8d124420000000420000006.657616
    9
    		2025-04-22 18:47:43.273EDGEEdge On Base0x5caa715c4ea25e5615c1aad1ca02506ca0f6babb0xdc18bd5aa87a1b040d1b1574a1b284fb1b74f5e810000000000095000000009.5
    10
    		2025-04-22 18:47:43.273EDGEEdge0x6f91c5cdfd2117574bcd7d65c63b1f2dcd66a3250x973af17913c25cb03bb8ff48805708c6d18775cf1000000000326481681677831
    11
    		2025-04-22 18:47:43.273EDGEEdge0x70a30cb776f8aaae7e912a31b93455737a8881830x24035aa5f632cac58fffb65ca7db220e0e3a34fc420000000420000004.486355
    12
    		2025-04-22 18:47:43.273EDGEEDGE0xbe5be6634a5267c1b6c82eb6678d340c826795310xbe5be6634a5267c1b6c82eb6678d340c8267953110000000001016547363.10583
    13
    		2025-04-22 18:47:43.273EDGEQuantumEdge0x351a4807708247ee91740d1b91bafbb4c00173550xb33545844cec1fbf289429206ce0b7ccb6b144462100000023451240.6021952
    14
    		2025-04-22 18:47:43.273EDGEEdge0xcd4b57e67f068ac2e4f3ba3aa222eaf2c08cabdb0x833a1b58020eeabcd9ca9f17f22db46d58ce659e500000000500000007.057983
    15
    		2025-04-22 18:47:43.273EDGEEdge0xb6f6e3f0055579876bcf0b2cbcf42eb610f12e300x9356eb745efeb76b56b40e28d299168f5000ee23500000000500000009.110238
    16
    		2025-04-22 18:47:43.273EDGEEdge0x37fbf74ecc30097c7eaa4ab40251430e12452ca80x05b8c9128110c1d4cc29ba7ffa15e91a9eb85305475000000475000013.925273
    17
    		2025-04-22 18:47:43.273EDGEEdge0x0d5504042bdedb498a1067fbf59bae881db30dcf0x9baf502a580a52fbc190f1536e36851877ffeee8420690000420690006.736219
    18
    		2025-04-22 18:47:43.273EDGEEdge0x80de4907d492dca24c25dcd620f41d99ab14af300xaf462b362d5f4884e49cb5c35ea51786e1e44e43500000000500000005.571326
    19
    		2025-04-22 18:47:43.273EDGEEdge0xfb4c63bd66fa3a57c5dcc0cccd11aaf83cf100680x0e13d806a83e4f766ee5fd6f44b869388c13878d300000000300000014.597295
    20
    		2025-04-22 18:47:43.273EDGEEdge0x209867a99e363358b789c05310a5aae22043022e0xa29ae0f9bc9a275d6a44dc028e6ffd6a25920802300000000300000007.29966
    81
    13KB
    165s