with a200 as (with a100 as (with abc as ( with a as ( with c as ( select HOUR as h1, PRICE as token_price from ethereum.core.fact_hourly_token_prices where TOKEN_ADDRESS = lower('0x49d72e3973900a195a155a46441f0c08179fdb64')) ,d as ( select HOUR as h2 , PRICE as eth_price from ethereum.core.fact_hourly_token_prices where SYMBOL='WETH') select token_price / eth_price as p1 , h1 from c join d on c.h1 = d.h2 ), b as ( select date_trunc('hour', BLOCK_TIMESTAMP) as h , RAW_AMOUNT/1e18 as ra , ORIGIN_FROM_ADDRESS from ethereum.core.fact_token_transfers where CONTRACT_ADDRESS = lower('0x49d72e3973900a195a155a46441f0c08179fdb64') ) select a.p1 * b.ra as eth_val from a join b on a.h1 = b.h union select ETH_VALUE from ethereum.core.fact_transactions where TX_HASH in (select TX_HASH from ethereum.core.fact_token_transfers where TX_HASH in (select TX_HASH from ethereum.core.fact_event_logs where CONTRACT_ADDRESS = '0xc874b064f465bdd6411d45734b56fac750cda29a' and ORIGIN_FUNCTION_SIGNATURE = '0x040dee8a') and CONTRACT_ADDRESS = '0xfe2e637202056d30016725477c5da089ab0a043a') and STATUS= 'SUCCESS' union select ETH_VALUE from ethereum.core.fact_transactions where TX_HASH in ( select TX_HASH from ethereum.core.fact_event_logs where CONTRACT_ADDRESS='0x84db6ee82b7cf3b47e8f19270abde5718b936670' and EVENT_NAME='StakeConfirmed') and ORIGIN_FUNCTION_SIGNATURE in (select'0x3a4b66f1'union select'0x9fa65c56') and STATUS= 'SUCCESS' union select ETH_VALUE from ethereum.core.fact_transactions where TX_HASH in ( select TX_HASH from ethereum.core.fact_event_logs where CONTRACT_ADDRESS='0xae7ab96520de3a18e5e111b5eaab095312d7fe84' ) and STATUS= 'SUCCESS' and ORIGIN_FUNCTION_SIGNATURE= '0xa1903eab' union select ETH_VALUE from ethereum.core.fact_transactions where TX_HASH in (select TX_HASH from ethereum.core.fact_token_transfers where TX_HASH in (select TX_HASH from ethereum.core.fact_event_logs where CONTRACT_ADDRESS = lower('0x4d05e3d48a938db4b7a9a59a802d5b45011bde58') ) ) and STATUS= 'SUCCESS' and ETH_VALUE <> 0 union select ETH_VALUE from ethereum.core.fact_transactions where TX_HASH in ( select TX_HASH from ethereum.core.fact_event_logs where CONTRACT_ADDRESS=lower('0x00000000219ab540356cbb839cbe05303d7705fa')) and STATUS= 'SUCCESS' and ETH_VALUE <> 0 ) select eth_val from abc ) select eth_val , case WHEN eth_val >= 0 and eth_val < 0.1 THEN ' 01 => 0-0.1 WETH' WHEN eth_val >= 0.1 and eth_val < 0.2 THEN ' 02 => 0.1-0.2 WETH' WHEN eth_val >= 0.2 and eth_val < 0.3 THEN ' 03 => 0.2-0.3 WETH' WHEN eth_val >= 0.3 and eth_val < 0.4 THEN ' 04 => 0.3-0.4 WETH' WHEN eth_val >= 0.4 and eth_val < 0.5 THEN ' 05 => 0.4-0.5 WETH' WHEN eth_val >= 0.5 and eth_val < 0.6 THEN ' 06 => 0.5-0.6 WETH' WHEN eth_val >= 0.6 and eth_val < 0.7 THEN ' 07 => 0.6-0.7 WETH' WHEN eth_val >= 0.7 and eth_val < 0.8 THEN ' 08 => 0.7-0.8 WETH' WHEN eth_val >= 0.8 and eth_val < 0.9 THEN ' 09 => 0.8-0.9 WETH' WHEN eth_val >= 0.9 and eth_val < 1 THEN ' 10 => 0.9-1 WETH' WHEN eth_val >= 1 and eth_val < 1.1 THEN ' 11 => 1-1.1 WETH' WHEN eth_val >= 1.1 and eth_val < 1.2 THEN ' 12=> 1.1-1.2 WETH' WHEN eth_val >= 1.2 and eth_val < 1.3 THEN ' 13=> 1.2-1.3 WETH' WHEN eth_val >= 1.3 and eth_val < 1.4 THEN ' 14=> 1.3-1.4 WETH' WHEN eth_val >= 1.4 and eth_val < 1.5 THEN ' 14=> 1.4-1.5 WETH' WHEN eth_val >= 1.5 and eth_val < 1.6 THEN ' 15=> 1.5-1.6 WETH' WHEN eth_val >= 1.6 and eth_val < 1.7 THEN ' 16=> 1.6-1.7 WETH' WHEN eth_val >= 1.7 and eth_val < 1.8 THEN ' 17=> 1.7-1.8 WETH' WHEN eth_val >= 1.8 and eth_val < 1.9 THEN ' 18=> 1.8-1.9 WETH' WHEN eth_val >= 1.9 and eth_val < 2 THEN ' 19=> 1.9-2 WETH' WHEN eth_val >= 2 and eth_val < 3 THEN ' 20=> 2-3 WETH' WHEN eth_val >= 3 and eth_val < 4 THEN ' 21=> 3-4 WETH' WHEN eth_val >= 4 and eth_val < 5 THEN ' 22=> 4-5 WETH' WHEN eth_val >= 5 and eth_val < 6 THEN ' 23=> 5-6 WETH' WHEN eth_val >= 6 and eth_val < 7 THEN ' 24=> 6-7 WETH' WHEN eth_val >= 7 and eth_val < 8 THEN ' 25=> 7-8 WETH' WHEN eth_val >= 8 and eth_val < 9 THEN ' 26=> 8-9 WETH' WHEN eth_val >= 9 and eth_val < 10 THEN ' 27=> 9-10 WETH' WHEN eth_val >= 10 and eth_val < 15 THEN ' 28=> 10-15 WETH' WHEN eth_val >= 15 and eth_val < 20 THEN ' 29=> 15-20 WETH' WHEN eth_val >= 20 and eth_val < 30 THEN ' 30=> 20-30 WETH' WHEN eth_val >= 30 and eth_val < 40 THEN ' 31=> 30-40 WETH' WHEN eth_val >= 40 and eth_val < 50 THEN ' 32=> 40-50 WETH' WHEN eth_val >= 50 and eth_val < 60 THEN ' 33=> 50-60 WETH' WHEN eth_val >= 60 and eth_val < 70 THEN ' 34=> 60-70 WETH' WHEN eth_val >= 70 and eth_val < 80 THEN ' 35=> 70-80 WETH' WHEN eth_val >= 80 and eth_val < 90 THEN ' 36=> 80-90 WETH' WHEN eth_val >= 90 and eth_val < 100 THEN ' 37=> 90-100 WETH' WHEN eth_val >= 100 and eth_val < 110 THEN ' 38=> 100-110 WETH' WHEN eth_val >= 110 and eth_val < 120 THEN ' 39=> 110-120 WETH' WHEN eth_val >= 120 and eth_val < 130 THEN ' 40=> 120-130 WETH' WHEN eth_val >= 130 and eth_val < 140 THEN ' 41=> 130-140 WETH' WHEN eth_val >= 140 and eth_val < 150 THEN ' 42=> 140-150 WETH' WHEN eth_val >= 150 and eth_val < 2*163 THEN ' 43=> 150-326 WETH' WHEN eth_val >= 2*163 and eth_val < 3*163 THEN ' 44=> 326-489 WETH' WHEN eth_val >= 3*163 and eth_val < 4*163 THEN ' 45=> 489-652 WETH' WHEN eth_val >= 4*163 and eth_val < 5*163 THEN ' 46=> 652-815 WETH' WHEN eth_val >= 5*163 and eth_val < 6*163 THEN ' 47=> 815-977 WETH' WHEN eth_val >= 6*163 and eth_val < 7*163 THEN ' 48=> 977-1140 WETH' WHEN eth_val >= 7*163 and eth_val < 8*163 THEN ' 49=> 1140-1303 WETH' WHEN eth_val >= 8*163 and eth_val < 9*163 THEN ' 50=> 1303-1466 WETH' WHEN eth_val >= 9*163 and eth_val < 10*163 THEN ' 51=> 1466-1629 WETH' WHEN eth_val >= 10*163 and eth_val < 11*163 THEN ' 52=> 1629-1792 WETH' WHEN eth_val >= 11*163 and eth_val < 12*163 THEN ' 53=> 1792-1955 WETH' WHEN eth_val >= 12*163 and eth_val < 13*163 THEN ' 54=> 1955-2118 WETH' WHEN eth_val >= 13*163 and eth_val < 14*163 THEN ' 55=> 2118-2281 WETH' WHEN eth_val >= 14*163 and eth_val < 15*163 THEN ' 56=> 2281-2444 WETH' WHEN eth_val >= 15*163 and eth_val < 16*163 THEN ' 57=> 2444-2608 WETH' WHEN eth_val >= 16*163 and eth_val < 17*163 THEN ' 58=> 2608-2771 WETH' WHEN eth_val >= 17*163 and eth_val < 18*163 THEN ' 59=> 2771-2934 WETH' WHEN eth_val >= 18*163 and eth_val < 2*3099.95 THEN ' 60=> 2934-6199.9 WETH' WHEN eth_val > 2*3099.95 THEN ' 61=> >6199.9 WETH' end as flag from a100 ) select flag , count (eth_val) from a200 group by flag order by flag

Liquid Staking ETH Platforms Analysis