osw74674362023-07-02 03:32 PM
Updated 2024-04-25
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select
sum((to_varchar(parse_json(parameters[1]):value[0]:value)+ to_varchar(parse_json(parameters[1]):value[1]:value)*pow(2,128))/1e18) as "amount withdrawn",
date_trunc('DAY', timestamp)
timestamp
from external.tokenflow_starknet.decoded_events
where chain_id='mainnet' and contract='0x073314940630fd6dcda0d772d4c972c4e0a9946bef9dabf4ef84eda8ef542b82' and name='withdraw_initiated'
and timestamp >= date_from_parts(2023, 01, 01)
group by date_trunc('DAY', timestamp)
order by date_trunc('DAY', timestamp) asc
QueryRunArchived: QueryRun has been archived