MAX(decoded_log:amount/pow(10,18)) as "Max",

avg(decoded_log:amount/pow(10,18)) as "Avg",

median(decoded_log:amount/pow(10,18)) as "Median",

min(decoded_log:amount/pow(10,18)) as "Min",

from blast.core.ez_decoded_event_logs

where decoded_log:service='0x5ff315aa82a8b2b435f866d20ecd46959999bdcd'

and contract_address='0xe1784da2b8f42c31fb729e870a4a8064703555c2'

and block_timestamp::date between '{{Start_Date}}' and '{{End_Date}}'

group by 1