Query editor
with dates as (with day_seq as (SELECT (SEQUENCE(CAST('2020-11-03' AS TIMESTAMP), CAST(NOW() as TIMESTAMP), INTERVAL '1' day)) AS day)SELECTdays.dayFROM day_seqCROSS JOIN unnest(day) as days(day)), project_list AS(selectaddress as project,namefrom dune.lido.result_eth_depositors_labels--from query_2005642),selected_project as(select 'Lido' as name),all_txns as(selectCOALESCE(p.name,'Unidentified') as name,--COALESCE(p.category,'Unidentified') as category,t.time,t.amount as amountfrom(select"from" as address,date_trunc('day',block_time) as time,cast(value as double)/1e18 as amountfrom ethereum.traces trwhere to = 0x00000000219ab540356cbb839cbe05303d7705faand date_trunc('day', block_time) >= cast('2020-11-03' as date)and call_type = 'call'and success = True) tleft join project_list as p on t.address = p.projectunion allselectproject as name,--category,date_trunc('day',time) as time,(-1) * withdrawn_principal as amountfrom dune.lido.result_withdrawals_transactions_assigned_to_projects--query_1038304where withdrawn_principal > 0)