WITH fees_to_bot AS (

SELECT ft.tx_id

, ft.block_timestamp

, DATE_TRUNC('hour', ft.block_timestamp) AS date_hour

, ft.amount AS tokens_amt

, case when ft.mint = 'So11111111111111111111111111111111111111111'

then 'So11111111111111111111111111111111111111112' else ft.mint

end as token_mint

, ez.symbol

, ft.amount * p.price AS fees_usd

, CASE

when tx_to = '9yMwSPk9mrXSN7yDHUuZurAh1sjbJsfpUqjZ7SvVtdco' then 'trojan'

when tx_to = 'ZG98FUCjb8mJ824Gbs6RsgVmr1FhXb2oNiJHa2dwmPd' then 'bonkbot'

when tx_to = '9cSuF94JWPb1HQzWMcifJzkoggwAtfjsojcUqny5XuJy' then 'shuriken'

when tx_to = 'F4hJ3Ee3c5UuaorKAMfELBjYCjiiLH75haZTKqTywRP3' then 'bullx'

when tx_to = 'AVUCZyuT35YSuj4RH7fwiyPu82Djn2Hfg7y2ND2XcnZH' then 'photon'

when tx_to = '47hEzz83VFR23rLTEeVm9A7eFzjJwjvdupPPmX3cePqF' then 'bananagun'

when tx_to = 'K1LRSA1DSoKBtC5DkcvnermRQ62YxogWSCZZPWQrdG5' then 'soltradingbot'

when tx_to = 'HEPL5rTb6n1Ax6jt9z2XMPFJcDe9bSWvWQpsK7AMcbZg' then 'soltradingbot'

when tx_to = 'F34kcgMgCF7mYWkwLN3WN7KrFprr2NbwxuLvXx4fbztj' then 'soltradingbot'

when tx_to = '96aFQc9qyqpjMfqdUeurZVYRrrwPJG2uPV6pceu4B1yb' then 'soltradingbot'

when tx_to = 'CPixcsP8LEMeUoavaHG3bdkywR8s4mZXNN3mYUgbXFev' then 'memebot'

when tx_to = '3eFTz1qaXK3HauDfXcjJo4KMJukCv2D9Futq9GP3AYyp' then 'xception'

when tx_to = 'CPixcsP8LEMeUoavaHG3bdkywR8s4mZXNN3mYUgbXFev' then 'magnumbot'

when tx_to = '8FEE2ghpWPoxsypBLW87yyqmChjUbcZz41V7bzfiJqGF' then 'unibot'

when tx_to = '45ruCyfdRkWpRNGEqWzjCiXRHkZs8WXCLQ67Pnpye7Hp' then 'unibot'

when tx_to = 'FRMxAnZgkW58zbYcE7Bxqsg99VWpJh6sMP5xLzAWNabN' then 'maestro'

else 'unknown'

end as bot_name

FROM solana.core.fact_transfers ft

INNER JOIN solana.price.ez_asset_metadata ez

ON token_mint = ez.token_address

INNER JOIN solana.price.ez_prices_hourly p

ON token_mint = p.token_address