MLDZMNTop senders by transfer volume in USD
Updated 2023-11-02
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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