*/

select

to_char(sum(amount), 'FM999,999,999,999') as sum_amount,

to_char(count(amount), 'FM999,999,999,999') as count_amount,

to_char(sum(amount) / count(amount), 'FM999,999,999,999.99') as average_amount,

to_char(median(amount), 'FM999,999,999,999.99') as median_amount,

to_char(stddev(amount), 'FM999,999,999,999.99') as stddev_amount,

to_char(variance(amount), 'FM999,999,999,999.99') as variance_amount,

to_char(max(amount), 'FM999,999,999,999') as max_amount,

to_char(min(amount), 'FM999,999,999,999') as min_amount,

to_char(percentile_cont(0.25) within group (order by amount), 'FM999,999,999,999.99') as q1_amount,

to_char(percentile_cont(0.75) within group (order by amount), 'FM999,999,999,999.99') as q3_amount

from

solana.core.fact_transfers

where

tx_from = '3L3ao6mnhXg7u2arEv5ePuVDcYpMt82RrWSxhCtFxNaF'

and tx_to != 'FBNkXYZwMdzHeZgHSULR5u1vuZt6Hr4wuDvJztSV5QPc';