mohamadreza221166cTokens transaction types since last 30 days
    Updated 2022-08-04
    WITH solend_trans AS(
    SELECT DISTINCT tx_id, 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 - 30
    AND mint IN(
    '5h6ssFpeDeRbzsEHDbTQNH7nVGgsKrZydxdSTnLm6QdV',
    '993dVFL2uXWYeoXuEBFXR4BijeXdTv4s6BzsCjJZuwqk',
    'AppJPZka33cu4DyUenFe9Dc1ZmZ3oQju6mBn9k37bNAa',
    'Gqu3TFmJXfnfSX84kqbZ5u9JjSBVoesaHjfTsaPjRSnZ',
    '4CxGuD2NMr6zM8f18gr6kRhgd748pnmkAhkY1YJtkup1',
    'BTsbZDV7aCMRJ3VNy9ygV4Q2UeEo9GpR8D6VvmMZzNr8',
    'A38TjtcYrfutXT6nfRxhqwoGiXyzwJsGPmekoZYYmfgP',
    'E9LAZYxBVhJr9Cdfi9Tn4GSiJHDWSZDsew5tfgJja6Cu',
    '2d95ZC8L5XP6xCnaKx8D5U5eX6rKbboBBAwuBLxaFmmJ',
    '4GAGuewTRMfBJukgu3HSzpT48iqP4bYVCq3tygnjqmxL',
    'BsWLxf6hRJnyytKR52kKBiz7qU7BB3SH77mrBxNnYU1G',
    '3JFC4cB56Er45nWVe29Bhnn5GnwQzSmHVf6eUq9ac91h',
    'FbKvdbx5h6F86h1pZuEqv7FxwmsVhJ88cDuSqHvLm6Xf',
    'D3Cu5urZJhkKyNZQQq2ne6xSfzbXLU4RrywVErMA2vf8',
    'AFq1sSdevxfqWGcmcz7XpPbfjHevcJY7baZf9RkyrzoR',
    'QQ6WK86aUCBvNPkGeYBKikk15sUg6aMUEi5PTL6eB4i',
    'nZtL8HKX3aQtk3VpdvtdwPpXF2uMia522Pnan2meqdf',
    'DiMx1n2dJmxqFtENRPhYWsqi8Mhg2p39MpTzsm6phzMP',
    '6XrbsKScacEwpEW5DVNko9t5vW3cim9wktAeT9mmiYHS',
    '4icXEpFVMrcqob6fnd3jZ6KjKrc6cqre6do1f8kKAC1u'
    )
    ),
    solend_events AS (
    SELECT BLOCK_TIMESTAMP,
    VALUE:instructions:parsed:type AS type,
    VALUE:instructions:parsed:amount AS amount
    FROM solana.core.fact_events , table (flatten (input=> INNER_INSTRUCTION)) AS tbl
    WHERE tx_id IN(SELECT distinct tx_id FROM solend_trans )
    )
    Run a query to Download Data