MLDZMNTop senders by transfer volume in USD
    Updated 2023-11-02

    with base as (------------------------- Aso 34/23 ------------------------------
    with raw_transfers as (
    SELECT
    livequery.live.udf_api('https://flipsidecrypto.xyz/api/queries/edfcc1ab-0f68-4d7c-ac39-a7f3a3d3845a/latest-run') as response

    union all
    SELECT
    livequery.live.udf_api('https://flipsidecrypto.xyz/api/queries/a8110d7f-68f7-46a4-bf74-e43fa9c93820/latest-run') as response
    )

    select
    value[0]::string as tx_hash,
    to_timestamp(value[1]::string) as time,
    value[2]::string as from_address,
    value[3]::string as to_address,
    value[4]::int as amount,
    value[5]::string as symbol
    from raw_transfers , lateral FLATTEN (input => response:data:data)


    union all

    ------------------------- Aso 19/23 ------------------------------
    SELECT
    value:TX_HASH as tx_hash,
    value:DAY::string as time,
    value:FROM_ADDRESS::string as from_address,
    value:TO_ADDRESS::string as to_address,
    value:AMOUNT::int as amount,
    value:SYMBOL::string as symbol
    from (select livequery.live.udf_api(
    'https://api.flipsidecrypto.com/api/v2/queries/2d132eb6-7524-4853-994f-8d7f91097edc/data/latest'
    ) :"data" as resp
    )
    join lateral flatten (input => resp)
    Run a query to Download Data