Sushi-55.BentoBox TVL
Q55: What is the total value locked in Bentobox across Polygon and Ethereum chains? Which chain brings the most activity to Bentobox?
Methodology
- Find bentobox contracts on both ETH and Polygon
-- ETH: https://etherscan.io/address/0xF5BCE5077908a1b7370B9ae04AdC565EBd643966
-- Polygon: https://polygonscan.com/address/0xe2f736B7d1f6071124CBb5FC23E93d141CD24E12
- Any transaction in the
udm_events
tables where to_address is the bentobox address is considered as deposit - Any transaction in the
udm_events
tables where from_address is the bentobox address is considered as withdraw - Find cumulative deposit vs withdraws
Note
- Some symbols with amount_usd missing are ignored as they don't form a large part of the TVL.
- Also some data seems incorrect in the ethereum tables where the raw amount was inserted instead of processed decimal amount
- I have tried to overcome that with IFF(amount_usd > pow(10,9), amount_usd/pow(10,18), amount_usd)
Loading...
Loading...
Loading...
Loading...