pavlyshyn2023-04-18 06:19 PM
    select
    toDate (created_at, 'UTC') as Date,
    hash,
    t1.delegator as
    from
    ,
    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',
    Run a query to Download Data