Flipside Teamholders
Updated 2024-08-06
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
›
⌄
with base as (
select block_timestamp,
'Inflow' as type,
amount,
tx_to as wallet
from solana.core.fact_transfers
where mint = '4vMsoUT2BWatFweudnQM1xedRLfJgJ7hswhcpz4xgBTy'
UNION ALL
select a.block_timestamp,
'Inflow' as type,
mint_amount/pow(10, decimal) as amount,
owner as wallet
from solana.defi.fact_token_mint_actions a
join solana.core.fact_token_account_owners b on (token_account = account_address)
where mint = '4vMsoUT2BWatFweudnQM1xedRLfJgJ7hswhcpz4xgBTy'
UNION ALL
select block_timestamp,
'Outflow' as type,
amount,
tx_from as wallet
from solana.core.fact_transfers
where mint = '4vMsoUT2BWatFweudnQM1xedRLfJgJ7hswhcpz4xgBTy'
UNION ALL
select a.block_timestamp,
'Outflow' as type,
burn_amount/pow(10, decimal) as amount,
owner as wallet
from solana.defi.fact_token_burn_actions a
join solana.core.fact_token_account_owners b on (token_account = account_address)
where mint = '4vMsoUT2BWatFweudnQM1xedRLfJgJ7hswhcpz4xgBTy'
QueryRunArchived: QueryRun has been archived