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