gistfile1.txt

  id    | affiliate_id |  before  |  after   |  delta
---------+--------------+----------+----------+---------
 5075833 |         4224 | 31802.48 | 35883.37 | 4080.89
 5631489 |         4224 |  -489.70 |   582.17 | 1071.87
 5156240 |        18705 |  6377.83 |  7138.63 |  760.80
 5078845 |        42469 |  6284.35 |  6890.63 |  606.28
 5057899 |         4224 |  7537.16 |  8083.51 |  546.35
 5102293 |        13429 |  3850.33 |  4382.66 |  532.33
 5075199 |         5107 |  5453.62 |  5967.49 |  513.87
 5096046 |        18705 |  3434.89 |  3909.79 |  474.90
 5152053 |        18705 |  2788.76 |  3242.45 |  453.69
 5631751 |         2433 |  2216.08 |  2634.56 |  418.48
 5166134 |         3103 |  2177.25 |  2595.46 |  418.21
 5177548 |        27238 |  2103.19 |  2507.17 |  403.98
 5062852 |        18705 |  6371.20 |  6720.26 |  349.06
 5069865 |         5983 |  5370.06 |  5711.83 |  341.77
 5625077 |        42469 |  1456.94 |  1797.25 |  340.31
 5153886 |         9270 |  2072.79 |  2402.70 |  329.91
 5146246 |         4224 |  1956.77 |  2278.55 |  321.78
 5152133 |        18705 |  1926.66 |  2240.11 |  313.45
 5067646 |        42469 |  4716.97 |  5017.17 |  300.20
 5071668 |         4224 |  2298.39 |  2593.32 |  294.93
 5067580 |        18705 |  3240.35 |  3534.92 |  294.57
 5631783 |         4224 |  1544.89 |  1836.63 |  291.74
 5146287 |           79 |  1700.95 |  1980.67 |  279.72
 5631633 |         4224 |  1472.41 |  1750.45 |  278.04
 5631805 |         4224 |  1461.89 |  1737.95 |  276.06
 5171182 |        18705 |  1427.81 |  1702.07 |  274.26
 5160109 |        18705 |  1324.90 |  1591.72 |  266.82
 5158992 |        18705 |  1414.82 |  1681.22 |  266.40
 5082508 |         5983 |  1979.98 |  2234.05 |  254.07
 5079595 |        39152 |  1941.36 |  2190.47 |  249.11
 5100194 |        37117 |  1736.42 |  1976.49 |  240.07
 5091358 |         4224 |  1696.13 |  1930.63 |  234.50
 5091581 |         4224 |  1696.13 |  1930.63 |  234.50
 5624392 |        21534 |  1233.92 |  1466.93 |  233.01
 5631469 |         3549 |  1204.60 |  1432.07 |  227.47
 5116605 |        37117 |  1614.37 |  1840.88 |  226.51
 5147779 |         4224 |  1372.96 |  1596.32 |  223.36
 5154542 |        29766 |  1392.11 |  1613.68 |  221.57
 5173107 |        20277 |  1148.50 |  1369.11 |  220.61
 5070906 |        18705 |  2354.20 |  2570.46 |  216.26
 5148249 |         6876 |  1293.63 |  1504.08 |  210.45
 5147716 |        20663 |  1292.08 |  1502.29 |  210.21
 5154699 |        14728 |  2444.28 |  2654.15 |  209.87
 5172161 |        18705 |  1089.12 |  1298.33 |  209.21
 5177864 |         7697 |  1474.37 |  1680.06 |  205.69
 5053760 |         4224 |  2171.32 |  2368.71 |  197.39
 5171204 |         7697 |  1386.62 |  1580.08 |  193.46
 5631664 |            6 |  1018.12 |  1210.38 |  192.26
 5084066 |         3702 |  1483.16 |  1673.48 |  190.32
 5631523 |        39152 |   995.99 |  1184.07 |  188.08
 5631492 |        30638 |   995.99 |  1184.07 |  188.08
 5631739 |         5983 |   995.99 |  1184.07 |  188.08
 5631750 |         5983 |   995.99 |  1184.07 |  188.08
 5631618 |         3103 |   995.99 |  1184.07 |  188.08
 5631650 |        43359 |   995.99 |  1184.07 |  188.08
 5631561 |        16377 |   995.99 |  1184.07 |  188.08
 5631501 |         9270 |   995.99 |  1184.07 |  188.08
 5631717 |        40222 |   995.99 |  1184.07 |  188.08
 5631559 |         7697 |   995.99 |  1184.07 |  188.08
 5631503 |         5983 |   995.99 |  1184.07 |  188.08
 5631695 |        18705 |   995.99 |  1184.07 |  188.08
 5631486 |         5983 |   995.99 |  1184.07 |  188.08
 5631617 |        39152 |   995.99 |  1184.07 |  188.08
 5631528 |        18705 |   995.99 |  1184.07 |  188.08
 5631594 |         5983 |   995.99 |  1184.07 |  188.08
 5631802 |         5983 |   995.99 |  1184.07 |  188.08
 5631524 |         5983 |   995.99 |  1184.07 |  188.08
 5631723 |        18705 |   995.99 |  1184.07 |  188.08
 5149572 |        32853 |  1154.65 |  1342.50 |  187.85
 5107307 |         8699 |  1253.35 |  1438.92 |  185.57
 5171714 |         3549 |   938.15 |  1118.36 |  180.21
 5631721 |         4224 |   945.64 |  1124.21 |  178.57
 5090161 |        39152 |  1282.31 |  1459.60 |  177.29
 5631791 |         4224 |   924.06 |  1098.55 |  174.49
 5076020 |        18705 |  1798.61 |  1972.14 |  173.53
 5160241 |        18705 |   860.96 |  1034.34 |  173.38
 5151769 |         5107 |  1064.69 |  1237.90 |  173.21
 5153310 |         4224 |  1083.94 |  1256.46 |  172.52
 5152817 |        18705 |  1083.11 |  1255.50 |  172.39
 5069531 |         5983 |  2674.21 |  2844.40 |  170.19
 5088254 |         4260 |  1229.32 |  1399.28 |  169.96
 5156727 |        18705 |   897.23 |  1066.17 |  168.94
 5063323 |        18705 |  2484.87 |  2653.30 |  168.43
 5077429 |        18705 |  1310.59 |  1478.76 |  168.17
 5153366 |        18705 |  1408.15 |  1576.13 |  167.98
 5152479 |         4224 |  1018.07 |  1183.70 |  165.63
 5136635 |        28299 |   998.16 |  1162.31 |  164.15
 5082084 |         9270 |  1303.82 |  1463.79 |  159.97
 5124059 |        18705 |  1070.84 |  1228.52 |  157.68
 5631668 |         4224 |   825.01 |   980.81 |  155.80
 5056559 |        35295 |  2113.50 |  2266.70 |  153.20
 5055477 |         5983 |  1776.95 |  1929.53 |  152.58
 5215111 |        18705 |   744.58 |   895.00 |  150.42
 5215110 |        18705 |   744.58 |   895.00 |  150.42
 5215109 |        30259 |   744.58 |   895.00 |  150.42
 5215108 |        18705 |   744.58 |   895.00 |  150.42
 5172250 |        18705 |   775.91 |   924.94 |  149.03
 5166071 |        18705 |   771.14 |   919.26 |  148.12
 5144903 |        15047 |   883.93 |  1029.29 |  145.36
 5156696 |        39152 |   768.29 |   912.96 |  144.67