tian7Daily Slaps
    Updated 2024-11-20
    --0x5aD441790c3114e0AB27816abdB0c9693cd96399
    --mint contract 0x0E65eb38C95E664c202C0d194bf6Bd8a586BB1f0
    select date_trunc('day',t.block_timestamp),count(1) as salps FROM
    berachain.testnet.fact_event_logs t
    WHERE contract_address = lower('0x5aD441790c3114e0AB27816abdB0c9693cd96399')
    and topics[0] = '0x92e508e7313b5df8d1fe99a3a6068ca07acf2a63f5c2ef3b765272189ad6fcf7' --LoanReceived
    group by 1;