SELECT * from flipside_prod_db.crosschain.address_labels

where BLOCKCHAIN = 'flow'

AND LABEL_TYPE <> 'operator'

),

base_address_name AS (

SELECT

CASE

WHEN address ilike 'a.%' THEN concat('0x' ,lower (split_part(address,'.', 2)))

ELSE iff(address NOT ilike '0x%' ,concat('0x', address), address ) END AS addresses,

CASE WHEN addresses = '0x 0xb65cb9286d8eab6c' THEN '0xb65cb9286d8eab6c' ELSE addresses END AS addresses2,

label_type , label_subtype , address_name , project_name

FROM All_flow_names

),

base_in_Flow AS (

SELECT event_data:to AS address,

sum (event_data:amount) AS total_deposits

FROM flow.core.fact_events

WHERE event_contract = 'A.1654653399040a61.FlowToken'

AND event_type = 'TokensDeposited'

AND tx_succeeded = 'TRUE'

GROUP BY 1

),

base_out_flow AS (

SELECT event_data:from AS address,

sum (event_data:amount) AS total_withdrwns

FROM flow.core.fact_events

WHERE event_contract = 'A.1654653399040a61.FlowToken'

AND event_type = 'TokensWithdrawn'

AND tx_succeeded = 'TRUE'

GROUP BY 1

),