PapasotMonthly $Near Balance of Wallets Query copy
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
›
⌄
-- forked from a2fef2bb-37c7-4ba4-a318-bf0f3394c822
-- Credit: pinehearst -> https://app.flipsidecrypto.com/velocity/queries/c741fb3e-aad8-4027-b4ab-50836391db2f
with tx AS (
-- finding transfers from multisender, which does not appears in transfers table
SELECT
block_timestamp,
tx_hash,
tx_signer,
tx_receiver,
tx_status,
method_name,
TRY_PARSE_JSON(args) :accounts as accounts
FROM
near.core.fact_actions_events_function_call
LEFT JOIN (
SELECT
tx_hash as tx_hash1,
tx_signer,
tx_receiver,
tx_status
FROM
near.core.fact_transactions
) ON tx_hash = tx_hash1
WHERE
1 = 1 -- AND tx_receiver = 'multisender.app.near'
AND tx_Status = 'Success'
AND method_name LIKE '%multisend%' -- AND tx_hash IN ('6vLNZ2eyYvPq34WeVAeWermU7cgJNWDPJJBJDPvUVeRT', -- multisend_from_balance_unsafe / shows up in function call / fs payments
-- 'ApGcBzUw4FY4b6fznemzTpdF8EVAx14rJLit3XVzGRXM', -- multisend_from_balance / shows up in function call
-- '99z3PaHjB8uyCpbAkN11sDNnTbRDzEBqw9QDpYGHptV', -- multisend_attached_tokens / shows up in function call
-- 'FcECK8UwFKxTVsaHfyW6EYvZPXuuBQ2HUt3t7Ek4WYGw', -- simple transfer / does NOT show up in function call
-- '73RQQF15hjwfioAdJbSp5MyyDzRW9WfBpvKHy4DN34Kp') -- swaps / shows up in function call / need to filter token_in, token_out (need wrapped near)
),
---------------------------------------- SWAPS ----------------------------------------
near_token_address AS (
select
Run a query to Download Data