osw74674362023-07-02 03:32 PM copy
Updated 2024-04-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
-- forked from 2023-07-02 03:32 PM @ https://flipsidecrypto.xyz/edit/queries/bbca28ff-710d-4ff0-9717-3c0fa024aa5e
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 deposited",
date_trunc('DAY', timestamp)
timestamp
from external.tokenflow_starknet.decoded_events
where chain_id='mainnet' and contract='0x073314940630fd6dcda0d772d4c972c4e0a9946bef9dabf4ef84eda8ef542b82' and name='deposit_handled'
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