afonsoDaily Lending Transactions of Polygon Network Before and after Christmas
    Updated 2023-01-14
    select
    block_timestamp::date as day,
    iff(year(block_timestamp) = 2022, 'Before Christmas', 'After Christmas') as timespan,
    count(distinct tx_hash) as txn_count,
    count(distinct depositor) as lenders_count,
    sum(txn_count) over (order by day) as cumulative_txn_count,
    sum(lenders_count) over (order by day) as cumulative_lenders_count
    from polygon.sushi.ez_lending
    where day between date('2023-01-01') - interval '2 weeks' and date('2023-01-01') + interval '2 weeks'
    group by day, timespan
    order by day
    Run a query to Download Data