SELECT

block_timestamp,

tx_id,

msg:sender AS sender,

value:addr AS address,

(value:coins[0]:amount)/pow(10,6) AS amount,

value:coins[0]:denom AS token

FROM osmosis.core.fact_tx_body_msgs, LATERAL FLATTEN (input => msg:msg:transfer:recipients)

WHERE sender = 'osmo1qrwt8r63jks74ykgq7d28fvy6msd2dpgz8zxaj'

AND address = '{{wallet_address}}'

AND block_timestamp::date = '2023-12-20'

ORDER BY amount DESC

SELECT

address,

SUM(amount) AS amount

FROM airdrop

GROUP BY 1