Created
January 5, 2017 08:08
-
-
Save weex/21ec2d613db4ffc612743d61d8604fe2 to your computer and use it in GitHub Desktop.
Fee flipping to -1.0 on restart of streamconfirmed
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
sqlite> select * from transactions; | |
1|9d82746075d3e0ce74c071799629824e8116e30bc2241636b8ae07cef0fe492c|1|2|226|10.9513274336283|2017-01-05 07:52:07.863906|2017-01-05 07:53:08.151285|60.287379|1063712|00000000f391e5c9bfe0b3d9b5fa0b0045d1c48e74ed215c06dee763332e25ce | |
2|06aaffe3c90d3181022328a589048e325458a12b970579805969d36891c97021|5|5|918|10.1960784313725|2017-01-05 07:52:37.948572|2017-01-05 07:53:08.202849|30.254277|1063712|00000000f391e5c9bfe0b3d9b5fa0b0045d1c48e74ed215c06dee763332e25ce | |
3|719b2a6a8e3ca2d8040614d9b5bcc9865baa979393b919423554332be6ee85b1|||223|-1.0|2017-01-05 07:53:08.034532|||| | |
4|6ecd2b10becd62f81cd1bd3e6554d0a8100ba7beadfc7fdd795803328b49ef55|||226|-1.0|2017-01-05 07:54:08.332436|||| | |
5|6ac25401ef82b4e553b28c61a80aacfbd937a4f7d203c91060b97ee7797e0b9b|||192|-1.0|2017-01-05 07:54:08.376398|||| | |
6|54a3d4f832992262dcb157a393b9b11b9491247f13f930f2234fd785dc31c23d|||600|-1.0|2017-01-05 07:54:08.414363|||| | |
7|d843470b9506ea5cfa13de4c37d5d6558cfade9b7372935717326e6908705e3b|||242|-1.0|2017-01-05 07:54:08.449638|||| | |
8|9d0bd8ec563b0b4e77c1da0f0393faffc4913b49115fa00692a2d16e8631d6e7|||600|-1.0|2017-01-05 07:56:08.676422|||| | |
9|10d88d57cf0b7c8f5db98b714eb6281d24488da5aa85de106ec43c546b7fb5c0|||333|-1.0|2017-01-05 07:56:08.718381|||| | |
10|0a8a9a9d7748af399ae39a22bc9af50759c82504f1ca3bf3e7b4e75dae488c91|||225|-1.0|2017-01-05 07:57:08.837478|||| | |
11|d95d0333f62c0729a0c94fbd9c1813087b3815046b9fec477cc90b1127b98d85|||332|-1.0|2017-01-05 07:57:38.932960|||| | |
12|00733f5ff318527b5fe97b250f0615079b171934c8b035c8ccb1090b668ad72b|||452|-1.0|2017-01-05 07:58:09.047380|||| | |
13|1c5fd0c7a462aff834546394be0490008803499e43382fb744180da895794aad|||242|-1.0|2017-01-05 07:59:09.196555|||| | |
14|1f8eb655610470e58af9fee103f5d6a52e09ce4818bad858445cb8a9499e88b8|||225|-1.0|2017-01-05 08:00:39.421728|||| | |
15|535ca545c8e96caead7ffece68102285464352c24fc5be5105d6fa3be6ea6ba5|||224|-1.0|2017-01-05 08:01:09.536383|||| | |
16|123d60b1f1ae9125a73065f4658fa3d3e6e8673a874100c690ddf5e986c9ac1f|||225|-1.0|2017-01-05 08:01:09.592830|||| | |
17|4cdc85d3e24988b81ddc8a874092403c812df457cf342c31223fb9db1f0d7514|||452|-1.0|2017-01-05 08:01:39.699987|||| | |
18|294b19ffc3ac66851f768f4cab2859b97dbe503fa3f7309969e271f36a9fac62|||372|10.2150537634409|2017-01-05 08:03:18.733875|||| | |
19|69ed35d4551d242bbb3092468ca896727d8c05b623d6922f7cc78763577950a4|||243|41.1522633744856|2017-01-05 08:03:48.933998|||| | |
20|2e0623e19c14a05183bbc5108c8b9b1a0737ee78e920c1fdd3d835a46a4a68dd|||370|10.2702702702703|2017-01-05 08:04:19.123417|||| | |
21|ca013e16c9132d6e8ceaca29749eaaf105cff474b3375d6a4c6b399ad4318cc8|||235|42.5531914893617|2017-01-05 08:04:59.369394|||| | |
22|0bf201a45008c9fe931721a6a1b97b29f1d0d631b363db35667decd722cc490d|||223|10.1838565022422|2017-01-05 08:06:19.873422|||| | |
23|08fd636fa7b45040880b66f2063c67f4f50e0ecab6f7ba479273880666ee7894|||451|22.1729490022173|2017-01-05 08:06:19.947597|||| | |
24|7ec927c8f23fa6dadf9970ab38e160d75737463adf8a34018569c85429d7b7ac|||332|60.2409638554217|2017-01-05 08:06:40.091883|||| | |
sqlite> select * from transactions; | |
1|9d82746075d3e0ce74c071799629824e8116e30bc2241636b8ae07cef0fe492c|1|2|226|10.9513274336283|2017-01-05 07:52:07.863906|2017-01-05 07:53:08.151285|60.287379|1063712|00000000f391e5c9bfe0b3d9b5fa0b0045d1c48e74ed215c06dee763332e25ce | |
2|06aaffe3c90d3181022328a589048e325458a12b970579805969d36891c97021|5|5|918|10.1960784313725|2017-01-05 07:52:37.948572|2017-01-05 07:53:08.202849|30.254277|1063712|00000000f391e5c9bfe0b3d9b5fa0b0045d1c48e74ed215c06dee763332e25ce | |
3|719b2a6a8e3ca2d8040614d9b5bcc9865baa979393b919423554332be6ee85b1|||223|-1.0|2017-01-05 07:53:08.034532|||| | |
4|6ecd2b10becd62f81cd1bd3e6554d0a8100ba7beadfc7fdd795803328b49ef55|||226|-1.0|2017-01-05 07:54:08.332436|||| | |
5|6ac25401ef82b4e553b28c61a80aacfbd937a4f7d203c91060b97ee7797e0b9b|||192|-1.0|2017-01-05 07:54:08.376398|||| | |
6|54a3d4f832992262dcb157a393b9b11b9491247f13f930f2234fd785dc31c23d|||600|-1.0|2017-01-05 07:54:08.414363|||| | |
7|d843470b9506ea5cfa13de4c37d5d6558cfade9b7372935717326e6908705e3b|||242|-1.0|2017-01-05 07:54:08.449638|||| | |
8|9d0bd8ec563b0b4e77c1da0f0393faffc4913b49115fa00692a2d16e8631d6e7|||600|-1.0|2017-01-05 07:56:08.676422|||| | |
9|10d88d57cf0b7c8f5db98b714eb6281d24488da5aa85de106ec43c546b7fb5c0|||333|-1.0|2017-01-05 07:56:08.718381|||| | |
10|0a8a9a9d7748af399ae39a22bc9af50759c82504f1ca3bf3e7b4e75dae488c91|||225|-1.0|2017-01-05 07:57:08.837478|||| | |
11|d95d0333f62c0729a0c94fbd9c1813087b3815046b9fec477cc90b1127b98d85|||332|-1.0|2017-01-05 07:57:38.932960|||| | |
12|00733f5ff318527b5fe97b250f0615079b171934c8b035c8ccb1090b668ad72b|||452|-1.0|2017-01-05 07:58:09.047380|||| | |
13|1c5fd0c7a462aff834546394be0490008803499e43382fb744180da895794aad|||242|-1.0|2017-01-05 07:59:09.196555|||| | |
14|1f8eb655610470e58af9fee103f5d6a52e09ce4818bad858445cb8a9499e88b8|||225|-1.0|2017-01-05 08:00:39.421728|||| | |
15|535ca545c8e96caead7ffece68102285464352c24fc5be5105d6fa3be6ea6ba5|||224|-1.0|2017-01-05 08:01:09.536383|||| | |
16|123d60b1f1ae9125a73065f4658fa3d3e6e8673a874100c690ddf5e986c9ac1f|||225|-1.0|2017-01-05 08:01:09.592830|||| | |
17|4cdc85d3e24988b81ddc8a874092403c812df457cf342c31223fb9db1f0d7514|||452|-1.0|2017-01-05 08:01:39.699987|||| | |
18|294b19ffc3ac66851f768f4cab2859b97dbe503fa3f7309969e271f36a9fac62|||372|-1.0|2017-01-05 08:03:18.733875|||| | |
19|69ed35d4551d242bbb3092468ca896727d8c05b623d6922f7cc78763577950a4|||243|-1.0|2017-01-05 08:03:48.933998|||| | |
20|2e0623e19c14a05183bbc5108c8b9b1a0737ee78e920c1fdd3d835a46a4a68dd|||370|-1.0|2017-01-05 08:04:19.123417|||| | |
21|ca013e16c9132d6e8ceaca29749eaaf105cff474b3375d6a4c6b399ad4318cc8|||235|-1.0|2017-01-05 08:04:59.369394|||| | |
22|0bf201a45008c9fe931721a6a1b97b29f1d0d631b363db35667decd722cc490d|||223|-1.0|2017-01-05 08:06:19.873422|||| | |
23|08fd636fa7b45040880b66f2063c67f4f50e0ecab6f7ba479273880666ee7894|||451|-1.0|2017-01-05 08:06:19.947597|||| | |
24|7ec927c8f23fa6dadf9970ab38e160d75737463adf8a34018569c85429d7b7ac|||332|-1.0|2017-01-05 08:06:40.091883|||| |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
The script was restarted between the two selects.