flipside

    How long top 50 has delegated ?
    boomer77How long top 50 has delegated ?
    Updated 2021-11-10
    with topdel as
    (select
    delegator_address, sum(event_amount)
    from terra.staking
    where action in ('delegate', 'redelegate') and currency = 'LUNA' and tx_status = 'SUCCEEDED' and validator_address = 'terravaloper1hqyygjq0vdqk0xdpkffgamzr4f7tqqg5u9mg66'
    group by 1
    order by 2 DESC
    limit 50),

    del as
    (select
    delegator_address, event_amount, date_trunc('day', block_timestamp) as days
    from terra.staking
    where action in ('delegate', 'redelegate') and currency = 'LUNA' and tx_status = 'SUCCEEDED' and validator_address = 'terravaloper1hqyygjq0vdqk0xdpkffgamzr4f7tqqg5u9mg66')

    select A.delegator_address, B.event_amount, datediff(day, days, CURRENT_DATE) as How_many_days
    from topdel A
    join del B on A.delegator_address = B.delegator_address
    order by 2 desc
    Run a query to Download Data