Floor Token
Method
- for calculating the holders number of Floor Token, I used
ethereum.core.ez_token_transfers table by subtract the amount that transferred out from the amount that transferred in and if the result>0 then the user is holder 2. the chart of floor token price created base on data that ethereum.core.fact_hourly_token_prices table provide 3. for stake data I used
ethereum.core.ez_token_transfers table with this filtering
where TO_ADDRESS='0x759c6de5bca9ade8a1a2719a31553c4b7de02539' AND ORIGIN_FUNCTION_SIGNATURE='0xd866c9d8'
4. for unstake data I used
ethereum.core.ez_token_transfers table with this filtering
where FROM_ADDRESS='0x759c6de5bca9ade8a1a2719a31553c4b7de02539' AND ORIGIN_FUNCTION_SIGNATURE='0x990966d5''
5. for swap volume data, I used flipside_prod_db.uniswapv3.swaps
with both of the conditions :
TOKEN0_SYMBOL='FlOOR' or TOKEN0_SYMBOL='FlOOR'
then I sum the both 6. for received rebase calculating for each wallet, I used
ethereum.core.ez_token_transfers table with this filtering :
where TO_ADDRESS='0x759c6de5bca9ade8a1a2719a31553c4b7de02539' AND ORIGIN_FUNCTION_SIGNATURE='0xaf14052c'
7. you can select arbitrary wallet and type it on the above of the dashboard between the date you want, then it will calculate the rebase they received and staking amount for this period of time
Info about above table:
for the default wallet, the rebase that received is equal to 6,666 floor token