flipside

    Monthly Transactions
    SniperMonthly Transactions
    Updated 3 days ago
    with main as (
    select
    date_trunc('month', block_timestamp) as date,
    count(DISTINCT TX_HASH) as "Transactions",
    count(distinct FROM_ADDRESS) as "Active Users",
    sum(tx_fee) as "Fees (AVAX)"
    from
    avalanche.core.fact_transactions
    where
    STATUS = 'SUCCESS'
    and block_timestamp :: Date >= '2023-01-01'
    group by
    1
    order by
    1 desc
    ),

    new_wallet as (
    select
    date_trunc('month', first_tx) as date,
    count(DISTINCT FROM_ADDRESS) as "New Users"
    from
    (
    select
    FROM_ADDRESS,
    min(block_timestamp) as first_tx
    from
    avalanche.core.fact_transactions
    where
    STATUS = 'SUCCESS'
    group by 1
    )
    where
    first_tx :: Date >= '2023-01-01'
    group by 1)

    Last run: 3 days ago
    DATE
    MONTH
    Active Users
    Avg Daily Active Users
    Active Users Growth %
    New Users
    Avg Daily New Users
    New Users Growth %
    Transactions
    Avg Daily Transactions
    Transactions Growth %
    Fees (AVAX)
    Avg Daily Fees (AVAX)
    Fees (AVAX) Growth %
    1
    		2023-01-01 00:00:00.000Jan - 20233420863718.331455941582.54420517645708.4336273.583227677394.28
    2
    		2023-02-01 00:00:00.000Feb - 20233386363680.83🟥 -1.01%1613431753.73🟩 10.82%383835541721.25🟥 -8.72%25880.921639109281.31🟥 -28.65%
    3
    		2023-03-01 00:00:00.000Mar - 20233393723688.83🟩 0.22%1647471790.73🟩 2.11%421692945836.18🟩 9.86%35378.051720453384.54🟩 36.7%
    4
    		2023-04-01 00:00:00.000Apr - 20236264366809.09🟩 84.59%4296714670.34🟩 160.81%9312787101225.95🟩 120.84%109764.654236991193.09🟩 210.26%
    5
    		2023-05-01 00:00:00.000May - 202393723610187.35🟩 49.61%6241306784.02🟩 45.26%12372868134487.7🟩 32.86%89590.808409579973.81🟥 -18.38%
    6
    		2023-06-01 00:00:00.000Jun - 2023111747812146.5🟩 19.23%5362205828.48🟥 -14.09%12888852140096.22🟩 4.17%83555.754080244908.21🟥 -6.74%
    7
    		2023-07-01 00:00:00.000Jul - 2023110034911960.32🟥 -1.53%4359984739.11🟥 -18.69%12100792131530.35🟥 -6.11%71715.649753909779.52🟥 -14.17%
    8
    		2023-08-01 00:00:00.000Aug - 20238650279402.47🟥 -21.39%2514662733.33🟥 -42.32%771485883857.15🟥 -36.25%48837.454934218530.84🟥 -31.9%
    9
    		2023-09-01 00:00:00.000Sep - 20235805296310.1🟥 -32.89%1432441557🟥 -43.04%513660155832.62🟥 -33.42%30969.340477848336.62🟥 -36.59%
    10
    		2023-10-01 00:00:00.000Oct - 20235506295985.1🟥 -5.15%1587201725.22🟩 10.80%608191066107.72🟩 18.40%35712.737734203388.18🟩 15.32%
    11
    		2023-11-01 00:00:00.000Nov - 20236406396963.47🟩 16.35%2110792294.34🟩 32.99%28701736311975.39🟩 371.92%126267.3252552691372.47🟩 253.56%
    12
    		2023-12-01 00:00:00.000Dec - 202393096410119.17🟩 45.32%4403704786.63🟩 108.63%1050756041142126.13🟩 266.09%1254750.8005257513638.6🟩 893.73%
    13
    		2024-01-01 00:00:00.000Jan - 20248453199188.25🟥 -9.20%3333743623.63🟥 -24.30%13756146149523.33🟥 -86.91%45181.316424862491.1🟥 -96.4%
    14
    		2024-02-01 00:00:00.000Feb - 20247845388527.59🟥 -7.19%3027053290.27🟥 -9.20%15530105168805.49🟩 12.90%56136.580548196610.18🟩 24.25%
    15
    		2024-03-01 00:00:00.000Mar - 2024113294312314.6🟩 44.41%5241935697.75🟩 73.17%11235884122129.17🟥 -27.65%59747.754351047649.43🟩 6.43%
    16
    		2024-04-01 00:00:00.000Apr - 20248902029676.11🟥 -21.43%3602633915.9🟥 -31.27%745760181060.88🟥 -33.63%42419.595849752461.08🟥 -29%
    17
    		2024-05-01 00:00:00.000May - 20246051596577.82🟥 -32.02%2573342797.11🟥 -28.57%510869055529.24🟥 -31.50%23149.239974916251.62🟥 -45.43%
    18
    		2024-06-01 00:00:00.000Jun - 20247088467704.85🟩 17.13%2045682223.57🟥 -20.50%467511650816.48🟥 -8.49%20405.71417055221.8🟥 -11.85%
    19
    		2024-07-01 00:00:00.000Jul - 20246505437071.12🟥 -8.23%2048012226.1🟩 0.11%486897252923.61🟩 4.15%25117.014892541273.01🟩 23.09%
    20
    		2024-08-01 00:00:00.000Aug - 20244930995359.77🟥 -24.20%2193072383.77🟩 7.08%475744451711.35🟥 -2.29%29364.121780578319.18🟩 16.91%
    27
    4KB
    51s