SELECT block_timestamp AS Dates, (inner_instruction:instructions[2]:parsed:info:amount)/1e9 AS Supply_Amount

FROM solana.core.fact_events

WHERE block_timestamp >= '2022-02-05' and block_timestamp < CURRENT_DATE

AND succeeded = 'TRUE'

AND instruction:programId = 'So1endDq2YkqhipRh3WViPa8hdiSpxWy6z3Z6tMCpAo'

AND instruction:accounts[0] = 'B1ATuYXNkacjjJS78MAmqu8Lu8PvEPt51u4oBasH1m1g')

SELECT DATE(Dates) AS "Time Line", CASE

WHEN (Supply_Amount >= 1) AND (Supply_Amount < 100) THEN 'Between 1 and 100 SOL'

WHEN (Supply_Amount >= 100) AND (Supply_Amount < 1000) THEN 'Between 100 and 1K SOL'

WHEN (Supply_Amount >= 1000) AND (Supply_Amount < 10000) THEN 'Between 1K and 10K SOL'

WHEN (Supply_Amount >= 10000) THEN 'More than 10K'

ELSE 'Under 1 SOL' END AS "Amount Distribution", SUM(Supply_Amount) AS "withdraw Amount", COUNT(Supply_Amount) AS "Daily Number of transactions"

FROM Supplying

GROUP BY "Time Line", "Amount Distribution"