Hacker News new | past | comments | ask | show | jobs | submit login
Analyzing Cryptocurrencies Using PostgreSQL (timescale.com)
521 points by akulkarni on June 28, 2017 | hide | past | favorite | 185 comments



A nice analysis, and it shows how SQL makes it easy to quickly explore data.

However, it seems like the plots of the results of the queries were done manually by writing some code to make each plot.

I can't stop but mention that using Apache Zeppelin Notebook [1] with Postgres interpreter for Zeppelin [2] (Spark SQL should provide comparable analytical capabilities as well, but this comment is not about it) it is possible to show graphical representation of query results without writing a single line of code.

[1] https://zeppelin.apache.org/

[2] https://zeppelin.apache.org/docs/latest/interpreter/postgres...


Author here! For the graphs I used the ggplot library in R, but really any SQL visualization tool (e.g., SQLPad) would have worked as well. Apache Zeppelin Notebook seems like a great tool and I'd be happy to look into it for my future work. Thanks for the recommendation! :)


I just started looking for tools like this and came across plotly and dash: https://medium.com/@plotlygraphs/introducing-dash-5ecf7191b5...

Am I right that zeppelin is similar to this?


I don't get it, don't you need to write code in Zeppelin to have it show plots? You need to decide which data which aggregation.. do you have a link with any doc showing how to plot without writing code? I followed your links but I miss this.


Look at this part of the video from https://zeppelin.apache.org: https://www.youtube.com/watch?v=_PQbVH_aO5E&t=3m21s. It shows plotting directly from SQL.


I've only used zeppelin for spark so far, but it's been a joy to work with.


So what exactly is the current attitude towards cryptocurrencies? E.g. a coin named Diamond went up 200% since yesterday. https://coinmarketcap.com/currencies/diamond/ However it's not obvious what's driving it.

Also, on Saturday, there was an ICO of this coin called TenX (https://www.tenx.tech/) which sold 100,000 ETH (~$30M) worth of TenX in like a minute. Is it all pump and dump?

I can't imagine that anyone has definite answers but I'm interested to hear some opinions.


My opinions:

Bitcoin - Actually used as a store of value, for capital flight, as a hedge, for darknet commerce, and some other ancillary purposes. Genuinely novel, and likely not going anywhere.

Litecoin - Likely not sufficiently differentiated from Bitcoin to become major, but nevertheless compliments BTC for trading and acts as a sort of 'plan B' for some categories of Bitcoin failure.

Ethereum - Cool tech, but all the innovative parts of it are highly unproven. The most novel thing done with it (the DAO) has arguably crippled the whole scene fundamentally with the fork (Vitalik is a kingmaker, and thus could be held liable).

The "ICOs" - Pump and dump, baby! To understand this, take a look at all the ICOs (https://icotracker.net/) and look at the business plans. Basically, there's a whole ecosystem that seeks to recreate Silicon Valley, and bases their presumed success on the magic of Ethereum to give them a competitive advantage. Figure how many of those would have to be successful for the whole scene to stay afloat, and then consider whether that's even close to reasonable.

I think it's transparently obvious that 95% of the ICOs work just fine with a simple database and don't leverage Ethereum in any way whatsoever. But perhaps I'm wrong.

Some other stuff like Dash seems kinda interesting, but it's anyone's guess how the market will respond to it.


>Ethereum - Cool tech, but all the innovative parts of it are highly unproven.

I think it's quite proven. Turing complete contracts work according to their code. This has already allowed hundreds of automated token sales to take place, and anyone to copy paste some code to make their own token (with most using the ERC20 standard).

Alpha versions of several Dapps like Augur have been created and there is the Ethereum Name Service (ENS) which was programmed to do several innovative things:

* automatically release names for registration on a staggered schedule

* use hidden bids that are all revealed during a reveal phase

* require the winning bidder to deposit the winning amount of ETH in the ENS contract for as long as they want to maintain control over the name, thus attaching a rental cost for squatting on a valuable name like exchange.eth, which means the rent charged is proportional to the economic rent extracted by rent-seekers.

* allow peer to peer trade of names

All of these ENS features have been working for months. And this is simply a contract built on Ethereum.

And there are people working on contracts to lend out the ETH held for reserving ENS names, showing there are no limits to what can be done, subject only to the cost of the computing resources of the EVM.

Just as another quick illustration of the openness of Ethereum to innovation, here's a project that automatically created 10,000 unique digital collectibles, each a graphical depiction of a cryptopunk character, put them on the Ethereum blockchain, and then let anyone that wanted to, claim them for free.

All 10,000 were claimed and there has already been 25.0317 ETH ($7,762.83 USD) worth of cryptopunks purchased from those holding them, and there are currently 91.2646 ETH ($28,302.97 USD) in bids for cryptopunks for sake:

http://www.larvalabs.com/cryptopunks


Would you please expand on this in a blog post? Very interesting to hear this out.


Thanks for the vote of confidence. If I can see a way to expand on it in a blog post I'll do that.


I agree with all this, although I would phrase the Ethereum part differently. It's all unproven, but thus far, everything that they have said would theoretically work, and tried to implement, turned out to work in practice. Not disagreeing with your point, just the connotation around the word "unproven". The big test for me around ethereum comes when someone pushes the first REAL dApp on to mainnet. If that works out... then things get really interesting.


Wasn't the DAO supposed to be the first real app, and it failed so badly they had to hard-fork to fix it?


Isn't it functioning fine now though?


What happens when the next one is hacked to the same degree? I doubt a second fork will be tolerated.


The forkers have established - perhaps quite reasonably - the principle that Ethereum isn't a set of rules unto itself, but it includes the ability to right what are externally perceived as wrongs even when they are done by playing according to the internal rules. So the forkers have set a precedent for more forks, as needed, whenever the community as a whole decides some sufficiently impactful party is cheating the spirit, rather than the letter of the law.


Except that the whole value prop of Ethereum was supposed to be that the letter of the law was all, and the system would unconditionally and inviolably enforce it.


Yes, exactly. That got, semi-explicitly, changed in the fork. While remaining so in the nonfork.


Touche. Second real dApp?


These aren't quite dApps in themselves, but the infrastructure is building to better allow nurturing of dApps.

It also seems like the public chain will be leveraged in other novel ways.

--

Eg.

https://blockoneid.thomsonreuters.com/

https://blockone.thomsonreuters.com/

https://basicattentiontoken.org/

https://www.reuters.com/article/us-fintech-payments-circle-i... (The IMF recently commented on how virtual currencies would make international transfers more secure, and cheaper which is something Circle is already doing on the backend)


Bitcoin seems to be a victim of its own success. Transacting in BTC is expensive and very slow now. I think that's what is driving growth in LTC and ETH. BTC proved the concept is workable, but that doesn't mean it will stick around.


There have been years for bitcoin to adapt the protocol - even in non-forking ways - to ease the transaction backlog. Those with commit access and authority have chosen not to.

I got out of it mainly for that purpose. I was interested in a universal currency, not a get rich scheme based on enticing people with the promise of the future just to use that promise as a means to pump exchange rates. Going forward, it is a perfectly serviceable crypto-gold, but it has no greater aspirations anymore.

I think there is absolutely still room in the market for a cryptocurrency that isn't a ponzie scheme that can actually function as a daily driver currency replacement, but none have become popular yet. Probably because they aren't ponzie schemes.


You are demonstrating a fundamental misunderstanding of how bitcoin works by allocating responsibility to people with commit access to the bitcoin repository. It matters little if you commit a change that the 80,000 nodes that form the basis of the bitcoin network don't uninstall their existing node client software and replace it with your new version. It is this resistance to change that is the entire point of the architecture.


I was listening intently to the 1MB argument, and I'm not blaming bitcoin-core devs for trying to drive up the fee market. I would absolutely blame the ecosystem for staying on core, but the blocksize debate reflects a broader human principal than just something local to cryptocurrency. It represents change inertia. People in general resist change unless they can see immediate personal benefit from that change. The node network that dictates the bitcoin implementation on the primary block chain is interested in making money from mining, and higher fees individually only seem like greater profits.

As long as they could believe capping transaction volume and driving up fees wouldn't kill the currency or slow the appreciation in exchanges they are absolutely content with the status quo. And like I said, crypto-gold is useful. It just isn't a currency, and the way both bitcoin-core and the miner network responded to attempts to improve transaction volume reflect on the broader ideology in bitcoin itself - an ideology, like I said, I don't agree with. Not just the developers alone, but the devs and miners that both want inflation and small blocks over longer term adoption that may not translate into guaranteed profit.


Bitcoin is different than other cryptos in a fundamental way. It is inherently conservative. They resist almost any change that isn't an efficiency improvement.

The reality is that, for now, and for the foreseeable future, people are not interested in using bitcoin for over the counter purchases. I know this from personal experience as a former service provider of that specific service. It might never have a use-case that way. People say they want those things, but then don't spend their bitcoin. This is backed up but realty too : there are plenty of other cryptos with the same architecture with 10x the throughput and negligible txn fees (i.e. litecoin) and they aren't used for that. Maybe they will. Maybe they won't. Can't say. I know enough not to want to change something that works for what it is used for though.


Bingo. While there are issues with the developers and their decision making process the real issue is with the large mining conglomerates that control huge portions of the network. They have enormous influence on what changes are actually rolled out and have generally been unwilling to implement changes that will affect their profits. Google for the drama around ASICBOOST, Bitmain, and SegWit.


I completely agree, I wasn't trying to single out the bitcoin-core devs in my allegations. The core devs don't want to rock the boat because the miners would resist changes that threaten their immediate bottom lines (high fees per block minted). Its a tragedy of the commons.


> Its a tragedy of the commons.

Alternatively, it's a feature. The miners "are" the network, them rejecting a change is the network saying no democratically, and that was the intent of the way things were setup, this is how it's supposed to work. A change that hurts miners profits isn't good for the network because it'll reduce mining and thus reduce security of the network overall. So while a change to increase transaction volumes might be good for currency holders; holders aren't the ones providing security, miners are, and the incentives are setup this way for a reason, it keeps the network secure thus providing the value for the currency to begin with.


> The miners "are" the network

Err... no. Nodes define and police consensus in bitcoin, not miners. It is the fact that nodes, and not miners, not agreeing to changes that miners want that would lead to the centralization of the network into miners hands, that is the entire argument about scalability and blocksize.

> them rejecting a change is the network saying no democratically

Yes, it is the nodes rejecting change that is leading to little to no change. The nodes have overwhelmingly agreed to an upgrade, and the largest miner, bitmain, is resisting it, so there may be some truth to the assertion that miners don't want this upgrade because they perceive they will lose profit from it. The fact that the nodes are looking to 'go over bitmains head' and implement this change without the need for the largest blocking miner, that is the entire reason the 'new york agreement' was developed in the first place.

But we do agree on the core issue. The lack of the ability to easily change is a feature of the design. The incentives are slightly misaligned with the implementation of asicboost, but for the most part, they function as expected.


I think you are drinking the UASF kool-aid. A fork that is not supported by the mining power is going to get easily attacked. I guess the "economic majority" could fork and change the proof-of-work so that existing ASIC hardware is useless. However, I would argue that the fork is no longer Bitcoin and that the original POW coin would continue to be used and have value. It would be a lot worse than the ETH/ETC split.

I haven't followed the drama super close but I take the "New York Agreement" as the adults stepping into the room and saying enough with the crazy ideas. If they manage to get SegWit enabled and increase the block size for old-style transactions, I think Bitcoin will be in good shape for a while. I'm not sure it will go smooth though so I cashed out some of my BTC as a hedge.

It seems we both agree that the difficulty of changing the design is a good feature, even though it is frustrating right now due to scaling. A dictatorship is a great system of governance, as long as you can trust him to do good. Other systems are messy and frustrating.


> A fork that is not supported by the mining power is going to get easily attacked.

A chain that is attacked is easily going to shift to a different PoW that renders hundreds of millions of dollars of miner hardware obsolete. And the miners know it.

> I would argue that the fork is no longer Bitcoin

You can argue it all you like. Nodes define consensus in bitcoin, not miners.

> I haven't followed the drama super close

Clearly.

> as the adults stepping into the room and saying enough with the crazy ideas.

You mean like assuming that 80,000+ current bitcoin core reference node users are going to suddenly uninstall their node client software, and install a new unreviewed, untested node client? Because a bunch of suits got together in new york to have a pow-wow? In three months? You mean those adults?

> if they manage to get SegWit enabled

The only reason the nya is accelerating the adoption of segwit before aug 1 is because of these supposed uasf kool-aid drinkers. And isn't it kind of telling that this scalability that has been blocked by bitmain for a year is now suddenly good for everyone? Even though they've been blocking it for a year?

> it is frustrating right now due to scaling.

Take it up with bitmain. They've been blocking scalability for a year now. I'm not that concerned though. I'm happy with just the asicboost bug being fixed and no increased blocksize. Looks like I'm just going to get the blocksize anyway, and I can deal with that. But the hard-fork three months later? You can fork off onto china-coin if you want. I'll just continue using bitcoin.


> Nodes define consensus in bitcoin, not miners.

Again with the kool-aid. Why does the Bitcoin protocol have a POW function and miners? Consensus is defined by the chain with the most work. If you fork and change the POW, you will not have the mining power to secure it. So, it will just be another shitty alt-coin. If you can somehow get the majority of people using Bitcoin to switch over, and somehow get enough mining power to make it secure, then you have something. Thinking that the echo chamber that is r/bitcoin represents the majority of users is laughable though. And thinking that current Bitcoin with the current POW will not continue to exist, have value, have mining power behind it is just silly.


It's strange how many of your belief structure really don't know how bitcoin works. Because if what you said was true, the miners would be able to do what they wanted anyway, wouldn't they? Well? What's stopping them? It's not the 'longest chain' it's the 'longest valid chain'. And what defines validity? The nodes, that's what. It's not like the architecture has changed.

> Satoshi from the Bitcoin white-paper chapter 12 'Conclusion' : The network is robust in its unstructured simplicity. Nodes work all at once with little coordination. They do not need to be identified, since messages are not routed to any particular place and only need to be delivered on a best effort basis. Nodes can leave and rejoin the network at will, accepting the proof-of-work chain as proof of what happened while they were gone. They vote with their CPU power, expressing their acceptance of valid blocks by working on extending them and rejecting invalid blocks by refusing to work on them. Any needed rules and incentives can be enforced with this consensus mechanism.

First, you have to understand what 'consensus' actually means :

> https://en.wikipedia.org/wiki/Consensus_%28computer_science%....

> A fundamental problem in distributed computing and multi-agent systems is to achieve overall system reliability in the presence of a number of faulty processes. This often requires processes to agree on some data value that is needed during computation. Examples of applications of consensus include whether to commit a transaction to a database (or, for example, committing blocks to a blockchain), agreeing on the identity of a leader, state machine replication, and atomic broadcasts. The real world applications include clock synchronization, PageRank, opinion formation, smart power grids, state estimation, control of UAVs, load balancing and others.

Nodes are the agents in a multi-agent system enforcing consensus.

Nodes accept incoming transactions and validate them. Miners don't. Nodes replicate transactions to other nodes. Miners don't. Miners take transactions from nodes, and order them in a block, and perform a hashing function on them (the only thing they do). Miners pass the new block to the node. The node validates the transactions in the block. Miners don't. The node validates the block. Miners don't. The node replicates the block to other nodes. Miners don't.

There is only one function that miners do. They take transactions, put them in a block, and hash them. As soon as a miner produces a block that any node determines does not obey consensus rules, it is rejected. It doesn't even matter if another node has already accepted, because consensus is aligned with all nodes. Any node that replicates non-consensus blocks or transactions is itself rejected.

So nodes accept the transactions, validate the transactions, replicate the transactions, maintain the mempools, validate the blocks, replicate the blocks, serve the blockchain, and store the blockchain. Nodes even define the PoW algorithm that miners have to employ.

Nodes maintain the protocol, not miners. It is thus. It has always been thus.

See for yourself. Download it.

https://bitcoin.org/en/download

It's currently at 0.14.2

https://bitcoin.org/en/full-node

> A full node is a program that fully validates transactions and blocks. Almost all full nodes also help the network by accepting transactions and blocks from other full nodes, validating those transactions and blocks, and then relaying them to further full nodes.

You should probably question how such a fundamental misunderstanding of how bitcoin works comes about. Is there a source for your opinion?


A tragedy that has doubled in value in six months.


Volatility is not an assurance of consensus valuation or rationality.


Volatility is a sign of a lack of liquidity in a market that is rapidly gaining (or decreasing) in accumulated capital. In bitcoin, for now, it is increasing. In bitcoin the important point isn't the volatility, but the fact that it is objectively being sought after by an increasing number of people.


You can't record every currency transaction on a blockchain it simply doesn't scale. None of the altcoins have figured out how to scale either.


You don't need everyone to have a complete blockchain. Etherium, for example, lets you just do fast syncs that use a fairly fixed amount of storage space.

You need a copy somewhere to have an actual blockchain, but not every node need host that chain. The major players in the economy, however, with the resources to keep around 100GB every couple years of data are incentivized to to maintain the stability of their currency network.

Because blocks are reverse-signed, you can't have a limited pool of old blocks and forge the records. Its a chain for a reason - each blocks signature is dependent on its peer blocks, and we still don't have anything close to breakable sha-256 that would compromise bitcoin.


> You don't need everyone to have a complete blockchain.

You do if immutability, censorship resistance, and resistance to state capture is what you hope to achieve with your crypto.

> Etherium, for example,

If Vitalik Buterim were to be arrested for whatever, or if he were even to just have a skiing accident and die suddenly, you'd see how important that decentralization is in bitcoin. There is no single point of failure in bitcoin. That's the point.

Hey, for what it's worth, I think the tech behind ethereum is great. Most of the people who acquire it have no idea really what it is good for, but it has real potential. But as a 'store of value'? That's just one of the things that it isn't designed for.


Seriously, was there this much politiking for infighting when people proposed https://en.wikipedia.org/wiki/OSI_model.


Well, the stack around the OSI model seems to have lost to TCP/IP due to being late and overengineered, so possibly?


How did we solve the problem of recording every written word into a single book?


That's certainly true, but I also tend to think that the scaling debate is overblown. Bitcoin, from the outset, has been designed to generate consensus around a majority chain. Forks are ultimately the source of Bitcoin's security and its development. If there's any elegance to Bitcoin, however brutal, it's here.

There are several approaches to scaling Bitcoin that should work. The debate focuses on risk aversion and which will be best. In the end, though, any untenable situation should be quickly resolved as a majority choose the least painful option. The New York Agreement appears to be this in action, and represents a major shift in the community as a new client may become the default.

Many have compared Bitcoin to TCP: it's not great, but it's good enough to become a standard. I tend to agree with this view, though there are many well-founded concerns.


The second part of the nya has a hand waving requirement of 80,000 or so nodes uninstalling their existing node client software and installing a new unreviewed and untested node client three months after the segregated witness component is activated. I don't even know how that would be possible even if it was a change that everyone wanted, which they don't.

Reckon the first component is going to happen but there is very little chance of the hard-fork part.


BTC could start using SegWit and some other stuff shortly to speed up transactions and lower costs.


It used to be expensive. It is not anymore, as the bigblockers stopped the spam.


Litecoin's value went up 10 fold because it found a way to be useful as a new feature testbed for somewhat real life situation. Went up with SegWit and Lightning Network activation accordingly, from $4. It would've only valued as that for being "plan B".


I do not get ICO or what value they present. However I do see some value in contracts and how they can be tied to crowd funding. I am curious how the Braid movie, funded entirely through ETH [1], will pan out. The payout and profit sharing mechanism are defined in a contract and all that resolves automatically. No guarantee you will get your money back but it is a nice self contained investment vehicle. I did not get in, but this approach does let one invest in 'products' that one would not normally have access to (VC Me).

[1] https://campaign.braidthemovie.com/


But what happened to Dogecoin?


If I remember correctly DogeTipBot shut down after stealing a bunch of funds from its users, removing a significant use for DogeCoin.


What happened to mySpace? something better came and made it obsolete.


It's a mixture of all the answers. It's hype. It's FUD. It's pump and dump. It's groundbreaking technology. It's real world use-cases, and it's vaporware. And it's the greater fool theory on a grand scale. It's all the things simultaneously. In other words, it's a market.

TenX is actually, despite it's name, probably not a pump and dump, for instance (disclaimer: some of that 30M in 1 minute is mine). It's a credit card that links up to various cryptocurrency wallets, and allows you to make real world purchases using them. The token you buy in the ICO entitles you to a portion of the fees collected from processing the transactions.


Nobody in the history of pump and dumps invested in one tells people that it is one.


That is definitional. I invested in it because I don't think it's a pump and dump. I could be wrong. If you're investing based solely on the opinion of others on the internet, you're making a mistake anyway.


They are something between a pyramid scheme and a multi level marketing scheme. They have no inherent worth, are deeply flawed as currencies, and are highly volatile, so aren't useful stores of worth. There is a very low barrier to entry to creating one, so expect them to be created pretty much without limit.


This seems overly pessimistic. They do have inherent value (there's no better way of sending money, no strings attached). I guess the question is whether in the future the world will have one currency or multiple.

I also wonder if this will ever be regulated (and if it even can, it seems like a cat-and-mouse game).

> They have no inherent worth,

They have inherent value as you need some foundation of the internet economy that's ideally not gov't controlled.


Are Bitcoin or Ethereum really good as a currency, though? They're quite volatile.

Fred Wilson makes a good point here - it's quite gut-wrenching to send someone a token that might have doubled in value if you had waited a week. And I would imagine the seller might not feel great either if they received a token that took a sharp drop in value upon receiving it.

Buying things is one of the main uses of currency, IMO, and you can't buy much with any cryptocurrency. I don't think that's likely to change - businesses take fiat currency instead of bitcoins or whatever because they have to pay taxes on their business, and those taxes must be paid in US dollars (or GBP or whatever). And if they don't, men with guns will come and arrest them. That's one of the great drivers of demand for dollars that bitcoin can't really compete with.

So where do cryptocurrencies provide value? Well, the main one is in areas where traditional, government-backed fiat currencies can't be used. In other words, mostly illicit cases - drugs, money laundering, etc. Otherwise, especially for those in nations with more developed financial infrastructure, there's no compelling reason to use bitcoin other than purely ideological motivations.

So you're right that cryptocurrencies do have value, it's just that the value is far more limited and based on illegal activity than most of its proponents will claim.


They work fine as currency, they can be exchanged between people easily. Where they have a problem is value storage, due to volatility.

Most proponents believe that developing countries will be the biggest adopters of crytocurrencies, and drive their values higher. This makes sense as many of those countries already have volatile currencies that are difficult to trade on the open market at low volume. For this reason, USD and Euro are highly sought after for even low income individuals in many less stable countries. Anecdotally, I can offer that many Egyptians with any wealth at all try to hold some foreign currency. It's possible cryptos can replace that need.

Plus, the black market was valued at $10 trillion globally in 2011. If it had an official currency that currency would be worth quite a bit.


Cash is still king in the black market. Bitcoin has taken a small slice of it, esp. for money laundering and buying drugs online.

Put it this way: the black market does not rely on bitcoin in any substantive way. Bitcoin, however, depends on the black market for its existence.

So the black market has a combined value of $10 trillion, but bitcoin takes only a small, small slice of it because cash is just better. It's just that this small slice is bitcoin's bread and butter.


While there is a market for those txns the reality is that most adopters, and they recognize themselves as early ones, today, buy bitcoin as an inflation hedge. It's hard to argue against the theory either. People scream 'but the volatility!!' but for people who only six months ago have seen their bitcoin holdings over double in value, they are probably thinking 'sure. But that's a trade-off that seems to be meeting its use-case'

At what market size do people who have criticized it in the past as only for those things, admit that perhaps that categorization isn't reflected in actuality? 100 billion? 500 billion? One trillion? 10 trillion?


> While there is a market for those txns the reality is that most adopters, and they recognize themselves as early ones, today, buy bitcoin as an inflation hedge.

That's my point - bitcoin is most useful for those who wish to engage in illicit activity (this accounts for at least 10% of bitcoin's market size if not more [1][2][3]) and for those who have ideological reasons to support it.

Those who have ideological reasons to fear inflation and support bitcoin are primarily libertarians, who think of inflation as Satan incarnate and view it as worse than murder and only slightly better than outright theft. But that's hardly a consensus view. Beyond those two groups, bitcoin has no real use.

I'm not saying bitcoin is worthless, I'm saying that there's a natural peak to its valuation based on its limited use cases (see above). Maybe bitcoin will make significant inroads in developing countries, and maybe then those $100 billion+ valuations will become reality, but I doubt it.

[1] https://en.wikipedia.org/wiki/Silk_Road_(marketplace)#Sales [2] http://money.cnn.com/2016/04/15/technology/ransomware-cyber-... [3] https://bitcoin.stackexchange.com/questions/47942/what-perce... [4] http://www.ofnumbers.com/2015/04/22/the-flow-of-funds-on-the...


In one sentence you say 'most' and in the next you state 10%.

So by even your own figures 90% of people aren't using it for the use-case you seem to have an issue with.


>Bitcoin, however, depends on the black market for its existence.

Do you have anything to back up this assertion?

I'm going to contradict you here, and say that there is no reason to assume that.

Only idiots would use Bitcoin for black market purchases in the first place, there are better alternatives for the majority of purchases, and the biggest sources of black market are still happening with USD.

I'm not sure why it's even relevant since both currencies would function just fine if we magically removed all illicit activity.


> So where do cryptocurrencies provide value? Well, the main one is in areas where traditional, government-backed fiat currencies can't be used. In other words, mostly illicit cases - drugs, money laundering, etc. Otherwise, especially for those in nations with more developed financial infrastructure, there's no compelling reason to use bitcoin other than purely ideological motivations.

Definitely. Tack ransomware onto that list too.

There's legitimate use cases too though which do present at least a few compelling cases - for example I've had large purchases outright refused because the seller thought there was a chance I was a credit card fraudster. Nothing says "the money is yours now" like a cryptographic proof of that. They straight up told me, even after I gave them proof of ID - "sorry, too risky, pay with bitcoin".

I've also been flagged by maxmind and similar anti-fraud tools before when I made VPS purchases over Tor. But because I paid in Bitcoin support was able to approve the transaction without a second thought - no more fraud risk could occur.

Of course - these types of purchases aren't that frequent - but they do occur.


buying through tor and paying with bitcoin seems like an oxymoron - do you have a magical anonymous wallet or were just trying to dodge a firewall?


You can't really decry bitcoin or ether for volatility. They are technologies that, given their intent, have never come close to saturating their intended market. Of course if bitcoin gains adoption and more people want bitcoin the price goes up.

That doesn't mean there aren't structural flaws in their design (mostly meant to enable their initial success) but I don't think you can make a cryptocurrency that can simultaneously attract interest while also not appreciating from that interest. In order to implement a coin payout algorithm capable of handling an influx of on-chain activity you basically tell your early adopters "hey, this is a new and unproven thing, but if it takes off the algorithm just devalues it anyway to keep it where it is at" so you don't even have the selfish self-gamble motive to profit off it and thus no reason to participate if it isn't already a successful means of exchange.

The tech is great though.


Agreed, illicit transactions is a core use case for Bitcoin & friends.

The other big use case is speculation - because their real-world value is so uncertain, they're easy to create, very hyped, and basically unregulated, the current crop of cryptocurrency tech is basically a bubble factory.


>Are Bitcoin or Ethereum really good as a currency, though? They're quite volatile.

They're mostly used as speculative capital trading right now, and can't be compared to any traditional currency in terms of volatility. If the dollar was magically swapped for one of them in an instant, and we all carried on transacting with it like we did with the dollar it would be a different story.

Volatility isn't an inherent property of a currency. It's a function of market dynamics.

(I'm not an economist so excuse potentially poor terminology and I hope I'm conveying this well)


$100 bills also have very little inherent value or worth. They are only useful because people are willing to trade them for goods and services, there is a regulated source of them, and it is clearly defined how to transact with them.

Cryptocurrencies have the latter 2 features sewn-up but there aren't a lot of hard-goods out there that are predominantly priced in crytocurrencies. . . until that happens their valuations will remain volatile.


Yes, but when my bank fails, the government backing that paper will pay up the deposit up to €50k... if the government is strong well there you go...

Ask MtGox users what happened with their "currency"... and it's not even a big case in terms of amount of money gone.

The thing is, yesterday I sent USD from US bank to UK and received it in less than 30 seconds paying less than 1% in total on fees (including FX), using Transferwise. Coinbase wants to charge me 4% and will take its time...

A month ago I made a typo when making a transfer. The money bounced back in 3 days. Try sending BTC to your ETH wallet and see what happens.

The problem that cryptocurrencies solve can and is being solved because the technology is at that level now so it's possible. Yeah banks suck, we need new, better banks. Transfers suck, we need more like Transferwise.

Blockchain is a different story though...


MtGox was a central bank and possibly just a giant case of fraud that people fell for, how is it relevant?

Coinbase is FDIC insured and has insurance for Crypto holdings?

Don't use exchanges if you don't like them?


Who insures coinbase's cryptocurrency?


It's done through Lloyd's, so many different companies in a risk pool.


Ask the central bank of Bangladesh what happened with theirs.

http://thehackernews.com/2016/03/bank-hacking-malware.html


The point isn't that having the central bank backing makes fiat infallible, it is that people will trust a private bank with the backing of a government controlling an economy on the scale of the US more than something without any guarantees at all.

Of course, with bitcoin, ether, and fiat, you don't need a bank. You can always keep your money yourself. Except with bitcoin and ether the ability to secure your own money is much more attainable for average people.

On the flip side, a lot of people conflate trust in web exchanges or bitcoin banks with the stability of the currency itself. Isolated, you have a reason to trust bitcoin way more than any state actor - its math, codified, and nobody can erase it now. On the other hand, state actors have force of violence if anyone breaks the money. If someone breaks bitcoin with an exploit in the blockchain, you are screwed without recourse. At this point, with the amount of participation it has, the bitcoin protocol should be considered robust - but that also is what translates into its valuation. It is only worth so much because it is proven through its long years of use.


> people will trust a private bank with the backing of a government

Clearly reality is not agreeing with this assessment? As an example of this counter-argumemt : bitcoin.


Bitcoin is a 42B market. Thats a third the market cap of... McDonalds.

In a global economy of some 64 trillion, 42 billion (plus the gold and other precious metals, and many other "lack of faith" stores of wealth) is not even a drop in the bucket.

And even at that, you don't have to have no faith in established currencies to also use bitcoin. I personally don't think the banking system in power now will fail any time soon, but I also can recognize how valuable a cryptocurrency would be to replace it.


What does any of that to do with your argument that people won't do something that they clearly are doing?


That the people developing bitcoin and the people investing in it can have faith in the currently popular monetary systems while also investing in bitcoin. The presence or popularity of bitcoin does not imply an objective amount of lost faith in fiat currencies.


> The presence or popularity of bitcoin does not imply an objective amount of lost faith in fiat currencies.

'Objective amount'? What it is is an amount, and growing, that feel exactly what you imply doesn't exist. There are clearly many people that have lost 'faith' in fiat currencies, or the central banks that manage them, or the economies behind them, or all of these things, to the tune of the market-cap of bitcoin. How more objective an amount can you get than that?


> Yes, but when my bank fails, the government backing that paper will pay up the deposit up to €50k... if the government is strong well there you go...

Eh, yeah, good luck with this. Maybe ask the citizens of Cyprus how trusting their government's promise to pay out in full on their bank accounts worked out.

The US banking system is now hugely concentrated, with a huge pile of leveraged derivatives bets being pyramided on top of depositor money. When this unravels in spectacular fashion, the choice will be to print a massive amount of new USD to paper over depositors' losses, or bail-ins. Either one will accelerate adoption of BTC to escape the depredations of fiat currencies controlled by gov't backed banking cartels.


The graph of the Dollar also doesn't look like this https://cdn-images-1.medium.com/max/1400/1*esoUPhcZiG3pEk1cz...


And it's a damn good thing, too. High volatility and deflation would be an unmitigated disaster. The US, UK, and Japan are all currently fighting deflation with QE policies, which seem to be working fairly well.


If by working you mean rapidly transferring wealth into fewer sets of hands, yes.


You mean like Bitcoin, where a relatively small number of people hold the majority of all mined Bitcoin in the world?

https://bitconnect.co/bitcoin-news/254/bitcoin-millionaires-...

https://bitcoinprivacy.net/richlist


What does that have to do with quantitative easing and deflation?


Are you saying that avoiding deflation and volatility is what consolidates wealth? How?

Or are you saying that quantitative easing consolidates wealth? How?

Or are you just inserting an unrelated complaint into the discussion?


I think I'm being clear enough. There has been an objectively massive shift in wealth between low and middle income earners to wealthy asset accumulators over the past 30 years, and that has accelerated over the past 10. This solution you're lauding has been engineered by exactly those asset accumulators as a response to problems caused by exactly those asset accumulators.

It's like you're cheering on an arsonist because after the fire he lit that has burned down your house, he hands you a bucket of urine to help put the fire out.


So, I don't understand what you were trying to say, and when I ask for clarification, you just double down instead of actually answering my questions? Come on, I just want to understand what your viewpoint is, but if you don't want me to understand your viewpoint, I guess that's your prerogative.


Your questions :

1. Strawman. It is the concept of value itself that has been perverted through this process.

2. Because organisations (i.e. banks and the owners of their service channels) closer to the feed of treasuries suffer the least of the effects of monetary expansion.

3. I thought we were talking about inflation and bitcoin as a store of value?


When the question is, "Are you saying X?", "Strawman" is a nonsensical answer. I wasn't asking rhetorical questions, I was asking questions because I didn't understand what argument you were making and I wanted clarification. That's pretty much the opposite of a strawman argument right there.

Furthermore, I don't know how to make heads nor tails of the statement that the "concept of value itself" has been "perverted". Such a vague and sentimental notion could mean many different things.

The criticism that our economic system aggregates wealth in the hands of a few is valid, but at least the dollar isn't suffering from deflation and extreme volatility, which is what makes it viable as a unit of account (unlike bitcoin). I wasn't considering bitcoins or dollars as stores of value, just as units for measuring value and devices for transmitting it. Maybe at some point bitcoin will overcome these problems, but for now, I'm rather glad a graph of the dollar's value looks nothing like the graph shown in the original comment.


Let's bring ourselves back then to what was being stated. You said :

> The US, UK, and Japan are all currently fighting deflation with QE policies, which seem to be working fairly well.

... and I said :

> If by working you mean rapidly transferring wealth into fewer sets of hands, yes.

... and then you said :

> Are you saying that avoiding deflation and volatility is what consolidates wealth?

I was talking about the effect of QE. That effect being the objective fact that money has transferred from people with less to people with more. You were inventing a strawman about the theory that if the people who were doing this didn't get what they wanted, we would have 'deflation and volatility'? Seen the house markets over the past 30 years? Looks pretty volatile to me, so it doesn't sound like whoever is making policy has their fingers on the pulse, do they? Sounds more like a marketing gimmick to me.

I had to write a paragraph of crap to answer a BS premise that had no relationship to the argument at hand. So. Strawman.

> Furthermore, I don't know how to make heads nor tails of the statement that the "concept of value itself" has been "perverted"

Maybe you got fixated on your strawman.

> but at least the dollar isn't suffering from deflation and extreme volatility

Yeah. Theft is much better. Here is a gun to your head. Give me what I want or I pull the trigger. But at least you don't have deflation and volatility. Remind me again... how many people went to prison for the GFC?


> I had to write a paragraph of crap to answer a BS premise that had no relationship to the argument at hand.

Are you saying you don't want to respond, but something forced you?


What do you think?


I've certainly thrown my fair share of insults around on Hacker News. Petty? Yes. Wrong? Yes. I'm a slave to my baser emotions from time to time, and I won't excuse that. The general technique for insulting someone on HN is to be subtle and imply that they're stupid, to provoke them into getting angry and saying something stupid, or to throw indirect insults by describing their comments as "garbage", "crap", or whatever. I hope one day that I'll grow out of it, it's an awful habit.

The saying, "It takes one to know one," seems appropriate here.

Coming out and saying that you "had to write a paragraph of crap to answer a BS premise" is a bit transparent, don't you think? It's a roundabout way of saying, "you're so stupid that I had some kind of moral duty to correct you, which is a waste of my time because I have better things to do." But... why would you call attention to the fact that you have better things to do than argue with me? Isn't that basically the same thing as admitting that you're bad at prioritizing your own time, that you feel compelled on some emotional level to debase yourself by talking with me?

Which brings me to an alternative strategy: if you think someone's wrong, ask questions. Maybe you'll learn something, maybe they'll learn something, and maybe it's just a misunderstanding.


The difference between a $100 bill and 0.04 BTC is that the IRS accepts the $100 bill as payment for taxes. Taxation is what creates the fundamental demand for national currency.


> there's no better way of sending money, no strings attached

Is this true? I've never been able to figure out how to turn my BTC back into GBP without submitting documentation for KYC laws. I never had to show Paypal my passport, and paypal sucks.


Except the same applies to translating almost any currency into any other. The Eurozone is fairly unique in the world in terms of lax currency exchange within itself - go try converting Yen or Rubles into GBP and see if you don't have to file anything.

Bitcoin absolutely is valuable. Some people even take it as payment, making it a currency. And moving around that currency is way more transparent and unencumbered than moving any form of fiat. Currency exchange is wholly up to what you want to convert it into and what exchange you are working with. And if that ends up involving your government... people in other parts of the world don't have that limitation. You can't blame the tech if your society chooses to inhibit it (as your PM is trying to do right now...).


You are not talking about sending money, but converting money from one type into another, namely fiat money (which is exactly why all the KYC regulation is required). Try converting one crypto currency into another using shapeshift and see how extensive that KYC process is.


Bitcoin's total potential transaction volume is about 3 orders of magnitude less than the Visa network. It's a massively centralized currency (everyone has a list of every transaction in the currency) compare to any real currency which can perform transactions solely between two parties.

There is absolutely no inherent value and no transaction is denominated in bitcoins (you can pay in the number of bitcoins equivalent to a number of dollars, but nobody operating a real business wants a number of bitcoins for a good or service).


> Bitcoin's total potential transaction volume is about 3 orders of magnitude less than the Visa network.

Why are you comparing it to visa? I have no intention of getting rid of my cc. My bank account on the other hand...

> There is absolutely no inherent value

Clearly the people who have assigned value by acquiring it would disagree with this, yes?

> and no transaction is denominated in bitcoins

That's just false. Almost all other cryptos are priced in bitcoin, which i think is the subject matter of this thread.

> nobody operating a real business wants a number of bitcoins for a good or service

Oh dear. No. If you think that service providers that are paid in bitcoin aren't keeping their bitcoin holdings you're kidding yourself. That may have been the case a few years ago, but today? There are services today that do exactly the opposite : take a wage and immediately convert into bitcoin and place it in your wallet.


There is low barriers to entry, but Diamond referenced above at least has 3M in transactions, so it doesn't seem quite like a copy-and-paste cryptocurrency. There are 800 or more cryptocurrencies, most of them are probably junk. The top 10 by market cap are probably interesting. There are many that fit a particular niche (gaming, banking for legal pot, medical records in blockchain, privacy, smart contracts).


Heck a transaction count could easily be part of a pump and dump scheme.


That's $3M in transactions, sorry I forgot the $. Yes, it could be part of the scheme, but most exchanges charge a percent or more. So it's more than just a copy-and-paste (the term for new currencies that come out without any substance behind them), if they're also spending $40K/day in exchange fees. Now, speculation is that C-CEX is involved or behind some of these bogus coins, so you gotta look at what exchanges it's on. Diamond is on Bittrex, which seems to be on the up-and-up.


I wonder how long before someone leverages celebrity to launch a new coin. The barrier to entry is so low, and everyone wants to get in on the ground floor of "The Next BitCoin".

A decent marketing campaign and an easy-to-use purchase flow could blow up a new cryptocoin pretty quickly.


Since your comment seems to be one of the most negative in here, it's a good place to post this article, and I recommend you also read it. Perhaps it can change your opinion a little bit from the "cryptocurrencies are just like tulips" mentality:

https://hackernoon.com/why-everyone-missed-the-most-importan...


I disagree entirely with what your current top response is.

If they're "deeply flawed as a currency" I'd love to hear an explanation as to how, especially compared to traditional currencies that are manipulated by commissars? That's not a political assertion, it's a mathematical fact demonstrated in developing nations more acutely if other examples are needed.

With that said, you can copy the entire cryptocurrency stack that makes up Bitcoin and just rename it. Many of these new coins are just that, clones for pump-and-dump schemes.

And many actually offer legitimately new and intriguing concepts that may have good use cases.

It seems like you already understand it? Is you're question whether they're all flawed or all functional and useful?


They are all deeply flawed as currencies because they are scientific in nature rather than economic.

It actually doesn't take far for the cart to keel over. Just as far as saying your money supply has a finite limit and / or it has an absolute number of coins minted means it cannot function as a currency. This has been demonstrated by how the bitcoin economy operates in two states - either its going to the moon, or its slowly dying off. Nobody can use it as a regular money because the incentives are entirely built around hoarding it rather than transacting with it, and they were built that way on purpose...

It is a chicken and egg problem. You won't get adoption or take off unless you can entice people with promises of fortune. If you don't give first mover advantage in the cryptocurrency market people will just flat ignore you. But if you do, you sabotage whatever idea you had to just be a ponzie scheme, because it means you have to start out with huge inflation and reduce it over time to keep your adherents happy.

I do think there is absolutely room in the world for an actually usable cryptocurrency to replace traditional fiat. It would be really beneficial to have one, to dethrone the currency manipulators that profiteer off of the influence they yield. But you need a money that can actually fit into the global economy as a means of transaction and not a store of value to accomplish that, and it would require structural considerations counter to what makes any cryptocurrency currently take off.


>They are all deeply flawed as currencies because they are scientific in nature rather than economic.

I don't think I disagree with what you mean, I think I disagree with the notions that these are mutually exclusive.

To echo Margaret Thatcher's (I know) final words in office, there is no such thing as apolitical money. I don't believe there can be a world in which economics is divorced from politics in any way, I think society must occasionally make political decisions about economics.

I agree with your points pragmatically though, which perhaps is where you're grounding everything?

Do you mean that having a forced deflation with cryptographic mathematics is a flaw? I don't really understand why a finite amount of currency would be an issue if the number of units scales beyond what the entire world's traditional currencies contain combined.

It's just a cryptographically enforced trust network to not print money when you decide you want to print money.


> these are mutually exclusive.

I wouldn't say they are, better wording would have been that they were developed for scientific purposes first, caring of the technical, before concern for the economic ramifications set in.

> a finite amount of currency

It is a matter of incentives. Right now, anyone holding most fiats in the world is incentivized by their controlled inflation to spend the money - and if they don't, it has negative economic ramifications because money that stops circulating (also known as a drop in monetary velocity) is effectively lost productivity until it reenters circulation. Traditionally, no millionaire just stuffed their mattress with Benjamins, but we are now seeing corporations effectively do this by sitting on hundreds of billions in cash offshore. The economic impact, however, is the same - money stops moving, and slows the economy because its not being spent. As money slows down, it increases scarcity, and you can quickly have a runaway deflationary spiral where the money keeps getting scarcer and scarcer thus incentivizing people to hoard it more and more while the economy stalls out.

I should disclaim this is independent of how bitcoin (and ether, doge, ltc, etc) naturally deflates through market adoption. All those currencies either have decreasing or static minting of coinage, which means that every new entrant to the market by definition increases scarcity of the coin and drives prices up. This, again, has a runaway effect evidenced by how almost everyone uses bitcoin - as a store of value, not as a means of exchange. Because simultaneously fees are high and transactions are slow, and the money is appreciating over time as more and more people start using it.

Your point relates back to my premise - technically, a finite money is fine as long as its highly divisible, like bitcoin is. The theory is that as the price goes up people just deal in smaller coin denominations. The problem is that doesn't address the economic incentives structure around appreciating currencies, which disincentivizes spending them.

> It's just a cryptographically enforced trust network to not print money when you decide you want to print money.

It isn't about one person having minting powers. The whole point is trustlessness. But you can still have all the promising aspects of cryptocurrencies (public ledger, trustless transactions, theoretically low response time with low fees, pseudonymity) while also having the coinage algorithm adapt to money velocity in the economy to attempt to push incentives towards spending rather than investing when they need to be so pushed.


>This has been demonstrated by how the bitcoin economy operates in two states - either its going to the moon, or its slowly dying off. Nobody can use it as a regular money because the incentives are entirely built around hoarding it rather than transacting with it, and they were built that way on purpose...

Transactions per day have been growing rapidly every year in Bitcoin and Ethereum. In Bitcoin, the growth recently stopped, but only due to the block size hitting its protocol limit.

So the evidence contradicts the hoarding theory relating to deflating currencies. The wealth effect from appreciation seems more pronounced than the hoarding effect.


DMD (Diamond Coin) was an organised pump and dump and its information and timings were circulated within some niche telegram groups. Some example of previous similar attempts are BRX,EBST,TRIG & SNRG tokens (on Bittrex exchange).


There's defintely something of a bubble going on now. I think this is driven by people realizing "wow these things ARE real" and they aren't sure which ones will last and which one won't.

People saw the insane gains earned by bitcoin and ethereum, plus a few other coins, and they figure "you can put in a thousand and turn it into a million." Get enough people doing that, and hey, bubble.

I'll consider the bubble over once dogecoin - a joke currency that doesn't really have much to offer and had all kinds of issues - reverts back to its historical lows.

http://coinmarketcap.com/currencies/dogecoin/


There are some cryptocurrencies which are actually technologically novel. Unfortunately, they don't usually do a great job of marketing themselves, since their teams are more interested in building the technology than in making big bucks from ICOs or speculators.

For example, there is Monero and other "privacy" coins, which promise private and untraceable transactions. They are usually based on ring signatures.

Or IOTA which promises to scale to thousands of transactions per second, and is based on a Directed Acyclic Graph instead of a blockchain. The more devices or people who use it to make transactions, the faster it gets. Scalability is something Bitcoin is struggling with right now.


Byteball is an actual working block-chain less cryptocurrency, without a trusted single coordinator as iota has, and has no proof-of-work.

https://byteball.org


It's currently mostly smoke and mirrors, people who are vested into the ecosystem and VC money feeding it. Their goal is to have society adopt it, so then their "$1000" is actually worth something, however right now as per example of the Ethereum's Ether drop to $0.10 - the crypto-assets aren't very liquid and their communities know this and are sneaky/sly and careful to not upset this. If they succeed it will be bad for society, it will unfairly and unreasonable transfer wealth to the "early adopters." Part of the smoke and mirrors is the purposeful misnomer of using the word currency in its name - cryptocurrency - and using the $ sign.


We can disagree with whether or not there is value in decentralizing certain systems, or whether a specific project or team is actually working towards creating value, but the idea that "If they succeed it will be bad for society, it will unfairly and unreasonable transfer wealth to the "early adopters." is just crazy.

First movers, early adopters, investors, these folks are providing funds to create things. They're taking a risk and if that risk pays off, and something valuable is created, should they not share in that value?

One of the truly game changing features of the business models blockchain enables is the alignment between creators, investors and users. All have an opportunity to profit if the thing works. That alignment is the wild card in all of this, how much value does having a large community of owners, folks with skin in the game and a desire to make something popular and work, bring to the process of adoption of a new tool or system? I think it's a big one.


The question is how much value should early adopters reap. Before bitcoins first halving, way back in 2012, almost half of all bitcoin were minted. Between then and the second halving in 2016, about another 25% of all BTC was mined. As of now, well over 75% of all bitcoin ever has already been mined, yet bitcoin has a market cap of around 42B - not even a third of McDonalds, which is around 130B.

If bitcoin ever were to become a universal currency, its market cap would need to grow into the tens of trillions. That represents at least a thousandfold increase in participation, and even right now 1% of all wallets hold 99% of the money. The richest wallet right now holds about 315 million USD in bitcoin. Is it truly reasonable that the person that controls that wallet, if bitcoin were to grow a thousandfold to encompass a large part of the global economy, be worth more than the current top four richest people alive? Wealth inequality is bad enough as is.

I think everyone can agree that it would be a disaster for bitcoin to take over traditional currency systems with its current design, where the total money minted ever is already almost all in circulation. By 2020 about 88% of all bitcoin will have been produced. That is just preposterous for anyone considering trying to grow it into a global currency of substance.


I'm no financial expert, but I don't understand why it matters that 88% have been produced. Each bitcoin can be split into a lot of pieces. The satoshi is currently the smallest unit of the bitcoin currency recorded on the block chain. It is a one hundred millionth of a single bitcoin.

So if the market cap was 10 trillion rather than 42B, instead of your Big Mac costing 0.00157btc like now, it would cost 0.000006594btc. Why is that a problem?


How about explaining why that idea is "crazy?" Everyone who's pro blockchain crypto-assets has the positive spin down, there's barely any discussion about the negative side.

There are already investment models for funding things that can give a pay-off, a pay-off that aren't Ponzi-like schemes.

Why is this new system needed for aligning creators, investors, and users?

And not all have an opportunity to profit - what happens to the last 40% who would eventually be forced to adopt through whatever means?

And of course it's a big opportunity if you get everyone aligned over the idea of being able to profit, the early adopters especially love this because that "$100" they spent could become worth $100,0000,000 at some point with no effort on their part. There is an inherent difference between investing in a stock in a company and something becoming a currency.

This is too shallow of a discussion to go anywhere, there has to be actual analysis and projections to refer to.


After re-reading your comment, I also never disagreed that decentralizing certain systems has value or not - it certainly does, especially if it's truly decentralized; a central platform that is well-governed can work just as well, though of course is more open to hostile takeover and the such.


For ETH/ICO I recommend this: https://blockgeeks.com/guides/ethereum-token/


If anyone out there doubts that a lot of pump-and-dump scams are happening, they need to take a look at this (NSFW): http://boards.4chan.org/biz/catalog

I'm sorry for linking to 4chan, but I don't know of any better way to display the caliber of "investor" that is participating in this market right now.


What's wrong with linking to 4chan? It's just a message board.

But yeah, these kids are largely responsible for the common layman's goldrush to crypto.


There's a "rising tide lifts all boats" effect going on, and so there's more buying and less selling across the board. A lot of new money in crypto that doesn't have a handle on what makes a coin potentially valuable and so money is being thrown at everything. ICOs are big now because of the same exuberance that is driving up the prices of everything else.


That's my understanding. I'm not even sure what exactly does make a coin potentially valuable.


More people coming in, less people getting out.

Fear of missing out, and people refusing to sell at a loss.

I dont see any use case beyond being a speculative asset and a money laundering technique, but that is subject to change. Even just being a money laundering technique is a good enough use case to give it value; look up XMR/monero


So we are discussing dApps on a platform that talks about making unicorns. Yes most ICOs are pump-and-dump at this stage but if similar study is done for unicorns valuation, we are going to find many examples of campanies that are 100x more valued. It is true that some people would be burned by ICOs sooner or later but that's what fair markets are for. I see this as process that democratizes ycombinator like companies. Eventually the process will be mature enough that the 'value' that yc or 'angels' provide would be available to more and more companies and angels replaced with everyday people.


> Is it all pump and dump?

Unless proven otherwise, yes.


From observation, the movement of alt coints on exchanges or during an ICO don't really reflect the inherent value - they reflect the level of hype.

People or groups expect a coin to do well, or they expect that enough other people expect it - so they buy.

Some fractional subset are sincere in their beliefs that it's the Next Big THing. A larger group of buyers are convinced by the passion of the original group. But the majority pile on because they expect to make short- to medium-term profit on price fluctuation.

Very similar to the stock market.


For smaller coins, it reflects the level of pumping and dumping.

Buy a coin, hype it, buy some more, then dump your stash on the market.

I think there were twitter accounts before to do this, like voting rings.


As a Bitcoin fan, I think the invention of Bitcoin itself was useful and has proven itself in certain areas, and there's been a couple Bitcoin forks or inspired projects that have done real worthwhile innovation (Ethereum to name one), but otherwise nearly all cryptocurrencies outside of those two are just copycats with no innovation (not counting a tweaked identifier) that have absolutely no reason to exist outside of being pump-and-dump scheme.


The current attitude? Are you talking from a technical point of view, general population or a crypto enthusiasts's view?

Technically, people find blockchain to be able to replace trust in some form or the other. Specially in places like stock transactions, where a trusted third party does share transfers with time as long as T+2 days (with T being the day of trade). Problem is people forget that there is a reason why humans are involved in transactions. Its not about trust. It is about a simple truth in business - shit happens. When it does happen, I would rather have a human being to be able to negotiate than have a smart contract execute and try to bankrupt someone

General population, my guess is, still finds this all mumbo jumbo. I have my colleagues telling me about a "bitcoin plan" where they are getting assured returns from a shady money manager. They all have been told about this "bitcoin" thing which went from ~300 to 2.5k in couple of months. Greed takes over and they are shelling money left and right, even with me trying to talk sense into them.

From a crypto enthusiasts point of view, crypto currencies are going to take over the world, replace fiat and replace it with a world where no one needs to trust anyone because blockchain can solve it. Quite a lot of them fear missing out on the next BTC or ETH so they throw money even when don't understand the utility completely.

As for Tenx, it is a tried and tested formula of coin backed cards, nothing new. They will have reserve to hold out for some amount of volatility before trying to sell more coins.

I think this thread about Bancor - the highest ICO yet will add some more info - https://news.ycombinator.com/item?id=14618109


Actually, "understanding" something can hinder your success (at least short-term) significantly.

I for example missed out almost completely on the recent Ethereum craze, even though I learned about this new project shortly after their initial crowdsale. Back then, I tried to learn how this thing ought to function and what it tries to do, in an attempt to gauge whether it is feasible from a technical standpoint. I came to the conclusion that this is a visionary, but technically deeply flawed project, because it wouldn't scale on so many levels:

- block validation requires everything to be executed on every node again and again -> essentially your thousands of nodes all compute the same stuff, which is hardly the "supercomputer" as which it is marketed

- parallelization would be hard to achieve, as every contract can possibly call every other contract by design -> again, no "supercomputer" works this way, and transactions per second of this network would be severely limited to an amount that's so low that it would not be useful for any real business case

- smart contracts would be unable to get any data from outside except for stuff delivered to them via transactions, and all that stuff must be pushed onto the blockchain and archived forever -> blockchain would either explode in size or contracts would be extremely limited in their possibilities, despite turing-completeness

- every transaction costs gas, which is bought by ether, which costs money, which means that providing "free" services to users is pretty much impossible besides by impersonating them and doing requests on their behalf, which totally destroys the idea of letting the user sign everything by himself. Free services are an important way of getting user traction however for businesses today and probably also in the future.

But despite all these problems and surprisingly (at least for me), Ethereum found a real killer application in the ICO craze: pie-in-the-sky-kind of "companies" created some fancy marketing material called "white paper", a fancy website with fancy team members, laid out a business model that usually conforms to the pattern "we do this already successful use case X, but only decentralized and on the blockchain" and necessarily incorporates a new "token" that they intend to mint and sell to "investors". The tokens are practically useless most of the time (except for their producer, which uses them as a vehicle to get "investor" money), but the fact that almost all of these tokens, as soon as they landed on crypto exchanges (which happens quickly now thanks to the ERC20 standard), netted their initial purchasers an immediate 2-5x profit or more when selling resulted in more and more people buying ether and trying to get in those token sales for a quick buck, effectively driving the ether price into the sky.

For this "use case", all the scaling limitations described above - which still exist, and there are still at most unproven, concept-stage solutions in existence for them - don't really matter, since the ICOs only sell dreams of future applications on the Ethereum blockchain, not actually working ones, and dreams aren't limited by scaling issues (except for the fact that some of these ICOs by themselves drive the current Ethereum network into dysfunctionality already, as recently demonstrated during the Status ICO which effectively clogged the network for almost 48 hours).

I wish I had realized this earlier and had taken part in the 30x gains in the price of ether within two months. But my knowledge about the scaling limitations of the network that ought to be the foundation of all these lofty dreams kept me back...


What you are feeling now is hindsight bias or survivorship bias. Would you have felt this bad if ETH didn't rise to these levels? Nope.

Or would you have dumped the ICO for 2x-5x profit once the "price target" was achieved? Or would you have ridden the hype wave up to the current 30x?? The answer is you don't know.

Limitations of the project are real. If your idea of becoming rich is buying something you don't believe in and hoping it goes up big time, then you should try the next big ICO, maybe you will get lucky.


TenX is a project on Ethereum, they're planning a crypto-backed debit card; it'll charge fees to users and pay them as dividends to their token holders.


DMD was a legitimate pump and dump orchestrated by a trading group. How it works: Everyone sends BTC to a bot. Bot buys a ridiculous amount of random coin to skyrocket the price. Noobs see price rising and FOMO in. Bot dumps coins on new buyers and everyone in trading group gets rich.


Do you think that you could email me at <my-hacker-news-username>@gmail.com? Thanks.


The only thing driving it is bigger and bigger fools trading back and forth with each other on speculation. Eventually the biggest fool will be left holding the bag and the speculators will move on to their next target.


Read about the tech and troll forums to decide. It's possible (true) that people can genuinely invest time and money in BS technologies. See: Golem, Tangle. That said, some certainly is pump-and-dump.


Maybe the tech will be useful at some point; I could see that. Buying into actual "currencies" seems like buying tulip bulbs though.


You need uncensorable cryptocurrencies for online transactions that people are trying to censor. You connect the dots.


I love AntShares! Check us out on r/AntShares (will be rebranding to NEO in the coming months)


This was work done by our intern over the past few days using TimescaleDB. Our team is around to answer any questions!


OT and hijacking the thread:

"TimescaleDB (the OPs product) is a new open source time-series database built up from PostgreSQL."

Do you know good alternatives or which distributed databases are generally well suited for huge volumes of time-series data? Cassandra?


Most products in this space are pretty obtuse, so I'm excited about TimescaleDB because of the people who started it and the tech it's built on. I was really underwhelmed by problems with Influx, and I don't think this group and this tech will have the same class of issues.

I think HBase is better than Cassandra for this workload, and I generally like its design sensibilities and consistency focus (gross oversimplification C* = MySQL, HBase = pgsql?) . OpenTSDB is one of the more mature scale out timeseries DBs and works with both. It works pretty well, but getting a production quality HBase setup is non-trivial. OpenTSDB has some decent built in aggregation and filtering functions, but queries over long time spans are quite slow because it has to pull all the data out of HBase and into the tsd daemon.. that can be fixed with what HBase calls a co-processor (think stored procedure in SQL) but it hasn't been done yet.

So, I think TimescaleDB is hitting a real need at the right time, and seeing how expressive and easy to reason those queries are, I am excited to give it a shot.


Obviously I'm biased, but in our testing of TimescaleDB we've found it to do well with large amounts of data. We're still working on benchmarks that we hope to present in the coming weeks/months, but we've been able to sustain high insert rates even when the database contains billions of rows and metrics. And in our preliminary comparisons to Cassandra the query latency for TimescaleDB was much better.

Happy to try and address any concerns you may have


Billions total? Per month? Per day? Per hour? Per minute?

I hate the word "large" in these contexts.


Our internal benchmarks (which we are publishing soon), show a sustainable insert performance of 100K+ rows/second (where each row contains 10 metrics -- some would call this 1M metrics/second), even at 10 Billion rows. All on a single commodity instance (with only 16GB RAM). (We will publish these soon, along with scripts to reproduce them.)

But I agree that "large" often means different things to different people.



How big does this data end up being? Couldn't you store it in a bunch of double arrays in memory?


"Turns out that if you had invested $100 in Bitcoin in July 2010, it would be worth over $5,000,000 today."

Actually if you had invested $100 three months earlier, in April 2010 (when BTC started trading at $0.003 on BitcoinMarket.com) it would be worth $87M today.


Was BitcoinMarket.com the first marketplace? It struck me on reading that quote that I had no idea how to purchase bitcoin in 2010, and was more interested in finding out how to mine it.


Yes it was the very first.


Assume near-perfect liquidity among x-coins. Assume, also, that software makes starting a new kind of coin as easy as starting a small business. This implies that the crypto-currency market cap will be divided among far more than "21M".

So, given near-perfect liquidity, what makes any particular coin valuable? For shares it's earnings per share. Will we need something akin to "earnings per coin"?


Yes, and for ICO-type tokens we can expect to see a lot more starting very soon which offer a simple mechanism of profit sharing (dividends) just like with traditional stock exchanges. It won't be as simple as "earnings per coin" since the coins themselves are so diverse and some carry and modify their own monetary properties.

But ultimately we'll probably see those types of coins separated and the more traditional profit sharing coins dominate the market such that a shared language can be established for it.


The same thing that makes one fiat currency more valuable than another -- the demand/supply/confidence for that currency.


Taxes, central bank, military, and existence of cash all preserve value of fiat.

And, further, fiat currencies aren't perfectly liquid with respect to each other.


Forex markets are basically as liquid as you can get -- of course some exceptions, but I think the idea still holds.

While an existing fiat currency might derive its confidence from different sources than that of a digital currency (taxes, military, etc. vs. blockchain, mining, contracts, etc.), it does not make them that different. People still declare the coins value on that confidence/demand.


Yes, definitely on the forex thing. But with cryptocurrency-level liquidity there is no reason for any normal consumer to hold funds in any particular crypto currency (or any at all), since they can exchange them cheaply and quickly on demand. That is, unless they're speculating it will increase. But this increase presumes scarcity. And so the question is: whence scarcity?


If you need additional datasets, head over to https://spreadstreet.io where you can download over 3,000+ datasets across hundreds of digital currencies.

Nice article! Had a good time reading it.



Props for providing the scraped data set as well!


In case anybody here finds this useful, I made a screencast following the blog for setting up and loading the data: https://www.youtube.com/watch?v=RSFC24FMxy4&feature=youtu.be


Here's pt. 2 of the screencast: https://youtu.be/LrBAWL6bYa4


I remember when bit-currency first came out years ago. Back then it was still possible to generate them on your slow desktop machine without too much work. I considered doing so, but figured they would never go anywhere so why bother. Sigh...


Where can we get access to this dataset and time series?

I would like to run my own analysis too!


There's a link at the bottom of the post for downloading both the dataset and TimescaleDB:

https://blog.timescale.com/analyzing-ethereum-bitcoin-and-12...

Enjoy!


Slightly off topic, but what are good CoinBase alternatives for buying/selling that cover currencies outside of just Bitcoin, Ethereum and Litecoin?


Coinbase is what I recommend for getting money into an exchange. CEX.io is another way to get money in, though when you buy bitcoins with them the prices they give you seem a bit low to me. This is easier to get money in by credit card than coinbase, I'd use coinbase if coming from a bank.

Bittrex is the exchange I recommend, and they have a lot of currencies. Poloniex is ok, it's big but slightly fewer currencies, I don't like the interface as well. Kraken is a bit better interface, but way fewer currencies. C-CEX has a reputation for scamminess and running questionable currencies, I'd stay away.


I've found that Gemini (https://gemini.com) is the best alternative. You'll see it as most recommendations for alts against Coinbase.


They only seem to support the same currencies as CoinBase.


I like Kraken myself. If you are interested in a lot of altcoins, try Poloniex, although they haven't got the best reputation.


Take a look at http://coingenius.io/exchanges I recommend looking at bittrex, Bitshares DEX, and Kraken although Kraken has been experiencing hiccups lately.


Poloniex is one of the largest. They don't even deal in fiat.

But as with all things crypto, buyer beware. If you aren't day- trading never keep your money on an exchange.


OpenLedger.io has a good exchange,including tokens that are pegged assets to USD and EU


Bittrex.com is the best I've found.


which continent and fiat currency?


Asia/INR


Well written article and great analysis.


Decent SQL skills for an intern, but I don't really see any "analysis" here. As someone who's been buying and following cryptocurrencies intently for the past few months, I can confidently say there's nothing in this article that even a novice investor would be interested in.

The TL;DR is "Prices went up, prices went down. Some more than others." There's nothing actionable in that.

And a lot of the currencies in your dataset have basically zero volume. AMIS -- your "most profit in a day" -- appears to have a 24h volume < $1,000 and isn't even traded on a single major exchange. Again, that information serves no purpose, and coins like that should probably be excluded as outliers. The fact that they were not only included but highlighted tells me that the author knows nothing about the market they're attempting to analyze.

This looks more like clickbait / advertising, to be honest. "Hey, we need someone to write an article on cryptocurrencies because it's a hot topic. Just give me 2,500 words and a few graphs ASAP. Doesn't matter if it's relevant."


There is value in disseminating the information. If you are "buying and following cryptocurrencies intently for the past few months, I can confidently say there's nothing in this article that even a novice investor would be interested in" then please submit the links to your analyses, your data, and your reports so we can learn from your infinite wisdom.


Do I need to be a Michelin Star chef to point out a turd sandwich?


Are thousands of people enjoying that sandwich? If yes, then you need to backup your claim of "turd sandwich".


Agree with you, but your comment could be more constructive.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: