Afonso_Diaz2023-06-08 08:26 PM
Updated 2023-06-08
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
›
⌄
with t as (
select
project_name as cex,
address
from near.core.dim_address_labels
where label_type = 'cex'
group by 1, 2
),
t2 as (
select
tx_hash,
block_timestamp,
iff(address = tx_signer, 'Outflow', 'Inflow') as type,
args:amount/1e6 as amount_usd
from near.core.fact_actions_events_function_call a
join near.core.fact_transactions b
using(tx_hash)
join t on address in (tx_signer, tx_receiver)
where method_name = 'ft_transfer'
and receiver_id in ('usdt.tether-token.near', 'dac17f958d2ee523a2206206994597c13d831ec7.factory.bridge.near')
)
select * from t2
limit 10
Run a query to Download Data