Copy of Copy of Untitled Query

lagandispenserCopy of Copy of Untitled Query

Updated 2022-08-02

select date_trunc('day', block_timestamp) as day,

--count (case when program_id = 'Port7uDYB3wk6GJAw4KT1WpTeMtSu9bTcChBHkX2LfR' then 1 end) as Port_Finance_v1,

-- count (case when program_id = 'HajXYaDXmohtq2ZxZ6QVNEpqNn1T53Zc9FnR1CnaNnUf' then 1 end) as Parrot_Finance,

-- count (case when program_id = 'MarBmsSgKXdrN1egZf5sqe1TMai9K1rChYNDJgjq7aD' then 1 end) as Marinade_Finance,

count (case when program_id ilike 'So1endDq2YkqhipRh3WViPa8hdiSpxWy6z3Z6tMCpAo' then 1 end) as Solend_Protocol

from solana.core.fact_events

where day >= '2022-06-01'

--and succeeded = 'TRUE'

group by day

Run a query to Download Data

flipside