jackguy2023-04-08 11:39 AM
Updated 2023-04-08
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select
sum(
case
when TO_ADDRESS = lower('0x0000000000000000000000000000000000000000') then -1 * RAW_AMOUNT / 1e18
when FROM_ADDRESS = lower('0x0000000000000000000000000000000000000000') then RAW_AMOUNT / 1e18
end
) as VLP_CIRCULATING
from
arbitrum.core.fact_token_transfers
where
CONTRACT_ADDRESS = lower('0x4e0D4a5A5b4FAf5C2eCc1C63C8d19BB0804A96F1')
Run a query to Download Data