Go to file
Carlos R. Mercado 1108258d02 UPDATE README
2023-01-13 09:37:35 -05:00
airdrop_files USE bonk-review_labeled_discrepancy.xlsx 2023-01-06 16:16:44 -05:00
renv UPDATE README 2023-01-13 09:37:35 -05:00
.gitattributes Initial commit 2023-01-05 08:14:39 -05:00
.gitignore Add Post Mortem 2023-01-10 11:39:52 -05:00
.Rprofile UPDATE README 2023-01-13 09:37:35 -05:00
bonk_review_labeled_discrepancy.xlsx little cleanups 2023-01-06 16:48:03 -05:00
bonk_review_labeled.csv little cleanups 2023-01-06 16:48:03 -05:00
bonk-post-mortem.Rmd Add Post Mortem 2023-01-10 11:39:52 -05:00
dev_name_swap.csv USE bonk-review_labeled_discrepancy.xlsx 2023-01-06 16:16:44 -05:00
discrepancy.csv USE bonk-review_labeled_discrepancy.xlsx 2023-01-06 16:16:44 -05:00
FLIPSIDE-BRAND-1-BLACK.png Add Post Mortem 2023-01-10 11:39:52 -05:00
FLIPSIDE-BRAND-1-WHITE.png Add Post Mortem 2023-01-10 11:39:52 -05:00
LICENSE Initial commit 2023-01-05 08:14:39 -05:00
named_count_vs_actual.csv USE bonk-review_labeled_discrepancy.xlsx 2023-01-06 16:16:44 -05:00
nft_qualifier_nonunique_address.csv little cleanups 2023-01-06 16:48:03 -05:00
README.md UPDATE README 2023-01-13 09:37:35 -05:00
renv.lock UPDATE README 2023-01-13 09:37:35 -05:00
sol_bonk_airdrop_review.R little cleanups 2023-01-06 16:48:03 -05:00
SOL-BONK-REVIEW.Rproj Files 2023-01-05 08:32:18 -05:00
styles.css Add Post Mortem 2023-01-10 11:39:52 -05:00

Topic: Solana BONK token airdrop post-mortem.

BONK is Solana's latest DOGE-style meme token. During the airdrop to 10,000s of addresses, some transactions unfortunately failed. Flipside Crypto's Data Science team supported the BONK team in reproducing their snapshots and identifying addresses that did not receive their intended BONK.

This repo holds all the code behind the post-mortem. For a deeper dive into the context, you can check out the report on our research site at bonk-post-mortem.

If you aren't interested in code and want the shortest summary of the situation, you can check out the email sized bonk-post-mortem on our research beehiiv and subscribe to get (summaries of) the best crypto research direct to your inbox.

Reproduce Analysis

All analysis is reproducible using the R programming language. You'll need (1) an shroomDK API key to copy our SQL queries and extract data from the FlipsideCrypto data app; and (2) renv to get the exact package versions we used.

shroomDK

shroomDK is an R package that accesses the FlipsideCrypto REST API; it is also available for Python. You pass SQL code as a string to our API and get up to 1M rows of data back!

Check out the documentation and get your free API Key today.

renv

renv is a package manager for the R programming language. It ensures analysis is fully reproducible by tracking the exact package versions used in the analysis.

install.packages('renv')

Instructions

To replicate this analysis please do the following:

  1. Clone this repo.
  2. Save your API key into a .txt file as 'api_key.txt' (this exact naming allows the provided .gitignore to ignore your key and keep it off github).
  3. Open the SOL-BONK-REVIEW R Project file in your R IDE (we recommend, RStudio).
  4. Confirm you have renv installed.
  5. Restore the R environment using renv::restore() while in the SOL-BONK-REVIEW R Project.
  6. You can now run sol_bonk_airdrop_review.R and/or bonk-post-mortem.Rmd.

If any errors arise, double check you have saved your API key in the expected file name and format.