toDate (created_at, 'UTC') as Date,

hash,

t1.delegator as

,

validator as to,

round(amount / pow(10, 6), 2) as amount,

if (

abs(amount) / pow(10, 6) >= 100000,

'whale',

'retail'

) as tx_size,

multiIf (

memo = 'Delegated with Exodus'

OR memo = 'Delegate(rewards)',

'Exodus',

memo = 'Stake via Trust Wallet',

'Trust Wallet',

memo = 'Ledger Live'

OR memo = 'LedgerLiveBot',

'Ledger Live',

memo = 'atomicwallet',

'Atomic wallet',

memo = 'imToken-DeFiApi'

OR memo = 'Reinvest rewards from imToken',

'imToken',

memo = 'delegation via citadel.one'

or memo = 'redelegation via citadel.one',

'Citadel.one app',

memo = 'MOONSTAKE:ATOM',

'Moonstake',

memo = 'Ellipal',

'Ellipal',

memo = 'delegate from TokenPocket',

'TokenPocket',