SELECT DATE_TRUNC('day', block_timestamp) as day,

SUM(amount_out) as num_sushi, COUNT(DISTINCT tx_hash) as num_transfers

FROM ethereum_sushi.ez_swaps

WHERE event_name = 'Swap'

AND sender = '0x5ad6211cd3fde39a9cecb5df6f380b8263d1e277'

AND tx_to = '0x8798249c2e607446efb7ad49ec89dd1865ff4272'

AND symbol_out = 'SUSHI'

GROUP BY day

),

sushibar AS (

SELECT DATE_TRUNC('DAY', block_timestamp) as day, SUM(event_inputs:value / POWER(10,18)) as num_sushi_staked

FROM ethereum_core.fact_event_logs

WHERE contract_address = '0x6b3595068778dd592e39a122f4f5a5cf09c90fe2'

AND event_name = 'Transfer'

AND event_inputs:to = '0x8798249c2e607446efb7ad49ec89dd1865ff4272'

GROUP BY day

SELECT b.day, num_sushi, num_transfers, num_sushi_staked

FROM sushimaker a FULL JOIN sushibar b

ON a.day = b.day

WHERE b.day >= current_date - 150