tian7Daily Slaps
Updated 2024-11-20
9
1
2
3
4
5
6
7
›
⌄
--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;