permaryfantasy addy
    Updated 2025-03-04
    0x04edB399CC24a95672BF9B880EE550dE0b2D0B1e fantasy nft collection
    0x9077D31A794D81c21b0650974d5F581F4000CD1a fantasy mint
    0x051785102854b9b9C93C504D9675Ffda7a12E07F used to transfer mon and fusd
    0xBb444821e159dd6401bb92FB18C2Ac0A37113025 fusd
    0x00cb1eef accept bid on 0xfA4D5a9ceA2822BA08d0266F121011aC527ced64,
    0x8a3f06c3 sell/ burn on 0xfA4D5a9ceA2822BA08d0266F121011aC527ced64
    0xf66a6799 list on 0xfA4D5a9ceA2822BA08d0266F121011aC527ced64
    0x8a3f06c3 sold /bought
    0xdb24f400 leveled up on 0x9077D31A794D81c21b0650974d5F581F4000CD1a
    0xa22cb465 list?? set approval for all
    0x8094cee4

    select *
    from monad.testnet.fact_event_logs
    where topic_0 = '0x7a7be958aedb09208ae6ed49fc0841ccb7f951498c9afc1c2bfa4abbd0e3ff82'
    and contract_address = lower('0x9077D31A794D81c21b0650974d5F581F4000CD1a')
    limit 4000

    select
    date_trunc('day', block_timestamp) as "date",
    count (*) as "Daily mints",
    count(distinct origin_from_address) as "Minters"
    from monad.testnet.fact_event_logs
    where
    --origin_function_signature = '0x1ff7712f'
    topic_0 = '0x7a7be958aedb09208ae6ed49fc0841ccb7f951498c9afc1c2bfa4abbd0e3ff82'
    and contract_address = lower ('0x9077D31A794D81c21b0650974d5F581F4000CD1a')
    group by "date"
    order by "date" desc;
    Last run: about 2 months ago
    DATE
    POOL_NAME
    TXS
    SWAPPERS
    TOTAL_AMOUNT_USD
    AVG_SWAP_SIZE
    1
    2025-03-04 00:00:00.000WETH/XVELO7586.7480645712.392580653
    2
    2025-03-04 00:00:00.000ezETH/WETH411.201058780.300264695
    3
    2025-03-04 00:00:00.000SWELL/USDe28459.9819544912.14221266
    4
    2025-03-04 00:00:00.000WETH/rsETH2414.717665450.1965693938
    5
    2025-03-04 00:00:00.000WETH/USDe18676755.3495657236.319083687
    6
    2025-03-03 00:00:00.000WETH/rsETH221.830632840.91531642
    7
    2025-03-03 00:00:00.000WETH/USDe13253112.3413457123.578343528
    8
    2025-03-03 00:00:00.000WETH/XVELO128242.9807136820.248392807
    9
    2025-03-03 00:00:00.000SWELL/USDe31434.0611368941.098746351
    10
    2025-03-02 00:00:00.000WETH/USDe259113598.1368042613.892420094
    11
    2025-03-02 00:00:00.000ezETH/WETH1100
    12
    2025-03-02 00:00:00.000WETH/XVELO1122.4627352622.46273526
    13
    2025-03-02 00:00:00.000WETH/KING112.252798182.25279818
    14
    2025-03-02 00:00:00.000SWELL/USDe22847.4933234922.158787431
    15
    2025-03-01 00:00:00.000SWELL/USDe516.519935331.303987066
    16
    2025-03-01 00:00:00.000WETH/XVELO3242.2697483814.089916127
    17
    2025-03-01 00:00:00.000WETH/USDe9151064.3387118511.696029801
    18
    2025-02-28 00:00:00.000WETH/USDe1914763.645354913.998143219
    19
    2025-02-28 00:00:00.000SWELL/USDe42267.2401238641.60095533
    20
    2025-02-28 00:00:00.000WETH/XVELO107213.8663557121.386635571
    29
    2KB
    7s