Bitcoin Forum
September 24, 2017, 06:37:21 AM *
News: Latest stable version of Bitcoin Core: 0.15.0.1  [Torrent]. (New!)
 
   Home   Help Search Donate Login Register  
Pages: [1]
  Print  
Author Topic: Bitcoin comeback index  (Read 879 times)
Andrew Vorobyov
Hero Member
*****
Offline Offline

Activity: 565



View Profile
September 17, 2011, 08:40:44 PM
 #1

We must have some index that shows BTC amount entering into exchange from the distant past.

For example, I would like to see how much of BTC that are 1 year old entering into transactions today.

Something like:

SELECT SUM(BTC) FROM CurrBlock WHERE TX_Previous_output_dt < NOW() - INTERVAL x MONTH

          ▄█████▄
        ▄█████████▄
      ▄████▀   ▀████▄
    ▄████▀   ▄ ▄█▀████▄
  ▄████▀   ▄███▀   ▀████▄
▄████▀   ▄███▀   ▄   ▀████▄
█████   ███▀   ▄███   █████
▀████▄   ▀██▄▄███▀   ▄████▀
  ▀████▄   ▀███▀   ▄████▀
    ▀████▄       ▄████▀
      ▀████▄   ▄████▀
        ▀███  ████▀
          ▀█▄███▀
.
|
.
|
          ▄█████▄
        ▄█████████▄
      ▄████▀   ▀████▄
    ▄████▀   ▄ ▄█▀████▄
  ▄████▀   ▄███▀   ▀████▄
▄████▀   ▄███▀   ▄   ▀████▄
█████   ███▀   ▄███   █████
▀████▄   ▀██▄▄███▀   ▄████▀
  ▀████▄   ▀███▀   ▄████▀
    ▀████▄       ▄████▀
      ▀████▄   ▄████▀
        ▀███  ████▀
          ▀█▄███▀
unthy
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
FreeMoney
Legendary
*
Offline Offline

Activity: 1246


Strength in numbers


View Profile WWW
September 17, 2011, 10:24:08 PM
 #2

We must have some index that shows BTC amount entering into exchange from the distant past.

For example, I would like to see how much of BTC that are 1 year old entering into transactions today.

Something like:

SELECT SUM(BTC) FROM CurrBlock WHERE TX_Previous_output_dt < NOW() - INTERVAL x MONTH

Search for "Bitcoin Days Destroyed"

Play Bitcoin Poker at sealswithclubs.eu. We're active and open to everyone.
Pages: [1]
  Print  
 
Jump to:  

Sponsored by , a Bitcoin-accepting VPN.
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!