SYMBOL | MOUNT | AMOUNT_USD | |
|---|---|---|---|
1 | wstETH | 0.005925409061 | 19.071327379 |
2 | stETH | 0.6067287443 | 1666.598918464 |
freemartian2024-02-15 11:51 PM
Updated 2024-02-15
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
26
27
›
⌄
SELECT
symbol,
sum(amount) AS mount,
sum(amount_usd) AS amount_usd
FROM ethereum.core.ez_token_transfers
WHERE to_address = '0x4aa799c5dfc01ee7d790e3bf1a7c2257ce1dceff'
AND origin_from_address = from_address
AND tx_hash IN ('0x7f057cf820757fde21c9c59a1fbd4b0c39c8605d5e02bf97b1a4cf3fd32ed9ef','0xdb17e09bc54e657471eb8bd5dcfffba64885054ff0e048d22db8a3f2f96b51e2')
GROUP BY 1
-- SELECT
-- contract_name,
-- sum(decoded_log:value/pow(10,18)) AS mount
-- -- sum(amount_usd) AS amount_usd
-- FROM ethereum.core.ez_decoded_event_logs
-- WHERE origin_to_address = '0x4aa799c5dfc01ee7d790e3bf1a7c2257ce1dceff'
-- -- AND origin_from_address = from_address
-- -- AND tx_hash IN ('0x7f057cf820757fde21c9c59a1fbd4b0c39c8605d5e02bf97b1a4cf3fd32ed9ef','0xdb17e09bc54e657471eb8bd5dcfffba64885054ff0e048d22db8a3f2f96b51e2')
-- AND event_name = 'Transfer'
-- AND decoded_log:from = origin_from_address
-- GROUP BY 1
Last run: about 1 year ago
2
78B
30s