Eman-RazImpact on Flow EVM Transactions
    Updated 2025-04-17
    select date_trunc('DAY',block_timestamp) as "Date", count(distinct tx_hash) as "Txns Count",
    count(distinct from_address) as "Number of Users", case
    when block_timestamp::date>='2025-01-22' then 'Post-Axelar Integration'
    else 'Pre-Axelar Integration' end as "Time Period"
    from flow.core_evm.fact_transactions
    where tx_succeeded='TRUE' and block_timestamp::date>='2025-01-01' and
    block_timestamp::date<current_date
    GROUP BY 1, 4
    ORDER BY 1
    Last run: 10 days ago
    Date
    Txns Count
    Number of Users
    Time Period
    1
    2025-01-01 00:00:00.000625274Pre-Axelar Integration
    2
    2025-01-02 00:00:00.000617685Pre-Axelar Integration
    3
    2025-01-03 00:00:00.000665299Pre-Axelar Integration
    4
    2025-01-04 00:00:00.000638477Pre-Axelar Integration
    5
    2025-01-05 00:00:00.000631858Pre-Axelar Integration
    6
    2025-01-06 00:00:00.0008384143Pre-Axelar Integration
    7
    2025-01-07 00:00:00.00010193140Pre-Axelar Integration
    8
    2025-01-08 00:00:00.000976895Pre-Axelar Integration
    9
    2025-01-09 00:00:00.00010630107Pre-Axelar Integration
    10
    2025-01-10 00:00:00.0009167101Pre-Axelar Integration
    11
    2025-01-11 00:00:00.000612558Pre-Axelar Integration
    12
    2025-01-12 00:00:00.000655776Pre-Axelar Integration
    13
    2025-01-13 00:00:00.0001049786Pre-Axelar Integration
    14
    2025-01-14 00:00:00.000726993Pre-Axelar Integration
    15
    2025-01-15 00:00:00.0008333115Pre-Axelar Integration
    16
    2025-01-16 00:00:00.000960798Pre-Axelar Integration
    17
    2025-01-17 00:00:00.0008298116Pre-Axelar Integration
    18
    2025-01-18 00:00:00.0001002796Pre-Axelar Integration
    19
    2025-01-19 00:00:00.0001485588Pre-Axelar Integration
    20
    2025-01-20 00:00:00.0001953582Pre-Axelar Integration
    ...
    106
    7KB
    2s