SELECT * FROM (

VALUES

('0x532f27101965dd16442e59d40670faf5ebb142e4', '$BRETT'),

('0xafb89a09d82fbde58f18ac6437b3fc81724e4df6', '$The Doge NFT'),

('0x4ed4e862860bed51a9570b96d89af5e1b0efefed', '$DEGEN'),

('0xac1bd2486aaf3b5c0fc3fd868558b082a531b2b4', '$TOSHI'),

('0x6921B130D297cc43754afba22e5EAc0FBf8Db75b', '$doginme'),

('0x4dd9077269dd08899f2a9e73507125962b5bc87f', '$CRASH'),

('0xb1a03eda10342529bbf8eb700a06c60441fef25d', '$MIGGLES'),

('0x5d559ea7bb2dae4b694a079cb8328a2145fd32f6', '$OWO'),

('0x47b464eDB8Dc9BC67b5CD4C9310BB87b773845bD', '$NORMIE'),

('0x9a26F5433671751C3276a065f57e5a02D2817973', '$KEYCAT'),

('0x768BE13e1680b5ebE0024C42c896E3dB59ec0149', '$SKI'),

('0xcA8e8d244f0d219a6Fc9e4793C635cEA98d0399C', '$CAT'),

('0x15aC90165f8B45A80534228BdCB124A011F62Fee', '$MOEW'),

('0x26F1bB40eA88B46CEB21557dC0FfAC7B7c0ad40f', '$ALF'),

('0xf6e932ca12afa26665dc4dde7e27be02a7c02e50', '$MOCHI'),

('0x2ad3d80c917ddBf08aCc04277f379e00e4D75395', '$COW'),

('0xebfF2db643Cf955247339c8c6bCD8406308ca437', '$CHOMP'),

('0xcdE172dc5ffC46D228838446c57C1227e0B82049', '$BOOMER'),

('0x1b6a569dd61edce3c383f6d565e2f79ec3a12980', '$PEEZY'),

('0x88faea256f789f8dd50de54f9c807eef24f71b16', '$WOLF'),

('0x52b492a33E447Cdb854c7FC19F1e57E8BfA1777D', '$PEPE'),

('0xf6e932ca12afa26665dc4dde7e27be02a7c02e50', '$CTO')

) AS t (contract_address, token_name)

),

swaps AS (

SELECT

date_trunc('hour', BLOCK_TIMESTAMP) AS "Date_Hour",

ci.token_name AS "Token_Name",

CASE

WHEN TOKEN_OUT = ci.contract_address THEN 'Buy'

WHEN TOKEN_IN = ci.contract_address THEN 'Sell'

END AS "Type",