mohamadreza221166top 5 wallets that have transaction with cTokens
    Updated 2022-08-04
    WITH solend_events AS (
    SELECT
    VALUE:mint AS mint,
    VALUE:owner AS wallet,
    VALUE:uiTokenAmount:uiAmount AS amount
    FROM solana.core.fact_transactions , table (flatten (input => POST_TOKEN_BALANCES)) AS tbl
    WHERE BLOCK_TIMESTAMP::DATE >= CURRENT_DATE - 90
    AND mint IN(
    '5h6ssFpeDeRbzsEHDbTQNH7nVGgsKrZydxdSTnLm6QdV',
    '993dVFL2uXWYeoXuEBFXR4BijeXdTv4s6BzsCjJZuwqk',
    'AppJPZka33cu4DyUenFe9Dc1ZmZ3oQju6mBn9k37bNAa',
    'Gqu3TFmJXfnfSX84kqbZ5u9JjSBVoesaHjfTsaPjRSnZ',
    '4CxGuD2NMr6zM8f18gr6kRhgd748pnmkAhkY1YJtkup1',
    'BTsbZDV7aCMRJ3VNy9ygV4Q2UeEo9GpR8D6VvmMZzNr8',
    'A38TjtcYrfutXT6nfRxhqwoGiXyzwJsGPmekoZYYmfgP',
    'E9LAZYxBVhJr9Cdfi9Tn4GSiJHDWSZDsew5tfgJja6Cu',
    '2d95ZC8L5XP6xCnaKx8D5U5eX6rKbboBBAwuBLxaFmmJ',
    '4GAGuewTRMfBJukgu3HSzpT48iqP4bYVCq3tygnjqmxL',
    'BsWLxf6hRJnyytKR52kKBiz7qU7BB3SH77mrBxNnYU1G',
    '3JFC4cB56Er45nWVe29Bhnn5GnwQzSmHVf6eUq9ac91h',
    'FbKvdbx5h6F86h1pZuEqv7FxwmsVhJ88cDuSqHvLm6Xf',
    'D3Cu5urZJhkKyNZQQq2ne6xSfzbXLU4RrywVErMA2vf8',
    'AFq1sSdevxfqWGcmcz7XpPbfjHevcJY7baZf9RkyrzoR',
    'QQ6WK86aUCBvNPkGeYBKikk15sUg6aMUEi5PTL6eB4i',
    'nZtL8HKX3aQtk3VpdvtdwPpXF2uMia522Pnan2meqdf',
    'DiMx1n2dJmxqFtENRPhYWsqi8Mhg2p39MpTzsm6phzMP',
    '6XrbsKScacEwpEW5DVNko9t5vW3cim9wktAeT9mmiYHS',
    '4icXEpFVMrcqob6fnd3jZ6KjKrc6cqre6do1f8kKAC1u'
    )
    )

    SELECT wallet, COUNT(*) as tx_number
    FROM solend_events
    GROUP BY 1
    ORDER BY 2 DESC
    LIMIT 5
    Run a query to Download Data