PapasotpNetwork Bridge Launch USDC/USDT inflows
Updated 2023-01-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
select
-- (base64_decode_string (tx_message:txn:apaa[0]::String))
date_trunc('day',block_timestamp) as block_day,
app_id,
count (tx_message) as inflow_transactions,
sum (tx_message:dt:itx[0]:txn:aamt::number / 1e6) as inflow_volume
from flipside_prod_db.algorand.application_call_transaction
where
base64_decode_string(tx_message:txn:apaa[0]::String) = 'swap'
AND
app_id = 770102986 -- USDC,USDT
group by block_day,app_id
order by block_day
-- Query tips
-- select distinct base64_decode_string(tx_message:txn:apaa[0]::String) from algorand.application_call_transaction where app_id = 770102986
Run a query to Download Data