with stakes as (select 'Lido' as platform, tx_hash, sum (amount) as eth_amount from ethereum.core.ez_eth_transfers where eth_to_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84' and block_timestamp::date >= current_date - {{past_day}} and block_timestamp::date< current_date group by 2 UNION select 'ankr' as platform, tx_hash, sum (event_inputs:value/1e18) as eth_amount from ethereum.core.fact_event_logs where origin_to_address = lower('0x84db6eE82b7Cf3b47E8F19270abdE5718B936670') and event_inputs:from = lower('0x84db6eE82b7Cf3b47E8F19270abdE5718B936670') and origin_function_signature in ('0x9fa65c56','0xeb834a2c') -- Aeth C , Aeth B and block_timestamp::date >= current_date - {{past_day}} and block_timestamp::date< current_date group by 2 UNION select 'RocketPool' as platform, tx_hash, sum (event_inputs:value/1e18) as eth_amount from ethereum.core.fact_event_logs where origin_to_address = lower('0x4D05E3d48a938db4b7a9A59A802D5b45011BDe58') and origin_function_signature = '0xd0e30db0' -- Deposit and event_name = 'Transfer' and block_timestamp::date >= current_date - {{past_day}} and block_timestamp::date< current_date group by 2 UNION select 'Stakewise' as platform, tx_hash, sum (event_inputs:value/1e18) as eth_amount from ethereum.core.fact_event_logs where origin_to_address = lower('0xC874b064f465bdD6411D45734b56fac750Cda29A') and origin_function_signature in ('0x4a58db19','0x3a4b66f1','0x040dee8a') and block_timestamp::date >= current_date - {{past_day}} and block_timestamp::date< current_date group by 2 UNION select 'Shared_Stake' as platform, tx_hash, sum (event_inputs:value/1e18) as eth_amount from ethereum.core.fact_event_logs where origin_to_address = lower('0x898BAD2774EB97cF6b94605677F43b41871410B1') and origin_function_signature = '0xa9059cbb' -- Deposit and block_timestamp::date >= current_date - {{past_day}} and block_timestamp::date< current_date group by 2 UNION select 'Cream' as platform, tx_hash, sum (event_inputs:value/1e18) as eth_amount from ethereum.core.fact_event_logs where origin_to_address in ('0xcbc1065255cbc3ab41a6868c22d1f1c573ab89fd','0x49d72e3973900a195a155a46441f0c08179fdb64') and origin_function_signature = '0xa9059cbb' -- Transfer and block_timestamp::date >= current_date - {{past_day}} and block_timestamp::date< current_date group by 2 UNION select 'kraken' as platform, tx_hash, sum (amount) as eth_amount from ethereum.core.ez_eth_transfers where ORIGIN_FROM_ADDRESS = lower('0xa40dFEE99E1C85DC97Fdc594b16A460717838703') and block_timestamp::date >= current_date - {{past_day}} and block_timestamp::date< current_date group by 2 UNION select 'Bitcoin Suisse' as platform, tx_hash, sum (amount) as eth_amount from ethereum.core.ez_eth_transfers where ORIGIN_FROM_ADDRESS = lower('0xc2288B408Dc872A1546F13E6eBFA9c94998316a2') and origin_function_signature = '0x22895118' -- Deposit and block_timestamp::date >= current_date - {{past_day}} and block_timestamp::date< current_date group by 2 UNION select 'stake fish' as platform, tx_hash, sum (amount) as eth_amount from ethereum.core.ez_eth_transfers where ETH_TO_ADDRESS = '0x0194512e77d798e4871973d9cb9d7ddfc0ffd801' and origin_function_signature = '0xc82655b7' -- batch Deposit and block_timestamp::date >= current_date - {{past_day}} and block_timestamp::date< current_date group by 2 ) select platform, case when eth_amount < 0.01 then 'Less Than 0.01 ETH' when eth_amount BETWEEN 0.01 and 0.1 then '0.01 - 0.1 ETH' when eth_amount BETWEEN 0.1 and 1 then '0.1 - 1 ETH' when eth_amount BETWEEN 1 and 10 then '1 - 10 ETH' when eth_amount BETWEEN 10 and 100 then '10 - 100 ETH' when eth_amount BETWEEN 100 and 1000 then '100 - 1000 ETH' else 'more than 1000 ETH' end as VOLUME, count (Distinct tx_hash) as count from stakes group by 1,2 order by 3 desc

Open Analytics Bounty: ETH