20-8-28-8-ezeth_opt.csv

27-8-03-9-ezeth-opt.csv

for user.sql

with b as (select min(id) from blocks where timestamp > 1704067200) select distinct (user_address ) from pool_ledger where pool in (select address from pools where _version=300) and block_num > (select min from b) and event in ('AddLiquidity', 'RemoveLiquidity') group by user_address union (select distinct (borrower)  from credit_sessions where version=300 and since >= (select min from b));

token holding accounts btw two timestamp.sql

with max_block as (select max(id) id from blocks where timestamp < 1725357600),
min_block as (select max(id) id from blocks where timestamp < 1724752800),
css as  ((select * from credit_session_snapshots  
     where balances->'0x2416092f143378750bb29b79eD961ab195CcEea5' is not null and block_num <= (select id from max_block) and block_num > (select id from min_block)) union all select * from (select distinct on (session_id) * from credit_session_snapshots where block_num < (select id from min_block) order by session_id, block_num desc) k where k.balances->'0x2416092f143378750bb29b79eD961ab195CcEea5' is not null)
select b.*, b.end_block-b.start_block no_of_block from 
 (select a.rwseth_amount, 
  least((case when a.next is null then (select id from max_block)::integer else a.next end )::integer, (select id from max_block)::integer) end_block,  
  greatest(a.block_num, (select id from min_block)::integer)  start_block, cs.borrower, cs.account from 
   (select session_id, block_num, balances->'0x2416092f143378750bb29b79eD961ab195CcEea5'->>'F' rwseth_amount, 
     (select min(block_num) from credit_session_snapshots c1 
      where c1.block_num> css.block_num and c1.session_id=css.session_id) next from css) a 
  join credit_sessions cs on  a.session_id = cs.id) b;

token holding session below given block.sql

select b.*, b.end_block-b.start_block no_of_block from 
 (select a.rwseth_amount, 
  least((case when a.next is null then (select max(id) from blocks) else a.next end )::integer, 20422895) end_block,  
  a.block_num  start_block, cs.borrower, cs.account from 
   (select session_id, block_num, balances->'0xFAe103DC9cf190eD75350761e95403b7b8aFa6c0'->>'F' rwseth_amount, 
     (select min(block_num) from credit_session_snapshots c1 
      where c1.block_num> css.block_num and c1.session_id=css.session_id) next from credit_session_snapshots css 
     where balances->'0xFAe103DC9cf190eD75350761e95403b7b8aFa6c0' is not null and block_num <= 20422895) a 
  join credit_sessions cs on  a.session_id = cs.id) b;