freemartianInteractive Vault Balance
Updated 2023-06-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
›
⌄
with stake AS (
SELECT
sum(raw_amount)/pow(10,6) AS staked
FROM optimism.core.fact_token_transfers
WHERE to_address = '0xd5a8f233cbddb40368d55c3320644fb36e597002'
AND contract_address = '0x7f5c764cbc14f9669b88837ca1490cca17c31607'
AND origin_function_signature = '0x7acb7757'
AND from_address = '{{User_Address}}'
),
unstake AS (
SELECT
sum(raw_amount)/pow(10,6) AS unstaked
FROM optimism.core.fact_token_transfers
WHERE from_address = '0xd5a8f233cbddb40368d55c3320644fb36e597002'
AND contract_address = '0x7f5c764cbc14f9669b88837ca1490cca17c31607'
AND origin_function_signature = '0x5c833bfd'
AND to_address = '{{User_Address}}'
)
SELECT staked, unstaked
FROM stake, unstake
Run a query to Download Data