어제 17시 이후로, 시간로또 한번 있네요.
MariaDB [lottocoindb]> select height, blockhash, amount, difficulty, from_unixtime(time) from blocks where time > 1387785372 ;
+--------+------------------------------------------------------------------+--------+------------+---------------------+
| height | blockhash | amount | difficulty | from_unixtime(time) |
+--------+------------------------------------------------------------------+--------+------------+---------------------+
| 31185 | ebcb860fa32653ec0b3d913626014e17965e1077f2732b89b6d24cc30a9f8139 | 10701 | 3.40706076 | 2013-12-23 17:04:55 |
| 31385 | f4c88b54fdfaf176a508eb4cd65e2db85c6f57a19f7a91c2667a5906c713db4c | 50803 | 5.08937753 | 2013-12-23 18:43:47 |
| 31525 | 4ad3564df887e14f4a16138ad08270d3ef3bdf6948f1b2e2eb6eb615011ecdaa | 38436 | 6.55842907 | 2013-12-23 19:53:25 |
| 31531 | 0fbaa39d926de66f953ac2e523339928e1a720fa6333e0d8e452240077171ba7 | 14334 | 7.27796451 | 2013-12-23 19:55:23 |
| 31574 | 78f0f1a94470ccb32f93b7446a2ef0068d2ab3ccfc27daa81bd13f2d1c58ae81 | 59336 | 6.94389327 | 2013-12-23 20:18:16 |
| 31588 | 1e6f2e2599675707108296850ece6dbfe50722ff07430aa820a26eea9b1830c8 | 17730 | 5.44840758 | 2013-12-23 20:27:41 |
| 31616 | 4f5e361afaba57914c6b597ed9631ca44b316ca3ae8a734c27b7cf66f28bf446 | 65166 | 5.27654516 | 2013-12-23 20:42:08 |
| 31675 | c9f5a12f3b6217d11a92209a6b4151141b17d64922179e17ef3f39b645d418b7 | 19994 | 6.71328134 | 2013-12-23 21:10:32 |
| 31721 | 9ceb6ec21d7714280ade8a83f2d1795d4ab1fa58c14aad9bededd431820301fc | 63719 | 6.91239079 | 2013-12-23 21:33:26 |
| 31734 | 951100ed43fd1c12f22b419c4ea3bb211e5436a0f26ab3dbb4aafca696bd9ec1 | 53515 | 8.07195057 | 2013-12-23 21:38:42 |
| 31794 | 7e6d67f1da0aeaafdc0796f50de92a1c119a9027bfcf88cd5516bcd0a25dd991 | 59267 | 4.7322481 | 2013-12-23 22:14:07 |
| 31802 | ae40c4f280ca7d8fee037898db76f7418df19ec7ffba2587004d87eacbd5bfe9 | 65181 | 5.58632587 | 2013-12-23 22:16:24 |
| 31842 | 7e5592b31cb6e28be48da4b8139f44ae76939bf58ff6e85fd482febe57a0acdd | 31235 | 5.67592448 | 2013-12-23 22:37:08 |
| 31895 | 986fd6b80250cbc659ad5beee859a000a4374ef829c25d53329a18818e815493 | 10344 | 5.85115358 | 2013-12-23 23:04:13 |
| 31898 | 64c82cc4db24d4fbb7a262dcfa603c53cced60c577d4bf98ef03e43c94fc50bc | 17378 | 5.69300458 | 2013-12-23 23:05:48 |
| 31907 | ed264536663893e8b9e48d2c22a3f66ed2d49aef025b2b5184c292fb52dc31ec | 54028 | 7.43554765 | 2013-12-23 23:08:54 |
| 31913 | a13aa61aa55856bf10be1b49c4e6d03fc700a5db58d5d143aa1015f6b06b69b4 | 20990 | 6.5687724 | 2013-12-23 23:12:53 |
| 31948 | 0efbfaee7b41d2cc78e380792ad6279f5e592e1b01581ab148442d2339648fff | 28878 | 7.21196354 | 2013-12-23 23:29:55 |
| 32133 | 69294ce9aa14d4048335940d5f0581e7a51eaba6576761283475579f873a20fa | 60313 | 9.18969757 | 2013-12-24 01:03:37 |
| 32242 | 698edbd81479dc2f30813224f0e330c9ad7704610c7c27c9ada63ebf98cd15a3 | 29131 | 7.54788693 | 2013-12-24 02:00:28 |
| 32312 | bfd131ef9f2d43c5cfd61278d239f2597f315be69a570b33c1cee2d6e8dbeeee | 23962 | 6.51283548 | 2013-12-24 02:37:15 |
| 32334 | 589463d8a378f87f5d0f83e8a3423d5fc1fb25a42bcd7c3ed6cf38933f8bcc02 | 17080 | 6.36859433 | 2013-12-24 02:48:38 |
| 32485 | 6633e69405e0e6c8d76fcf944f6615ed653f7b2f697866f3e0ff6694d049198d | 38489 | 6.53021316 | 2013-12-24 04:06:26 |
| 32561 | 40cb8774e4d392d6e8bf197ab25ad50d1749a340d528d1475cc3db091fa23c99 | 45986 | 5.10519272 | 2013-12-24 04:47:05 |
| 32629 | 8f6ee40ff9d3a67d21d46d2f7ff1ead669b15a100f36cb9f3dc5370fcda64ae3 | 59533 | 3.44177717 | 2013-12-24 05:25:02 |
| 32700 | b2fe9ef4b29083ab4397d93a0c20bc80fedfd455195574fa823c0157b49efa02 | 26753 | 5.75645772 | 2013-12-24 05:57:45 |
| 32752 | 168639eec60fd318fe6fe8b04361f0804e2eb67946b3d90071452c438e24bf80 | 37678 | 4.66248912 | 2013-12-24 06:25:46 |
| 32888 | 26f7e6fae380d09985436019add8f3023c772f79fc5003146c33463285d2c789 | 64521 | 8.56515342 | 2013-12-24 07:31:03 |
| 32897 | 04a9dd2bb35bf4b446e2a7b69df0216199cd8f3b833859af56b7b0504c63790d | 51648 | 5.95226539 | 2013-12-24 07:38:44 |
| 32963 | 436b9c591c9fbc8e16fbd7538375f84f6b8bf659bc0206658291490d0f2903ba | 3545 | 4.35519268 | 2013-12-24 08:14:29 |
| 33041 | 6f96bff5ab2b4fee60955e01ee906f37c2cc29c2c16ba3f50f6d64e60c50ed6d | 8307 | 6.70389776 | 2013-12-24 08:51:29 |
| 33045 | ff31d84b6527d250a934c9bc578b045f84f5effc582114de8a8cab5153659600 | 131072 | 7.0199217 | 2013-12-24 08:53:10 |
| 33065 | 0439f03c9d686ad826dc7a93912499b8b5d0827797549fffb1ed70ad94da74b8 | 32602 | 5.24879018 | 2013-12-24 09:05:49 |
| 33118 | 7035e79e08b0cc6acc09f64a16ed84ba973105f69eda22b9b66ba0c8d25503d2 | 36593 | 5.49344711 | 2013-12-24 09:32:13 |
| 33170 | d1180f3632af6da956d44e54bd7f6bfbb992e21319fe665873d3ac04f19c311a | 15532 | 2.51836465 | 2013-12-24 10:05:20 |
| 33179 | c7e5a093ba6eb90e9880e8d0c5bbd2c619fa2e06aafe0689c5a867967506168f | 4315 | 3.10926967 | 2013-12-24 10:08:50 |
+--------+------------------------------------------------------------------+--------+------------+---------------------+
36 rows in set (0.00 sec)
MariaDB [lottocoindb]> select sum(amount) from blocks where time > 1387785372 ;
+-------------+
| sum(amount) |
+-------------+
| 1368095 |
+-------------+
1 row in set (0.00 sec)