AUM | |
|---|---|
1 | 1597472606.15 |
flyingfishPool Accounts Balance copy
Updated 59 minutes ago
99
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 Pool Accounts Balance @ https://flipsidecrypto.xyz/edit/queries/7941f337-da96-484d-a014-cb518e33a191
-- SOL: BUvduFTd2sWFagCunBPLupG8fBTJqweLw9DuhruNFSCm
-- ETH: Bgarxg65CEjN3kosjCW5Du3wEqvV3dpCGDR3a2HRQsYJ
-- BTC: FgpXg2J3TzSs7w3WGYYE7aWePdrxBVLCXSxmAKnCZNtZ
-- USDC: WzWUoCmtVv7eqAbU3BfKPU3fhLP6CXR8NCJH78UK9VS
-- USDT: Gex24YznvguMad1mBzTQ7a64U1CJy59gvsStQmNnnwAd
/*
SELECT
helius_apis.balances(
'mainnet', -- the network, 'mainnet' or 'devnet'
'AVzP2GeRmqGphJsMxWoqjpUifPpCret7LqWhD8NWQK49' -- the address to retrieve the balance for
) as resp
*/
with raw_data AS (
SELECT helius_das.get_assets_by_owner( 'mainnet', -- the network, 'mainnet' or 'devnet'
{ 'ownerAddress': 'AVzP2GeRmqGphJsMxWoqjpUifPpCret7LqWhD8NWQK49',
'page': 1, -- Starts at 1
'limit': 1000 ,
'displayOptions': {
'showFungible': true --//return both fungible and non-fungible tokens
}
} ) as response
)
/*
with raw_data AS (
select
value:mint as mint
, value:amount / value:decimals as amount
--, value:decimals as decimals
from (
select
helius_apis.balances(
'mainnet', -- the network, 'mainnet' or 'devnet'
'AVzP2GeRmqGphJsMxWoqjpUifPpCret7LqWhD8NWQK49' -- the address to retrieve the balance for
) as response
Last run: about 1 hour agoAuto-refreshes every 3 hours
1
17B
3s