binhachonStaking SOL on Marinade - Top 10 frequency
    Updated 2022-03-05
    select
    swap_to_mint,
    address_name,
    sum(swap_from_amount) as amount,
    count(*) as frequency,
    row_number() over (order by frequency desc) as rank
    from solana.swaps
    left join solana.labels on (address = swap_to_mint)
    where date_trunc('day', block_timestamp) >= '2022-02-01 00:00:00.000'
    and swap_from_mint = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So'
    and swap_program like '%jupiter%'
    group by swap_to_mint, address_name
    order by frequency desc
    limit 10

    Run a query to Download Data