flipside

    Transactions Over Time - Chart 【Including EVM and Cadence】Table
    Flipside TeamTransactions Over Time - Chart 【Including EVM and Cadence】Table
    Updated 2025-03-28
    WITH weekly_transactions AS (
    -- Cadence transactions
    SELECT
    DATE_TRUNC('week', block_timestamp) as week,
    COUNT(DISTINCT COALESCE(payer, proposer)) as wallets,
    'cadence' as type
    FROM flow.core.fact_transactions
    WHERE block_timestamp >= DATEADD('week', -11, DATE_TRUNC('week', CURRENT_DATE))
    GROUP BY 1

    UNION ALL

    -- EVM transactions
    SELECT
    DATE_TRUNC('week', block_timestamp) as week,
    COUNT(DISTINCT from_address) as wallets,
    'evm' as type
    FROM flow.core_evm.fact_transactions
    WHERE block_timestamp >= DATEADD('week', -11, DATE_TRUNC('week', CURRENT_DATE))
    GROUP BY 1
    ),

    aggregated_weekly AS (
    SELECT
    week,
    SUM(CASE WHEN type = 'cadence' THEN wallets ELSE 0 END) as cadence_wallets,
    SUM(CASE WHEN type = 'evm' THEN wallets ELSE 0 END) as evm_wallets,
    SUM(wallets) as total_wallets
    FROM weekly_transactions
    GROUP BY 1
    ),

    final_data AS (
    SELECT
    'Cadence Transacting Wallets' as metric,
    cadence_wallets as value,
    Last run: 11 days ago
    Weekly Transacting Wallets
    Current Week
    Last Week
    2 Weeks Ago
    3 Weeks Ago
    4 Weeks Ago
    5 Weeks Ago
    6 Weeks Ago
    7 Weeks Ago
    8 Weeks Ago
    9 Weeks Ago
    10 Weeks Ago
    11 Weeks Ago
    1
    		Cadence Transacting Wallets159917353968904599823449202931771749173717891621323216
    2
    		Cadence % Change-7.84-99.56-13.7213236.6869.99-36.1381.650.69-99.038291.93-33.71
    3
    		EVM Transacting Wallets126155246106597077215291407585367416349369
    4
    		EVM % Change140.47392.589.7925.65-49.518.67140.5159.4-11.7819.2-5.42
    5
    		Total Transacting Wallets1421469813979554609524221355845842334210417933224813585
    6
    		Total % Change103.61-98.25-13.6710820.4518.63-22.3896.410.93-98.837128.21-30.8
    6
    567B
    7s