sum(case when from_currency = 'ibc/B3504E092456BA618CC28AC671A71FB08C6CA0FD0BE7C8A5B5A3E2DD933CC9E4'

and block_timestamp >= CURRENT_DATE - interval '24 hours'

then from_amount / pow(10,from_decimal) END) as axlusdc_sell_volume_24_hrs,

sum(case when from_currency = 'ibc/B3504E092456BA618CC28AC671A71FB08C6CA0FD0BE7C8A5B5A3E2DD933CC9E4'

and block_timestamp >= CURRENT_DATE - interval '30 days'

then from_amount / pow(10,from_decimal) END) as axlusdc_sell_volume_30_days,

sum(case when from_currency = 'ibc/B3504E092456BA618CC28AC671A71FB08C6CA0FD0BE7C8A5B5A3E2DD933CC9E4'

then from_amount / pow(10,from_decimal) END) as axlusdc_sell_volume,

sum(case when to_currency = 'ibc/B3504E092456BA618CC28AC671A71FB08C6CA0FD0BE7C8A5B5A3E2DD933CC9E4'

and block_timestamp >= CURRENT_DATE - interval '24 hours'

then to_amount / pow(10,to_decimal) END) as axlusdc_buy_volume_24_hrs,

sum(case when to_currency = 'ibc/B3504E092456BA618CC28AC671A71FB08C6CA0FD0BE7C8A5B5A3E2DD933CC9E4'

and block_timestamp >= CURRENT_DATE - interval '30 days'

then to_amount / pow(10,to_decimal) END) as axlusdc_buy_volume_30_days,

sum(case when to_currency = 'ibc/B3504E092456BA618CC28AC671A71FB08C6CA0FD0BE7C8A5B5A3E2DD933CC9E4'

then to_amount / pow(10,to_decimal) END) as axlusdc_buy_volume,

sum(case when from_currency = 'ibc/CBF67A2BCF6CAE343FDF251E510C8E18C361FC02B23430C121116E0811835DEF'

and block_timestamp >= CURRENT_DATE - interval '24 hours'

then from_amount / pow(10,from_decimal) END) as axlusdt_sell_volume_24_hrs,

sum(case when from_currency = 'ibc/CBF67A2BCF6CAE343FDF251E510C8E18C361FC02B23430C121116E0811835DEF'

and block_timestamp >= CURRENT_DATE - interval '30 days'

then from_amount / pow(10,from_decimal) END) as axlusdt_sell_volume_30_days,

sum(case when from_currency = 'ibc/CBF67A2BCF6CAE343FDF251E510C8E18C361FC02B23430C121116E0811835DEF'

then from_amount / pow(10,from_decimal) END) as axlusdt_sell_volume,

sum(case when to_currency = 'ibc/CBF67A2BCF6CAE343FDF251E510C8E18C361FC02B23430C121116E0811835DEF'

and block_timestamp >= CURRENT_DATE - interval '24 hours'

then to_amount / pow(10,to_decimal) END) as axlusdt_buy_volume_24_hrs,

sum(case when to_currency = 'ibc/CBF67A2BCF6CAE343FDF251E510C8E18C361FC02B23430C121116E0811835DEF'

and block_timestamp >= CURRENT_DATE - interval '30 days'

then to_amount / pow(10,to_decimal) END) as axlusdt_buy_volume_30_days,

sum(case when to_currency = 'ibc/CBF67A2BCF6CAE343FDF251E510C8E18C361FC02B23430C121116E0811835DEF'

then to_amount / pow(10,to_decimal) END) as axlusdt_buy_volume,

count(distinct case when from_currency = 'ibc/B3504E092456BA618CC28AC671A71FB08C6CA0FD0BE7C8A5B5A3E2DD933CC9E4'

and block_timestamp >= CURRENT_DATE - interval '24 hours'

then trader END) as axlusdc_sellers_24_hrs,