gox=> select sign(amount)*power(10,floor(log(@amount))) as magnitude, count(*) as c from btc_xfers group by magnitude order by abs(magitude),magnitude ;
        magnitude        |   c
-------------------------+--------
 100000.0000000000000000 |      2
 -10000.0000000000000000 |     33
  10000.0000000000000000 |     54
  -1000.0000000000000000 |   1631
   1000.0000000000000000 |   2290
   -100.0000000000000000 |  38358
    100.0000000000000000 |  33912
    -10.0000000000000000 | 221402
     10.0000000000000000 | 161717
     -1.0000000000000000 | 346926
      1.0000000000000000 | 368390
     -0.1000000000000000 | 176313
      0.1000000000000000 | 299602
     -0.0100000000000000 | 248932
      0.0100000000000000 | 185678
     -0.0010000000000000 | 671904
      0.0010000000000000 |  42379
     -0.0001000000000000 |  74740
      0.0001000000000000 |  68714
     -0.0000100000000000 |  48526
      0.0000100000000000 | 128246
     -0.0000010000000000 |    174
      0.0000010000000000 | 145474
     -0.0000001000000000 |    145
      0.0000001000000000 |   7274
     -0.0000000100000000 |   2287
      0.0000000100000000 |   7606