Pine AnalyticsTest
Updated 2024-07-31
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
--case when origin_to_address ILIKE '0x6Cb442acF35158D5eDa88fe602221b67B400Be3E' then 'Slipstream' else 'Not Slipstream' end as Pool_type,
--date_trunc('day', block_timestamp) as date,
--sum(amount_usd) as amount
*
from base.core.ez_token_transfers
where (origin_to_address like lower('0x6Cb442acF35158D5eDa88fe602221b67B400Be3E')
or origin_to_address like lower('0xcF77a3Ba9A5CA399B7c97c74d54e5b1Beb874E43') )
limit 100
--group by 1
/*
select
*
from base.defi.ez_dex_swaps
where tx_hash like '0x706af4623ca0304b283df452f30b2b8ebcf4e1ce24ea74d283f88fac68d66b3e'
origin_from: 0x97e9200b8202c4e6bd9f81e1eaaf395d4c68c1b7
origin_to: 0xcf77a3ba9a5ca399b7c97c74d54e5b1beb874e43
sender: 0xcf77a3ba9a5ca399b7c97c74d54e5b1beb874e43
contract_address = 0x27a8afa3bd49406e48a074350fb7b2020c43b2bd
tx_to : 0x97e9200b8202c4e6bd9f81e1eaaf395d4c68c1b7
amount_usd 52.22
-- 0x6Cb442acF35158D5eDa88fe602221b67B400Be3E Slipstream
-- 0xcF77a3Ba9A5CA399B7c97c74d54e5b1Beb874E43 Not Slipstream
-- 0x6cDcb1C4A4D1C3C6d054b27AC5B77e89eAFb971d vAMM-USDC/AERO pool
*/
QueryRunArchived: QueryRun has been archived