freemartianTotal Stablecoins Bridged to Linea
    Updated 2024-03-01
    WITH
    ethereum AS(
    SELECT
    block_timestamp,
    from_address,
    tx_hash,
    raw_amount/pow(10,6) AS amount,
    'Ethereum' AS from_chain
    FROM ethereum.core.fact_token_transfers
    WHERE to_address IN ('0x41d3d33156ae7c62c094aae2995003ae63f587b3','0xd7aa9ba6caac7b0436c91396f22ca5a7f31664fc','0x095D2918B03b2e86D68551DCF11302121fb626c9')
    AND RIGHT (raw_amount,4) = 9023
    AND block_timestamp::date > '2023-07-01'
    ),
    optimism AS(
    SELECT
    block_timestamp,
    from_address,
    tx_hash,
    raw_amount/pow(10,6) AS amount,
    'Optimism' AS from_chain
    FROM optimism.core.fact_token_transfers
    WHERE to_address IN ('0x41d3d33156ae7c62c094aae2995003ae63f587b3','0xd7aa9ba6caac7b0436c91396f22ca5a7f31664fc','0x095D2918B03b2e86D68551DCF11302121fb626c9')
    AND RIGHT (raw_amount,4) = 9023
    AND block_timestamp::date > '2023-07-01'
    ),
    arbitrum AS (
    SELECT
    block_timestamp,
    from_address,
    tx_hash,
    raw_amount/pow(10,6) AS amount,
    'Arbitrum' AS from_chain
    FROM arbitrum.core.fact_token_transfers
    WHERE to_address IN ('0x41d3d33156ae7c62c094aae2995003ae63f587b3','0xd7aa9ba6caac7b0436c91396f22ca5a7f31664fc','0x095D2918B03b2e86D68551DCF11302121fb626c9')
    AND RIGHT (raw_amount,4) = 9023
    AND block_timestamp::date > '2023-07-01'
    Last run: 3 months ago
    WALLETS
    TRANSACTIONS
    AMOUNT_USD
    1
    226873791150579305.950953
    1
    31B
    56s