Eman-RazImpact on Flow Chain Transactions & Users
    Updated 2025-02-04
    select date_trunc('DAY',block_timestamp) as "Date", count(distinct tx_id) as "Txns Count",
    count(distinct proposer) 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.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: 2 months ago
    Date
    Txns Count
    Number of Users
    Time Period
    1
    2025-01-01 00:00:00.00021594115097Pre-Axelar Integration
    2
    2025-01-02 00:00:00.00023950111861Pre-Axelar Integration
    3
    2025-01-03 00:00:00.0002240039694Pre-Axelar Integration
    4
    2025-01-04 00:00:00.0002289529140Pre-Axelar Integration
    5
    2025-01-05 00:00:00.0002162609054Pre-Axelar Integration
    6
    2025-01-06 00:00:00.0001963689098Pre-Axelar Integration
    7
    2025-01-07 00:00:00.00024862010059Pre-Axelar Integration
    8
    2025-01-08 00:00:00.00023544612782Pre-Axelar Integration
    9
    2025-01-09 00:00:00.00022757910836Pre-Axelar Integration
    10
    2025-01-10 00:00:00.00017100910194Pre-Axelar Integration
    11
    2025-01-11 00:00:00.0002505889198Pre-Axelar Integration
    12
    2025-01-12 00:00:00.0001809849417Pre-Axelar Integration
    13
    2025-01-13 00:00:00.0001798739421Pre-Axelar Integration
    14
    2025-01-14 00:00:00.0001700469371Pre-Axelar Integration
    15
    2025-01-15 00:00:00.00022263511990Pre-Axelar Integration
    16
    2025-01-16 00:00:00.0001786379476Pre-Axelar Integration
    17
    2025-01-17 00:00:00.0002041039256Pre-Axelar Integration
    18
    2025-01-18 00:00:00.0001787299040Pre-Axelar Integration
    19
    2025-01-19 00:00:00.0001792148889Pre-Axelar Integration
    20
    2025-01-20 00:00:00.0002134698912Pre-Axelar Integration
    34
    2KB
    8s