Whale as

(SELECT address, balance, date, currency

FROM terra.daily_balances

WHERE date = CURRENT_DATE

AND currency = 'LUNA'

ORDER BY Balance DESC

limit 10),

Swap as

(SELECT trader, sum(offer_amount) as Swap_offer

from terra.swaps

where ask_currency = 'luna' or offer_currency = 'luna' and

trader = 'terra1fl48vsnmsdzcv85q5d2q4z5ajdha8yu3nln0mh' or

trader = 'terra1dp0taj85ruc299rkdvzp4z5pfg6z6swaed74e6' or

trader = 'terra1mtwph2juhj0rvjz7dy92gvl6xvukaxu8rfv8ts' or

trader = 'terra1jv65s3grqf6v6jl3dp4t6c9t9rk99cd8pm7utl' or

trader = 'terra1dp0taj85ruc299rkdvzp4z5pfg6z6swaed74e6' or

trader = 'terra15s66unmdcpknuxxldd7fsr44skme966tdckq8c' or

trader = 'terra1p54hc4yy2ajg67j645dn73w3378j6k05v52cnk' or

trader = 'terra1wqwfwh797tf77e2xpvy9xx082pwpxxlm9x4xws' or

trader = 'terra13u66u4knssnws7n7w0n38mzyyqak5ygp807gyl' or

trader = 'terra17fc39atdvxgum707qcejv3w9jeznnxvy6tx786'

group by 1),

vote AS

(SELECT

voter,

count(proposal_id) as votes

FROM terra.gov_vote

where

voter = 'terra1fl48vsnmsdzcv85q5d2q4z5ajdha8yu3nln0mh' or

voter = 'terra1dp0taj85ruc299rkdvzp4z5pfg6z6swaed74e6' or

voter = 'terra1mtwph2juhj0rvjz7dy92gvl6xvukaxu8rfv8ts' or

voter = 'terra1jv65s3grqf6v6jl3dp4t6c9t9rk99cd8pm7utl' or

voter = 'terra1dp0taj85ruc299rkdvzp4z5pfg6z6swaed74e6' or