shadilSushiswap DEX Loyal Users - inception
    Updated 2022-05-07
    SELECT
    COUNT(DISTINCT tx_id) as trxs,
    count(distinct date_trunc('day', block_timestamp)) as days,
    row_number() over (order by trxs DESC) as trxs_rank,
    row_number() over (order by days DESC) as days_rank,
    from_address as wallet,
    date_trunc('year', block_timestamp) as date
    from ethereum.dex_swaps
    where platform = 'sushiswap'
    and from_address not in ('0xd9e1ce17f2641f24ae83637ab66a2cca9c378b9f', '0x11111112542d85b3ef69ae05771c2dccff4faa26', '0xdef1c0ded9bec7f1a1670819833240f027b25eff', '0x1111111254fb6c44bac0bed2854e76f90643097d', '0xa57bd00134b2850b2a1c55860c9e9ea100fdd6cf',
    '0x8aff5ca996f77487a4f04f1ce905bf3d27455580', '0x0000005c9426e6910f22f0c00ed3690a4884dd6e', '0xdef171fe48cf0115b1d80b88dc8eab59176fee57', '0x0000000000007f150bd6f54c40a34d7c3d5e9f56', '0x27239549dd40e1d60f5b80b0c4196923745b1fd2')
    GROUP BY date, wallet
    order by trxs_rank ASC
    Run a query to Download Data