with rewards as (

select

message_value:delegator_address user_address,

case when message_value:delegator_address in ('terra10008cuvtc3n3sw8yzm8vrtyh5th2cfc7r9xp0t','terra102qjqtp9rryrlu9myrn7s8rg4vu02348rpsvgn','terra107kjnz9u7cy8q3gnzn2zd2p0wgujjtkwz747zq','terra10etqj2n84hhuan87wlxshtzm96mrmc2cxd5yxp','terra10gu9g6xkngeuj528fp8jvuz0wsjmnqa83qrd3h','terra10neq69n0r2m6c8fnc5duvx93knrmu67d57v3yk','terra10q4t2888sk04pvg2pl6fsx4fj770ym0aqsy82l','terra10ttyrf534hkmup33gajrlpgps2k7ve8chtxzqh','terra10wyptw59xc52l86pg86sy0xcm3nm5wg6a3cf7l','terra12dxclvqrgt7w3s7gtwpdkxgymexv8stgqcr0yu','terra12gmawj54szkfwx0hhx4dhftpz4mc4z0yg9f3sz','terra132wegs0kf9q65t9gsm3g2y06l98l2k4treepkq','terra13e9670yuvfs06hctt9pmgjnz0yw28p0wgnhrqn','terra13kyx2dykuyzsey0junjn03ls0gygu3v8l50p0f','terra13s4gwzxv6dycfctvddfuy6r3zm7d6zklynzzj5','terra14l46jrdgdhaw4cejukx50ndp0hss95ekt2kfmw','terra14q8cazgt58y2xkd26mlukemwth0cnvfqmgz2qk','terra14w0auphr3mrejsq9zn4257pqx7uh6sndjfvcja','terra14yqy9warjkxyecda5kf5a68qlknf4ve4sh7sa6','terra155svs6sgxe55rnvs6ghprtqu0mh69keh9h4dzr','terra1570wxm7mtv0xqdfm6w6wxe8gcv75z9svlh0rpx','terra15jya6ugxp65y80y5h82k4gv90pd7acv58xp6jj','terra15s66unmdcpknuxxldd7fsr44skme966tdckq8c','terra15srwqp98mv36hf6cs9heu5pz9qa59hl8km5q2d','terra15w7zj0sppxndaw9f2xr2maxtam9sd58r4fj27q','terra163vzxz9wwy320ccwy73qe6h33yzg2yhyvv5nsf','terra164z4d0wga5lkwct2kya9c4jse9hfk3s5gc2p2y','terra169u9tupqv5l54fzaf9swyzxtzwuem688gs6xzu','terra16jpsrgl423fqg6n0e9edllew9z0gm7rhl5300u','terra16r8dcdcse6kw6qyq0670z2r3tpd9pqwkxc593t','terra174pe7qe7g867spzdfs5f4rf9fuwmm42zf4hykf','terra17ke7p99w3c6um2pnljwfkwl7p0np0glcfxadtf','terra17m8tkde0mav43ckeehp537rsz4usqx5jayhf08','terra18klf8ya6lrugyunr3pymq9755s0r3m3g3qd0yk','terra18mkcha20h5psry3nn9jlsdkz66cm0u9c7p5dmv','terra18putj9puq4jqcgmk6hje44fyh4hf9nsuwxj9vy','terra18vnrzlzm2c4xfsx382pj2xndqtt00rvhu24sqe','terra18wcdhpzpteharlkks5n6k7ent0mjyftvcpm6ee','terra18z4k5g276cjg38lx3nmx3sp6q8p2j4hch7p3tl','terra19k7ltqx6uedgtgsrq43xrjd7ywe5ypyl9p93sx','terra19kwy5k3f9a077pacelnkkrrxmyx3tfwkx0q5nu','terra19scdgmvhj5rl7f66n06z5pescf0gmeysw6pjrz','terra1al546tmrj0wmwfctcqkch47h57h23mch7d8xqa','terra1alsk6a4mhvjel524g28ze5jepjsjrjxcplyw5h','terra1amr42cacpt6jjspctxjalehsulx30nmvpp4uhx','terra1az3dsad74pwhylrrexnn5qylzj783uyww2s7xz','terra1chq5ps8yya004gsw4xz62pd4psr5ha

sum(case when message_value:"@type" = '/cosmos.distribution.v1beta1.MsgWithdrawDelegatorReward' then cast(attributes:coin_received:amount as number) else 0 end) / 1000000 luna_rewards_received,

sum(case when message_value:"@type" = '/cosmos.staking.v1beta1.MsgUndelegate' then cast(message_value:amount:amount as number) else 0 end) / 1000000 total_undelegated,

sum(case when message_value:"@type" = '/cosmos.staking.v1beta1.MsgDelegate' then cast(message_value:amount:amount as number) else 0 end) / 1000000 total_delegated

from terra.core.ez_messages

where message_value:"@type" in (

'/cosmos.distribution.v1beta1.MsgWithdrawDelegatorReward',

'/cosmos.staking.v1beta1.MsgUndelegate',

and block_timestamp < '2023-04-01'

and tx_succeeded = true

group by 1,2

having sum(case when message_value:"@type" = '/cosmos.distribution.v1beta1.MsgWithdrawDelegatorReward' then cast(attributes:coin_received:amount as number) else 0 end) > 0

),

exchange_flows as (

case when message_value:to_address in ('terra10008cuvtc3n3sw8yzm8vrtyh5th2cfc7r9xp0t','terra102qjqtp9rryrlu9myrn7s8rg4vu02348rpsvgn','terra107kjnz9u7cy8q3gnzn2zd2p0wgujjtkwz747zq','terra10etqj2n84hhuan87wlxshtzm96mrmc2cxd5yxp','terra10gu9g6xkngeuj528fp8jvuz0wsjmnqa83qrd3h','terra10neq69n0r2m6c8fnc5duvx93knrmu67d57v3yk','terra10q4t2888sk04pvg2pl6fsx4fj770ym0aqsy82l','terra10ttyrf534hkmup33gajrlpgps2k7ve8chtxzqh','terra10wyptw59xc52l86pg86sy0xcm3nm5wg6a3cf7l','terra12dxclvqrgt7w3s7gtwpdkxgymexv8stgqcr0yu','terra12gmawj54szkfwx0hhx4dhftpz4mc4z0yg9f3sz','terra132wegs0kf9q65t9gsm3g2y06l98l2k4treepkq','terra13e9670yuvfs06hctt9pmgjnz0yw28p0wgnhrqn','terra13kyx2dykuyzsey0junjn03ls0gygu3v8l50p0f','terra13s4gwzxv6dycfctvddfuy6r3zm7d6zklynzzj5','terra14l46jrdgdhaw4cejukx50ndp0hss95ekt2kfmw','terra14q8cazgt58y2xkd26mlukemwth0cnvfqmgz2qk','terra14w0auphr3mrejsq9zn4257pqx7uh6sndjfvcja','terra14yqy9warjkxyecda5kf5a68qlknf4ve4sh7sa6','terra155svs6sgxe55rnvs6ghprtqu0mh69keh9h4dzr','terra1570wxm7mtv0xqdfm6w6wxe8gcv75z9svlh0rpx','terra15jya6ugxp65y80y5h82k4gv90pd7acv58xp6jj','terra15s66unmdcpknuxxldd7fsr44skme966tdckq8c','terra15srwqp98mv36hf6cs9heu5pz9qa59hl8km5q2d','terra15w7zj0sppxndaw9f2xr2maxtam9sd58r4fj27q','terra163vzxz9wwy320ccwy73qe6h33yzg2yhyvv5nsf','terra164z4d0wga5lkwct2kya9c4jse9hfk3s5gc2p2y','terra169u9tupqv5l54fzaf9swyzxtzwuem688gs6xzu','terra16jpsrgl423fqg6n0e9edllew9z0gm7rhl5300u','terra16r8dcdcse6kw6qyq0670z2r3tpd9pqwkxc593t','terra174pe7qe7g867spzdfs5f4rf9fuwmm42zf4hykf','terra17ke7p99w3c6um2pnljwfkwl7p0np0glcfxadtf','terra17m8tkde0mav43ckeehp537rsz4usqx5jayhf08','terra18klf8ya6lrugyunr3pymq9755s0r3m3g3qd0yk','terra18mkcha20h5psry3nn9jlsdkz66cm0u9c7p5dmv','terra18putj9puq4jqcgmk6hje44fyh4hf9nsuwxj9vy','terra18vnrzlzm2c4xfsx382pj2xndqtt00rvhu24sqe','terra18wcdhpzpteharlkks5n6k7ent0mjyftvcpm6ee','terra18z4k5g276cjg38lx3nmx3sp6q8p2j4hch7p3tl','terra19k7ltqx6uedgtgsrq43xrjd7ywe5ypyl9p93sx','terra19kwy5k3f9a077pacelnkkrrxmyx3tfwkx0q5nu','terra19scdgmvhj5rl7f66n06z5pescf0gmeysw6pjrz','terra1al546tmrj0wmwfctcqkch47h57h23mch7d8xqa','terra1alsk6a4mhvjel524g28ze5jepjsjrjxcplyw5h','terra1amr42cacpt6jjspctxjalehsulx30nmvpp4uhx','terra1az3dsad74pwhylrrexnn5qylzj783uyww2s7xz','terra1chq5ps8yya004gsw4xz62pd4psr5hafe7kdt6

sum(case when message_value:to_address in ('terra10008cuvtc3n3sw8yzm8vrtyh5th2cfc7r9xp0t','terra102qjqtp9rryrlu9myrn7s8rg4vu02348rpsvgn','terra107kjnz9u7cy8q3gnzn2zd2p0wgujjtkwz747zq','terra10etqj2n84hhuan87wlxshtzm96mrmc2cxd5yxp','terra10gu9g6xkngeuj528fp8jvuz0wsjmnqa83qrd3h','terra10neq69n0r2m6c8fnc5duvx93knrmu67d57v3yk','terra10q4t2888sk04pvg2pl6fsx4fj770ym0aqsy82l','terra10ttyrf534hkmup33gajrlpgps2k7ve8chtxzqh','terra10wyptw59xc52l86pg86sy0xcm3nm5wg6a3cf7l','terra12dxclvqrgt7w3s7gtwpdkxgymexv8stgqcr0yu','terra12gmawj54szkfwx0hhx4dhftpz4mc4z0yg9f3sz','terra132wegs0kf9q65t9gsm3g2y06l98l2k4treepkq','terra13e9670yuvfs06hctt9pmgjnz0yw28p0wgnhrqn','terra13kyx2dykuyzsey0junjn03ls0gygu3v8l50p0f','terra13s4gwzxv6dycfctvddfuy6r3zm7d6zklynzzj5','terra14l46jrdgdhaw4cejukx50ndp0hss95ekt2kfmw','terra14q8cazgt58y2xkd26mlukemwth0cnvfqmgz2qk','terra14w0auphr3mrejsq9zn4257pqx7uh6sndjfvcja','terra14yqy9warjkxyecda5kf5a68qlknf4ve4sh7sa6','terra155svs6sgxe55rnvs6ghprtqu0mh69keh9h4dzr','terra1570wxm7mtv0xqdfm6w6wxe8gcv75z9svlh0rpx','terra15jya6ugxp65y80y5h82k4gv90pd7acv58xp6jj','terra15s66unmdcpknuxxldd7fsr44skme966tdckq8c','terra15srwqp98mv36hf6cs9heu5pz9qa59hl8km5q2d','terra15w7zj0sppxndaw9f2xr2maxtam9sd58r4fj27q','terra163vzxz9wwy320ccwy73qe6h33yzg2yhyvv5nsf','terra164z4d0wga5lkwct2kya9c4jse9hfk3s5gc2p2y','terra169u9tupqv5l54fzaf9swyzxtzwuem688gs6xzu','terra16jpsrgl423fqg6n0e9edllew9z0gm7rhl5300u','terra16r8dcdcse6kw6qyq0670z2r3tpd9pqwkxc593t','terra174pe7qe7g867spzdfs5f4rf9fuwmm42zf4hykf','terra17ke7p99w3c6um2pnljwfkwl7p0np0glcfxadtf','terra17m8tkde0mav43ckeehp537rsz4usqx5jayhf08','terra18klf8ya6lrugyunr3pymq9755s0r3m3g3qd0yk','terra18mkcha20h5psry3nn9jlsdkz66cm0u9c7p5dmv','terra18putj9puq4jqcgmk6hje44fyh4hf9nsuwxj9vy','terra18vnrzlzm2c4xfsx382pj2xndqtt00rvhu24sqe','terra18wcdhpzpteharlkks5n6k7ent0mjyftvcpm6ee','terra18z4k5g276cjg38lx3nmx3sp6q8p2j4hch7p3tl','terra19k7ltqx6uedgtgsrq43xrjd7ywe5ypyl9p93sx','terra19kwy5k3f9a077pacelnkkrrxmyx3tfwkx0q5nu','terra19scdgmvhj5rl7f66n06z5pescf0gmeysw6pjrz','terra1al546tmrj0wmwfctcqkch47h57h23mch7d8xqa','terra1alsk6a4mhvjel524g28ze5jepjsjrjxcplyw5h','terra1amr42cacpt6jjspctxjalehsulx30nmvpp4uhx','terra1az3dsad74pwhylrrexnn5qylzj783uyww2s7xz','terra1chq5ps8yya004gsw4xz62pd4psr5hafe7

sum(case when message_value:from_address in ('terra10008cuvtc3n3sw8yzm8vrtyh5th2cfc7r9xp0t','terra102qjqtp9rryrlu9myrn7s8rg4vu02348rpsvgn','terra107kjnz9u7cy8q3gnzn2zd2p0wgujjtkwz747zq','terra10etqj2n84hhuan87wlxshtzm96mrmc2cxd5yxp','terra10gu9g6xkngeuj528fp8jvuz0wsjmnqa83qrd3h','terra10neq69n0r2m6c8fnc5duvx93knrmu67d57v3yk','terra10q4t2888sk04pvg2pl6fsx4fj770ym0aqsy82l','terra10ttyrf534hkmup33gajrlpgps2k7ve8chtxzqh','terra10wyptw59xc52l86pg86sy0xcm3nm5wg6a3cf7l','terra12dxclvqrgt7w3s7gtwpdkxgymexv8stgqcr0yu','terra12gmawj54szkfwx0hhx4dhftpz4mc4z0yg9f3sz','terra132wegs0kf9q65t9gsm3g2y06l98l2k4treepkq','terra13e9670yuvfs06hctt9pmgjnz0yw28p0wgnhrqn','terra13kyx2dykuyzsey0junjn03ls0gygu3v8l50p0f','terra13s4gwzxv6dycfctvddfuy6r3zm7d6zklynzzj5','terra14l46jrdgdhaw4cejukx50ndp0hss95ekt2kfmw','terra14q8cazgt58y2xkd26mlukemwth0cnvfqmgz2qk','terra14w0auphr3mrejsq9zn4257pqx7uh6sndjfvcja','terra14yqy9warjkxyecda5kf5a68qlknf4ve4sh7sa6','terra155svs6sgxe55rnvs6ghprtqu0mh69keh9h4dzr','terra1570wxm7mtv0xqdfm6w6wxe8gcv75z9svlh0rpx','terra15jya6ugxp65y80y5h82k4gv90pd7acv58xp6jj','terra15s66unmdcpknuxxldd7fsr44skme966tdckq8c','terra15srwqp98mv36hf6cs9heu5pz9qa59hl8km5q2d','terra15w7zj0sppxndaw9f2xr2maxtam9sd58r4fj27q','terra163vzxz9wwy320ccwy73qe6h33yzg2yhyvv5nsf','terra164z4d0wga5lkwct2kya9c4jse9hfk3s5gc2p2y','terra169u9tupqv5l54fzaf9swyzxtzwuem688gs6xzu','terra16jpsrgl423fqg6n0e9edllew9z0gm7rhl5300u','terra16r8dcdcse6kw6qyq0670z2r3tpd9pqwkxc593t','terra174pe7qe7g867spzdfs5f4rf9fuwmm42zf4hykf','terra17ke7p99w3c6um2pnljwfkwl7p0np0glcfxadtf','terra17m8tkde0mav43ckeehp537rsz4usqx5jayhf08','terra18klf8ya6lrugyunr3pymq9755s0r3m3g3qd0yk','terra18mkcha20h5psry3nn9jlsdkz66cm0u9c7p5dmv','terra18putj9puq4jqcgmk6hje44fyh4hf9nsuwxj9vy','terra18vnrzlzm2c4xfsx382pj2xndqtt00rvhu24sqe','terra18wcdhpzpteharlkks5n6k7ent0mjyftvcpm6ee','terra18z4k5g276cjg38lx3nmx3sp6q8p2j4hch7p3tl','terra19k7ltqx6uedgtgsrq43xrjd7ywe5ypyl9p93sx','terra19kwy5k3f9a077pacelnkkrrxmyx3tfwkx0q5nu','terra19scdgmvhj5rl7f66n06z5pescf0gmeysw6pjrz','terra1al546tmrj0wmwfctcqkch47h57h23mch7d8xqa','terra1alsk6a4mhvjel524g28ze5jepjsjrjxcplyw5h','terra1amr42cacpt6jjspctxjalehsulx30nmvpp4uhx','terra1az3dsad74pwhylrrexnn5qylzj783uyww2s7xz','terra1chq5ps8yya004gsw4xz62pd4psr5haf

from terra.core.ez_transfers

where currency = 'uluna'

and message_type like '%Send%'

and (

message_value:to_address in ('terra10008cuvtc3n3sw8yzm8vrtyh5th2cfc7r9xp0t','terra102qjqtp9rryrlu9myrn7s8rg4vu02348rpsvgn','terra107kjnz9u7cy8q3gnzn2zd2p0wgujjtkwz747zq','terra10etqj2n84hhuan87wlxshtzm96mrmc2cxd5yxp','terra10gu9g6xkngeuj528fp8jvuz0wsjmnqa83qrd3h','terra10neq69n0r2m6c8fnc5duvx93knrmu67d57v3yk','terra10q4t2888sk04pvg2pl6fsx4fj770ym0aqsy82l','terra10ttyrf534hkmup33gajrlpgps2k7ve8chtxzqh','terra10wyptw59xc52l86pg86sy0xcm3nm5wg6a3cf7l','terra12dxclvqrgt7w3s7gtwpdkxgymexv8stgqcr0yu','terra12gmawj54szkfwx0hhx4dhftpz4mc4z0yg9f3sz','terra132wegs0kf9q65t9gsm3g2y06l98l2k4treepkq','terra13e9670yuvfs06hctt9pmgjnz0yw28p0wgnhrqn','terra13kyx2dykuyzsey0junjn03ls0gygu3v8l50p0f','terra13s4gwzxv6dycfctvddfuy6r3zm7d6zklynzzj5','terra14l46jrdgdhaw4cejukx50ndp0hss95ekt2kfmw','terra14q8cazgt58y2xkd26mlukemwth0cnvfqmgz2qk','terra14w0auphr3mrejsq9zn4257pqx7uh6sndjfvcja','terra14yqy9warjkxyecda5kf5a68qlknf4ve4sh7sa6','terra155svs6sgxe55rnvs6ghprtqu0mh69keh9h4dzr','terra1570wxm7mtv0xqdfm6w6wxe8gcv75z9svlh0rpx','terra15jya6ugxp65y80y5h82k4gv90pd7acv58xp6jj','terra15s66unmdcpknuxxldd7fsr44skme966tdckq8c','terra15srwqp98mv36hf6cs9heu5pz9qa59hl8km5q2d','terra15w7zj0sppxndaw9f2xr2maxtam9sd58r4fj27q','terra163vzxz9wwy320ccwy73qe6h33yzg2yhyvv5nsf','terra164z4d0wga5lkwct2kya9c4jse9hfk3s5gc2p2y','terra169u9tupqv5l54fzaf9swyzxtzwuem688gs6xzu','terra16jpsrgl423fqg6n0e9edllew9z0gm7rhl5300u','terra16r8dcdcse6kw6qyq0670z2r3tpd9pqwkxc593t','terra174pe7qe7g867spzdfs5f4rf9fuwmm42zf4hykf','terra17ke7p99w3c6um2pnljwfkwl7p0np0glcfxadtf','terra17m8tkde0mav43ckeehp537rsz4usqx5jayhf08','terra18klf8ya6lrugyunr3pymq9755s0r3m3g3qd0yk','terra18mkcha20h5psry3nn9jlsdkz66cm0u9c7p5dmv','terra18putj9puq4jqcgmk6hje44fyh4hf9nsuwxj9vy','terra18vnrzlzm2c4xfsx382pj2xndqtt00rvhu24sqe','terra18wcdhpzpteharlkks5n6k7ent0mjyftvcpm6ee','terra18z4k5g276cjg38lx3nmx3sp6q8p2j4hch7p3tl','terra19k7ltqx6uedgtgsrq43xrjd7ywe5ypyl9p93sx','terra19kwy5k3f9a077pacelnkkrrxmyx3tfwkx0q5nu','terra19scdgmvhj5rl7f66n06z5pescf0gmeysw6pjrz','terra1al546tmrj0wmwfctcqkch47h57h23mch7d8xqa','terra1alsk6a4mhvjel524g28ze5jepjsjrjxcplyw5h','terra1amr42cacpt6jjspctxjalehsulx30nmvpp4uhx','terra1az3dsad74pwhylrrexnn5qylzj783uyww2s7xz','terra1chq5ps8yya004gsw4xz62pd4psr5hafe7kdt6d','terra1

or message_value:from_address in ('terra10008cuvtc3n3sw8yzm8vrtyh5th2cfc7r9xp0t','terra102qjqtp9rryrlu9myrn7s8rg4vu02348rpsvgn','terra107kjnz9u7cy8q3gnzn2zd2p0wgujjtkwz747zq','terra10etqj2n84hhuan87wlxshtzm96mrmc2cxd5yxp','terra10gu9g6xkngeuj528fp8jvuz0wsjmnqa83qrd3h','terra10neq69n0r2m6c8fnc5duvx93knrmu67d57v3yk','terra10q4t2888sk04pvg2pl6fsx4fj770ym0aqsy82l','terra10ttyrf534hkmup33gajrlpgps2k7ve8chtxzqh','terra10wyptw59xc52l86pg86sy0xcm3nm5wg6a3cf7l','terra12dxclvqrgt7w3s7gtwpdkxgymexv8stgqcr0yu','terra12gmawj54szkfwx0hhx4dhftpz4mc4z0yg9f3sz','terra132wegs0kf9q65t9gsm3g2y06l98l2k4treepkq','terra13e9670yuvfs06hctt9pmgjnz0yw28p0wgnhrqn','terra13kyx2dykuyzsey0junjn03ls0gygu3v8l50p0f','terra13s4gwzxv6dycfctvddfuy6r3zm7d6zklynzzj5','terra14l46jrdgdhaw4cejukx50ndp0hss95ekt2kfmw','terra14q8cazgt58y2xkd26mlukemwth0cnvfqmgz2qk','terra14w0auphr3mrejsq9zn4257pqx7uh6sndjfvcja','terra14yqy9warjkxyecda5kf5a68qlknf4ve4sh7sa6','terra155svs6sgxe55rnvs6ghprtqu0mh69keh9h4dzr','terra1570wxm7mtv0xqdfm6w6wxe8gcv75z9svlh0rpx','terra15jya6ugxp65y80y5h82k4gv90pd7acv58xp6jj','terra15s66unmdcpknuxxldd7fsr44skme966tdckq8c','terra15srwqp98mv36hf6cs9heu5pz9qa59hl8km5q2d','terra15w7zj0sppxndaw9f2xr2maxtam9sd58r4fj27q','terra163vzxz9wwy320ccwy73qe6h33yzg2yhyvv5nsf','terra164z4d0wga5lkwct2kya9c4jse9hfk3s5gc2p2y','terra169u9tupqv5l54fzaf9swyzxtzwuem688gs6xzu','terra16jpsrgl423fqg6n0e9edllew9z0gm7rhl5300u','terra16r8dcdcse6kw6qyq0670z2r3tpd9pqwkxc593t','terra174pe7qe7g867spzdfs5f4rf9fuwmm42zf4hykf','terra17ke7p99w3c6um2pnljwfkwl7p0np0glcfxadtf','terra17m8tkde0mav43ckeehp537rsz4usqx5jayhf08','terra18klf8ya6lrugyunr3pymq9755s0r3m3g3qd0yk','terra18mkcha20h5psry3nn9jlsdkz66cm0u9c7p5dmv','terra18putj9puq4jqcgmk6hje44fyh4hf9nsuwxj9vy','terra18vnrzlzm2c4xfsx382pj2xndqtt00rvhu24sqe','terra18wcdhpzpteharlkks5n6k7ent0mjyftvcpm6ee','terra18z4k5g276cjg38lx3nmx3sp6q8p2j4hch7p3tl','terra19k7ltqx6uedgtgsrq43xrjd7ywe5ypyl9p93sx','terra19kwy5k3f9a077pacelnkkrrxmyx3tfwkx0q5nu','terra19scdgmvhj5rl7f66n06z5pescf0gmeysw6pjrz','terra1al546tmrj0wmwfctcqkch47h57h23mch7d8xqa','terra1alsk6a4mhvjel524g28ze5jepjsjrjxcplyw5h','terra1amr42cacpt6jjspctxjalehsulx30nmvpp4uhx','terra1az3dsad74pwhylrrexnn5qylzj783uyww2s7xz','terra1chq5ps8yya004gsw4xz62pd4psr5hafe7kdt6d','t

and block_timestamp < '2023-04-01'

group by 1),

dex_swaps as (

select trader user_address,

sum(case when from_currency = 'uluna' then cast(from_amount as number) else 0 end) / 1000000 luna_sold,