mamad-5XN3k3Bean Swap on Mon 2 (new users)
    Updated 14 hours ago
    -- forked from Bean Swap on Mon 2 @ https://flipsidecrypto.xyz/studio/queries/0313fc4e-f318-4f5d-94f9-925c3a34c66b

    with tokent as (
    select
    lower(address) as token_address,
    symbol as sym,
    decimals,
    from
    values
    ('0x70f893f65e3c1d7f82aad72f71615eb220b74d10' , 'JAI' , 6),
    ('0x020f16358a99c3839686014617de3d039d2cdeec' , 'PAGOL' , 18),
    ('0x77f77926c6596c78f285d230cd0dc8dc3540e3a6' , 'USDC' , 6),
    ('0x07aabd925866e8353407e67c1d157836f7ad923e' , 'sMON' , 18),
    ('0x62534e4bbd6d9ebac0ac99aeaa0aa48e56372df0' , 'USDC' , 6),
    ('0x0f0bdebf0f83cd1ee3974779bcb7315f9808c714' , 'DAK' , 18),
    ('0xa296f47e8ff895ed7a092b4a9498bb13c46ac768' , 'wWETH' , 18),
    ('0x878819cec0b61e78fa92fbb5bb258a92852fb3d1' , 'CHARLIE' , 18),
    ('0x6fe981dbd557f81ff66836af0932cba535cbc343' , 'LINK' , 18),
    ('0x6bb379a2056d1304e73012b99338f8f581ee2e18' , 'wBTC' , 18),
    ('0x646be04ae14385f9d483bbe6d90a9da4f4a0141f' , 'GREEN' , 18),
    ('0x88b8e2161dedc77ef4ab7585569d2415a1c1055d' , 'USDT' , 6),
    ('0xe0590015a873bf326bd645c3e1266d4db41c4e6b' , 'CHOG' , 18),
    ('0x43d614b1ba4ba469faeaa4557aeafdec039b8795' , 'MOCKB' , 6),
    ('0xe7b284fd1d6770ef880664e6a109145e21666c58' , 'azUSDT' , 6),
    ('0xcc5b42f9d6144dfdfb6fb3987a2a916af902f5f8' , 'JAI' , 6),
    ('0x37bba84a61a07f2a26e6a31ec3d1fb457987a381' , 'Khalie' , 18),
    ('0xa5e5caf9153c317dcdd003a4e314bc7f9f013b7a' , 'leMONade' , 18),
    ('0x268e4e24e0051ec27b3d27a95977e71ce6875a05' , 'BEAN' , 18),
    ('0x989d38aeed8408452f0273c7d4a17fef20878e62' , 'MUK' , 18),
    ('0x760afe86e5de5fa0ee542fc7b7b713e1c5425701' , 'WMON' , 18),
    ('0xf817257fed379853cde0fa4f97ab987181b1e5ea' , 'USDC' , 6),
    ('0x983a01a0808795b2f9cb93b5d2c82d1b79bdb641' , 'aUSD' , 18),
    ('0xae19bb7168f897d5dc144da1386d42b67c9d3ee2' , 'wMON' , 18),
    ('0xbb444821e159dd6401bb92fb18c2ac0a37113025' , 'fUSD' , 18),
    ('0xb5a30b0fdc5ea94a52fdc42e3e9760cb8449fb37' , 'wETH' , 18),
    ('0x5a8b923a25b97fe24dfc0acab6eea07254d11a78' , 'azWBTC' , 8),
    Last run: 1 day ago
    DATE
    USERS
    NEW_USERS
    OLD_USER
    1
    2025-02-17 00:00:00.000110
    2
    2025-02-18 00:00:00.000220
    3
    2025-02-19 00:00:00.000106910681
    4
    2025-02-20 00:00:00.0001033910149190
    5
    2025-02-21 00:00:00.00013789120861703
    6
    2025-02-22 00:00:00.00019973159963977
    7
    2025-02-23 00:00:00.00026851199476904
    8
    2025-02-24 00:00:00.000317722065611116
    9
    2025-02-25 00:00:00.0001104068951920887
    10
    2025-02-26 00:00:00.00021405918235231707
    11
    2025-02-27 00:00:00.0001435878566357924
    12
    2025-02-28 00:00:00.0001074615871148750
    13
    2025-03-01 00:00:00.0001069194593960980
    14
    2025-03-02 00:00:00.000945723434160231
    15
    2025-03-03 00:00:00.0001171935055166642
    16
    2025-03-04 00:00:00.0001099154444465471
    17
    2025-03-05 00:00:00.0001239787210051878
    18
    2025-03-06 00:00:00.0001010234708953934
    19
    2025-03-07 00:00:00.000863203308353237
    20
    2025-03-08 00:00:00.000861133342852685
    26
    1KB
    126s