osw74674362023-07-02 03:32 PM
    Updated 2024-04-25
    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