yasmin-n-d-r-hsupposed-red
Updated 2024-12-11
999
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
28
29
30
31
32
33
34
35
36
›
⌄
-- 0x46b39d408ec2ec248008e30595086ae074105dfca921fbbc359e76567a6ba6bc deposit
-- 0x00a3760ac6d3b82184bfc4ec18482d7f2d4bd54b1f599a4bcb664aad9a995f8b withraw
-- 0x26b00dda84f7e034a47ca7e1085639ef203116adc252267990b8ab4173055351 reward
-- 0xF6c6e000e7A99dFBD26a70fA20D2A472fE6B142A token
-- 0x491A2b017de03f6FC7799311e62899504B9193C5 market
SELECT *
FROM avalanche.core.ez_decoded_event_logs
---FROM avalanche.core.fact_decoded_event_logs
--FROM avalanche.core.fact_event_logs
---FROM avalanche.core.ez_token_transfers
---FROM avalanche.core.fact_traces
---from avalanche.core.fact_transactions
WHERE TX_HASH='0x7750fd44bdedfa847d04bcb486fdd6f0ad9390e44b966f8b2e7a42d9b8460c94'
ORIGIN_FROM_ADDRESS
-- SELECT
-- ORIGIN_FROM_ADDRESS
-- SUM(CAST(DECODED_LOG:wad AS FLOAT) / POWER(10, 18)) AS total_volume
-- FROM avalanche.core.ez_decoded_event_logs
-- WHERE
-- LOWER(DECODED_LOG:src) = LOWER('0xf2c15bd1bf3d7863a4b6d72f89758c18489794aa')
-- AND LOWER(CONTRACT_ADDRESS) = LOWER('0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7');
QueryRunArchived: QueryRun has been archived