flipside

    ** MC daily ronin
    Lordking** MC daily ronin
    Updated 7 days ago
    -- forked from ** MC daily copy @ https://flipsidecrypto.xyz/studio/queries/958ecb14-3bbe-483a-8601-8f10f1779645


    WITH contract_info AS (
    SELECT * FROM (
    VALUES
    -- HIGH MC

    ('0xf988f63bf26c3ed3fbf39922149e3e7b1e5c27cb', ' RONKE', 'RonkeOnRon' ,'<img src="https://assets.coingecko.com/coins/images/54533/standard/originalk.png?1740211011" style="width:30px; border-radius: 100%;"><b> RONKE </b>' ),
    ('0x06f7481d937eb637d7d9deedf175957d5d881397', ' CAG ', 'thetickeriscag' ,'<img src="https://assets.coingecko.com/coins/images/53898/standard/_CAGPNG_%28512_x_512_px%29.png?1737695369" style="width:30px; border-radius: 100%;"><b> CAG </b>' ),
    ('0x361d8623dc1d91e04ebc148687719aace282249a', ' KOKU ', 'Kokutheshikoku' ,'<img src="https://assets.coingecko.com/coins/images/53989/standard/KOKU_cg.png?1737877808" style="width:30px; border-radius: 100%;"><b> KOKU </b>' ),
    ('0xf299c912186195d02111d22c3ab863650256e05f', ' JAIHOZ ', 'jaihoz_' ,'<img src="https://assets.coingecko.com/coins/images/53495/standard/jaihoz.jpg?1736508283" style="width:30px; border-radius: 100%;"><b> JAIHOZ </b>' ),
    ('0x1a89ecd466a23e98f07111b0510a2d6c1cd5e400', ' BANANA', 'CyberKongz' ,'<img src="https://assets.coingecko.com/coins/images/17521/standard/banana-token-cg.png?1696517059" style="width:30px; border-radius: 100%;"><b> BANANA </b>' )





    ) AS t (contract_address, token_name, twitter,image)
    ),
    transfers AS (
    SELECT
    address,
    contract_address AS token_address,
    SUM(CASE WHEN type = 'input' THEN amount ELSE 0 END) AS "Input",
    SUM(CASE WHEN type = 'output' THEN amount ELSE 0 END) AS "Output"
    FROM (
    SELECT
    to_address AS address,
    contract_address,
    amount,
    'input' AS type
    FROM ronin.core.ez_token_transfers
    WHERE contract_address IN (SELECT LOWER(contract_address) FROM contract_info)

    UNION ALL
    Last run: 7 days ago
    Fully diluted Market Cap
    Market Cap
    MC Type
    Date
    1
    		15028381502838 BANANA2023-06-02 00:00:00.000
    2
    		14566101456610 BANANA2023-06-03 00:00:00.000
    3
    		14447571444757 BANANA2023-06-04 00:00:00.000
    4
    		14260281426028 BANANA2023-06-05 00:00:00.000
    5
    		14043391404339 BANANA2023-06-06 00:00:00.000
    6
    		13683511368351 BANANA2023-06-07 00:00:00.000
    7
    		13648511364851 BANANA2023-06-08 00:00:00.000
    8
    		13367611336761 BANANA2023-06-09 00:00:00.000
    9
    		12426041242604 BANANA2023-06-10 00:00:00.000
    10
    		12128221212822 BANANA2023-06-11 00:00:00.000
    11
    		11933571193357 BANANA2023-06-12 00:00:00.000
    12
    		12206661220666 BANANA2023-06-13 00:00:00.000
    13
    		12799791279979 BANANA2023-06-14 00:00:00.000
    14
    		12105711210571 BANANA2023-06-15 00:00:00.000
    15
    		11973681197368 BANANA2023-06-16 00:00:00.000
    16
    		11900161190016 BANANA2023-06-17 00:00:00.000
    17
    		12158041215804 BANANA2023-06-18 00:00:00.000
    18
    		12586121258612 BANANA2023-06-19 00:00:00.000
    19
    		12321721232172 BANANA2023-06-20 00:00:00.000
    20
    		12525541252554 BANANA2023-06-21 00:00:00.000
    ...
    1015
    52KB
    4s