Sniperyouthful-sapphire
Updated 9 days ago
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
28
29
30
31
32
33
34
35
36
›
-- select
-- a.tx_hash
-- -- b.EVENT_NAME
-- --sum(DECODED_LOG:amount1Out/pow(10,18))as a
-- -- count (DISTINCT tx_hash) as a
-- from ink.core.fact_event_logs a left join ink.core.ez_decoded_event_logs b on a.tx_hash = b.tx_hash
-- --where a.CONTRACT_ADDRESS = '0x38d9ecc404d8d21b1e251c0397f63d0429488345'
-- where a.CONTRACT_ADDRESS = '0x7e16bb931c222e47597fa745abcc03098e1ebcf6'
-- -- tx_hash = '0x659b843f87042521f8c587a3bb4a5dbc3f7d0b9d70501f64fc7c2a4ec6e32ba1'
-- -- group by 1
-- -- -- and
-- and b.EVENT_NAME = 'Deposit'
-- GROUP by 1
-- limit 10
--Withdrawal
-- 0x8242119a ->swap
--0x7ff36ab5 ->deposit --Deposit
-- 0x791ac947
select * from ink.core.ez_decoded_event_logs where tx_hash = '0xc01d2924a4c2a58328bb068c3ead054db0e44f7f45cb5403d60878f31fb296de'
-- select sum (DECODED_LOG:wad)/pow(10,18) as amount from ink.core.ez_decoded_event_logs
-- where
-- --tx_hash = '0x079fea9ba82becbc78688054b4263d49d4ed7c59a7c4159eeda103b47410ddb8'
-- --and
-- EVENT_NAME = 'Withdrawal'
-- --Withdrawal
-- and DECODED_LOG:src = '0x9b17690de96fcfa80a3acaefe11d936629cd7a77'
-- select * from ink.core.dim_contract_abis where
-- -- NAME = 'DYOR LPs'
-- CONTRACT_ADDRESS = '0x7e16bb931c222e47597fa745abcc03098e1ebcf6'
-- and
-- CONTRACT_ADDRESS = '0x38d9ecc404d8d21b1e251c0397f63d0429488345'