receiver as bridger

from cosmos.core.fact_transfers

where tx_succeeded = 'TRUE'

and transfer_type = 'IBC_TRANSFER_OUT'

and receiver like 'osmo%'

and currency = 'uatom'),

gov_deposit as (select 'Governance Deposit' as Action_Type,

block_timestamp,

tx_id,

depositor as wallets

from osmosis.core.fact_governance_proposal_deposits a

join table_1 b on a.depositor = b.bridger and a.block_timestamp > b.bridge_date

where tx_status = 'SUCCEEDED'),

gov_propose as (select 'Governance Propose' as Action_Type,

block_timestamp,

tx_id,

proposer as wallets

from osmosis.core.fact_governance_submit_proposal a

join table_1 b on a.proposer = b.bridger and a.block_timestamp > b.bridge_date

where tx_status = 'SUCCEEDED'),

gov_vote as (select 'Governance Vote' as Action_Type,

block_timestamp,

tx_id,

voter as wallets

from osmosis.core.fact_governance_votes a

join table_1 b on a.voter = b.bridger and a.block_timestamp > b.bridge_date

where tx_status = 'SUCCEEDED'),

lped as (select 'Liquidity Providing' as Action_Type,

block_timestamp,

tx_id,

liquidity_provider_address as wallets