TOTAL_MONEY_RECEIVED_FROM_INTR_IN_USD | |
|---|---|
1 | 1780 |
defi__joshIntract tx
Updated 2025-03-04
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
›
⌄
with Intr_tx as
(
select
block_timestamp,
contract_address,
from_address,
to_address,
amount_USD,
tx_hash
from base.core.ez_token_transfers
where TO_ADDRESS = lower('0x4Fd8Cd9cf58cE8Fd6ebdE594ab60B195395A482D')
and BLOCK_TIMESTAMP :: date >= '2024-10-12'
and SYMBOL like 'USD%'
union all
select
block_timestamp,
contract_address,
from_address,
to_address,
amount_USD,
tx_hash
from polygon.core.ez_token_transfers
where TO_ADDRESS = lower('0x4Fd8Cd9cf58cE8Fd6ebdE594ab60B195395A482D')
and BLOCK_TIMESTAMP :: date >= '2024-10-12'
and SYMBOL like 'USD%'
order by 1 desc
)
select
round(sum(amount_USD)) as total_money_received_from_intr_in_USD
from Intr_tx
group by to_address
Last run: about 1 month ago
1
8B
4s