热门标签 | HotTags
当前位置:  开发笔记 > 编程语言 > 正文

5MillionRowsofDataRecap:InvestigatingTheCryptoMarket’s3YearBullRun@LUCIDA

Betweenlate2020and2021,theentirecryptocurrencymarkethasexperiencedsustainedperiodsof

Between late 2020 and 2021, the entire cryptocurrency market has experienced sustained periods of upward movement and several bull cycles. As a result, investors made exponential profits up to 1000x, 10000x, and even more. However, since November 2021, when Bitcoin recorded its all-time high, the market has been bearish, massively ripping into profits and even the equity of investors.

LUCIDA is a quantitative crypto hedge fund in the cryptocurrency market.Crypto crashes are almost always predictable because price patterns obey history. However, you may not know the correct analysis to make as an investor if you cannot effectively research history. LUCIDA seeks to solve this problem by digging through data, combing through history, and discovering rules that the market obeys.

This article, “5 million rows of data recap,” is the first of many series that seeks to research cryptocurrency’s history through the bull run to provide adequate investment insights for the future.

Data acquisition and preprocessing

The research included a quantitative analysis of the performance of the top 3,000 coins by market capitalization during the last bull run (From January 1, 2020, to May 24, 2022).

the top 3,000 coins data from coinmarketcap

The data was obtained from coinmarketcap, and information gotten includes: the date, open price, close price, high price, low price, volume, and market capitalization. This raw data was processed and analyzed before reaching conclusions based on the results gotten.

For subsequent analysis, we preprocessed the data, including:


  • Modifying outliers’ values

  • Filling in empty values

  • Removing stablecoin assets

  • Removing anchored assets such as wBTC and renBTC

  • Removing assets that were largely pinned due to poor market depth

  • Removing currencies with too small market value and too low liquidity (mainly outside the top-1000 market cap ranks)

  • NFT assets were not accounted for

After preprocessing the data, only 952 coins meet the standards for statistical analysis.

The highest Increase is 960,000 times !!!

top 100 currencies with the highest increase in the bull

Looking at the top 100 currencies with the highest increase, the most significant increase was Shiba Inu, with an increase of 96482030.32% (we have counted the order of magnitude, yes, 960,000 times! ), and the current market value ranks 19th.

Don’t just buy anything in Bull Markets: Not everything will outperform the market

From the data, we calculated the median of the largest increase to be 2002.23%, while Bitcoin’s return during this period was 1259.27%.

Using BTC as a comparison index, we can conclude that the Alpha return is 2002.23% and the beta return is 1259.27%; hence, we can see that the Alpha only mildly outperforms the beta return. This means that a lot of altcoins will perform below the index (Bitcoin).

Therefore, it is a misconception to think that “any coin can outperform the broader market during a bull run” because, from the data above, it is evident that many smaller cap coins will not outperform the index coin (BTC). Hence, if currency selection and timing aren’t made well, the income on altcoins may not be as profitable as holding Bitcoin.

Can’t time your entry into Altcoins? Watch Bitcoin

Next, from the data, we calculated the “start time,” “end time,” and “duration” of the maximum increase period of all cryptocurrencies. This helps us to know the perfect entry/exit for altcoins by identifying “when to buy the bottom” and “when to sell at peak prices.”

The above picture shows the “frequency of the start time during the maximum increase period.” The x and y-axes represent time and frequency, respectively; the bars in the chart indicate the bottom period of these currencies. The lowest periods of the cryptocurrencies were concentrated in March 2020 and July 2021, after the “312” and “519’ plummet.

The second picture indicates the “frequency of the end during the maximum increase period.” The x and y-axes represent time and frequency, respectively; the bars in the chart indicate the peak period of these currencies. Most of these cryptocurrencies peaked around April 2021 and November 2021, which coincides with the peak times of Bitcoin.

two peaks of bitcoin

Hence, considering the numbers, it is safe to say that Altcoins rarely move independently; instead, they follow the trend of the index – Bitcoin. Hence, if you are not sure of altcoin trends, it is better to analyze Bitcoin before making a judgment call.

Time is the best friend of high profits

Next, the time interval frequency during the maximum increase period is analyzed. This is done by checking the times when the highest and lowest prices appear before counting frequency.

From the data, we can see that the highest points in the histogram are concentrated around day 20 and day 400, i.e., the peak period of a currency falls between two different categories.

a.      The launch period (within 20 days)

b.      A year after launch (400 days)

Hence, if you want to enjoy the best returns of the bull market, holding a position for over a year may be the most profitable choice.

Be mentally prepared to be trapped or “cut in half.”

After calculating profits, it’s only fair that we calculate the risks involved.

The first metric to calculate is the maximum drawdowns during the bull run, i.e., the largest pullback when the market experienced a maximum increase.

The mean and median maximum drawdowns are 50.63% and 57.02%, respectively. This means that you must be mentally prepared to hold your positions amid crazy losses in a bull market.

Also, the median drawdown period was 31 days, the mean was 43 days, and the longest maximum drawdown period was 322 days. Hence, we can see that even in the best bull runs (3 years in this case), you can be trapped for over a month on average, and you may even be trapped for a year in extreme cases.

When Bitcoin trades sideways at a high level, it is a signal for investors to buy the lows and sell the highs of altcoins and lighten their overall positions.

Still calculating risks, we will estimate the periods where the biggest drawdowns usually occur. The chart below shows the frequency of the largest drawdown, which peaked in August 2020 and February-April 2021.

During these periods, the trend of the index coin (Bitcoin) showed a high level of sideways movement (stagnation); hence, this signifies that when Bitcoin moves sideways at a high level, then altcoins will vastly experience drawdowns due to their higher rate of volatility.

You should sell if a new high is created after a high-level giant shake or a flashback happens before a bearish reversal.

The maximum drawdowns period doesn’t signify the end of the bull run. From the data above, the first bull run ended in April 2021, two months after the largest drawdowns ended in February 2021.

However, the new highs recorded after the February dip weren’t sufficient to hold the market, and the bull run ended shortly after – within two months.

Conclusion and Summary

We have analyzed the last bull market within the last three years from the perspectives of “risk and reward.” From the data, we have gotten several insights, some of which align with existing sentiments and some which reorient our understanding of the crypto market.

Hence, analyzing these 5 million rows of crypto market data will help us understand the market from a more objective and higher latitude perspective.

This research is holistic, covering the entire cryptocurrency market; however, as a part of this series, we will write more research reports to give adequate insights into secondary market investment and data, which includes:


  • Analysis of different aspects, including underlying infrastructure, NFTs, DeFi, SocialFi, GameFi, DAOs, and research on rotation laws

  • Analyzing different ecosystems, including Ethereum, Polkadot, Solana, etc.

  • Analyzing altcoin strategy (multi-factor currency selection, entry and timing strategy, enhancement and hedging strategies)

  • Performance analysis of investment institutions

If you are interested in any of the topics above and want to be a part of our research, please send an email to contactus@lucida.onexmail.com. Also, you can reach us on the same email for business collaboration, data acquisition, and content reprinting.

Please indicate the purpose for reaching out as the email title; thank you.

About LUCIDA

LUCIDA is a quantitative crypto hedge fund located in the Cayman Islands. LUCIDA entered the crypto market in April 2018 with massive investments in the secondary market; we are mainly engaged in CTA, statistical arbitrage, options, and other financial derivatives strategies. Also, LUCIDA provides financial management services for high-net-worth clients, and we release in-depth investment research reports from time to time.

Contact info: contactus@lucida.onexmail.com

Twitter: @ZnQ_626、@lucidafund


推荐阅读
  • [转]doc,ppt,xls文件格式转PDF格式http:blog.csdn.netlee353086articledetails7920355确实好用。需要注意的是#import ... [详细]
  • 本文详细介绍了MySQL数据库的基础语法与核心操作,涵盖从基础概念到具体应用的多个方面。首先,文章从基础知识入手,逐步深入到创建和修改数据表的操作。接着,详细讲解了如何进行数据的插入、更新与删除。在查询部分,不仅介绍了DISTINCT和LIMIT的使用方法,还探讨了排序、过滤和通配符的应用。此外,文章还涵盖了计算字段以及多种函数的使用,包括文本处理、日期和时间处理及数值处理等。通过这些内容,读者可以全面掌握MySQL数据库的核心操作技巧。 ... [详细]
  • 深入解析C语言中结构体的内存对齐机制及其优化方法
    为了提高CPU访问效率,C语言中的结构体成员在内存中遵循特定的对齐规则。本文详细解析了这些对齐机制,并探讨了如何通过合理的布局和编译器选项来优化结构体的内存使用,从而提升程序性能。 ... [详细]
  • Android 构建基础流程详解
    Android 构建基础流程详解 ... [详细]
  • 本文详细解析了使用C++实现的键盘输入记录程序的源代码,该程序在Windows应用程序开发中具有很高的实用价值。键盘记录功能不仅在远程控制软件中广泛应用,还为开发者提供了强大的调试和监控工具。通过具体实例,本文深入探讨了C++键盘记录程序的设计与实现,适合需要相关技术的开发者参考。 ... [详细]
  • 当使用 `new` 表达式(即通过 `new` 动态创建对象)时,会发生两件事:首先,内存被分配用于存储新对象;其次,该对象的构造函数被调用以初始化对象。为了确保资源管理的一致性和避免内存泄漏,建议在使用 `new` 和 `delete` 时保持形式一致。例如,如果使用 `new[]` 分配数组,则应使用 `delete[]` 来释放内存;同样,如果使用 `new` 分配单个对象,则应使用 `delete` 来释放内存。这种一致性有助于防止常见的编程错误,提高代码的健壮性和可维护性。 ... [详细]
  • 本文详细介绍了 PHP 中对象的生命周期、内存管理和魔术方法的使用,包括对象的自动销毁、析构函数的作用以及各种魔术方法的具体应用场景。 ... [详细]
  • 检查在所有可能的“?”替换中,给定的二进制字符串中是否出现子字符串“10”带 1 或 0 ... [详细]
  • poj 3352 Road Construction ... [详细]
  • 开机自启动的几种方式
    0x01快速自启动目录快速启动目录自启动方式源于Windows中的一个目录,这个目录一般叫启动或者Startup。位于该目录下的PE文件会在开机后进行自启动 ... [详细]
  • 本文介绍了一种在ANSI C中动态分配二维数组的方法。通过创建指针数组并为每个指针分配连续空间,可以灵活地管理内存。文章还讨论了一些常见的错误和注意事项。 ... [详细]
  • 详解 Qt 串口通信程序全程图文 (4)
    Qt串口通信程序全程图文是本文介绍的内容,本文一开始先讲解对程序的改进,在文章最后将要讲解一些重要问题。1、在窗口中加入一些组合框ComboBox&# ... [详细]
  • 如何使用 `org.opencb.opencga.core.results.VariantQueryResult.getSource()` 方法及其代码示例详解 ... [详细]
  • 在C#编程中,数值结果的格式化展示是提高代码可读性和用户体验的重要手段。本文探讨了多种格式化方法和技巧,如使用格式说明符、自定义格式字符串等,以实现对数值结果的精确控制。通过实例演示,展示了如何灵活运用这些技术来满足不同的展示需求。 ... [详细]
  • 在《ChartData类详解》一文中,我们将深入探讨 MPAndroidChart 中的 ChartData 类。本文将详细介绍如何设置图表颜色(Setting Colors)以及如何格式化数据值(Formatting Data Values),通过 ValueFormatter 的使用来提升图表的可读性和美观度。此外,我们还将介绍一些高级配置选项,帮助开发者更好地定制和优化图表展示效果。 ... [详细]
author-avatar
小茜的阳光2011_950
这个家伙很懒,什么也没留下!
PHP1.CN | 中国最专业的PHP中文社区 | DevBox开发工具箱 | json解析格式化 |PHP资讯 | PHP教程 | 数据库技术 | 服务器技术 | 前端开发技术 | PHP框架 | 开发工具 | 在线工具
Copyright © 1998 - 2020 PHP1.CN. All Rights Reserved | 京公网安备 11010802041100号 | 京ICP备19059560号-4 | PHP1.CN 第一PHP社区 版权所有