My publication series I will turn into a book

Photo by Aziz Acharki on Unsplash

I don’t have nearly enough life experience to pass on complete wisdom, but I do believe I’ve built up a strong foundation of mental frameworks through my experience in dance, finance, data, and crypto.

When I was 5, I wanted to be an astronaut. At 10, a biologist. At 13, a bodybuilder. By 17, a psychologist. Approaching 19, a Nobel prize-winning economist. Around 20, on a trading desk. Recently at 22, a data scientist. Right now, I want to make sure I write at least two books in the course of my life.

What changed? My methodology behind discovery and…


Trade and hedge future income.

This was first published on substack, make sure to follow 0xkowloon on twitter and substack for more comprehensive protocol deep dives. Keep an eye out for Element.fi and another SQL analysis of both protocols coming soon!

Pendle is a protocol that enables the trading of tokenized future yield on an AMM system. It builds on top of first-degree DeFi protocols including Aave and Compound. DeFi users who hold yield-bearing tokens from Aave and Compound can deposit them into Pendle, which in return mints ownership tokens (OT) and yield tokens (YT). Yield tokens can be immediately sold for USDC in Pendle’s…


HANDS-ON TUTORIALS

Let’s look at the contracts and queries for the total value locked and user profits of Barnbridge, a credit tranche protocol.

Photo by Loic Leray on Unsplash

I’m going to create more bite-sized query breakdowns while explaining basic concepts in Ethereum, this is a continuation of the beginner and intermediate guides I wrote.

This article is written in partnership with my friend 0xKowloon, please go and check out his deep dive on the solidity architecture of BarnBridge to get a better understanding of the ins-and-outs of the protocol.

We’ve looked at Aave before, where you have to deposit some amount of collateral in one asset (like ETH) to borrow 75% of the value deposited in another asset (like USDC). …


Trade with gas efficiency!

This was first published on substack, make sure to follow 0xkowloon for more protocol deep dives.

Balancer protocol is an automated portfolio manager, liquidity provider and price sensor. Liquidity providers who want to earn trading fees and rebalance their portfolios can deposit their assets into a balancer pool. Arbitrageurs help liquidity providers to rebalance their portfolios by trading against the pools’ assets.

Contrary to Uniswap, which only holds two tokens in each pool, a balancer pool can hold up to eight tokens. A pool’s underlying token weights and trading fees are set when it is initialized. The pool’s weights are…


Understand the history of Ethereum wallets, what Access Legos are, and the implications of both on the future of dapp development and usability.

I’ve talked about product composability of decentralized applications (dapps) before, but with a fairly simplified diagram of the tech stack:

In reality, there are two layers I skipped (wallets and SDKs) and some added complexity with multi-chain (layer) dapps:


Stop trying to approach people on LinkedIn; you need to understand the structure of content, conversation, and community.

Asking people about networking looks like this. It all sounds like common sense, but most people have a chaotic or non-actionable approach to it. Let me try and help you make it more organized and actionable.

Networking is an exciting topic that has changed wildly over the years, especially during Covid-19. It used to mean getting someone’s business card, then in the digital world, that card became represented by a connection or a follow.

We’ve distilled networking down so much that having a point or signifier of contact seems good enough — but that won’t cut it anymore.

Networking is an iterative process where we slowly develop our own approach, but general frameworks make learning the process easier. …


Photo by israel palacio on Unsplash

Hands-On Tutorials

Let’s make your queries more efficient and readable, and also help you understand decentralized exchanges like Uniswap on Ethereum.

If you’ve missed part one of the basics of SQL and Ethereum, be sure to read that first. On the SQL side, today we’ll cover these slightly harder topics:

  1. Common Table Expressions (CTEs)
  2. Self joins
  3. Window functions like PARTITION, LEAD, LAG, NTILE
  4. Use of indexes in querying to make operations faster.
  5. Subqueries and the impact of subqueries on the efficiency of the query

On the Ethereum side, last time we learned about lending pools and collateralized debt positions. This time, I’m going to introduce you to a decentralized exchange (DEX) — think of this as a foreign exchange where you…


Photo by NASA on Unsplash

Overlaying a digital world right on top of our physical one has historically been difficult due to GPS inaccuracy and localization.

An intro to Augmented Reality

Broadly speaking, there are two types of augmented reality (AR) created and subsequently used by everyday consumers.

The first type is AR which detects objects in your vicinity to spawn digital objects/world from. This can be anything from plane detection to image targets, where you’ve set parameters on how game objects can be spawned after detection criteria are met.


Photo by Gia Oris on Unsplash

Hands-On Tutorials

Turns out Ethereum can be an amazing relational database to learn and practice SQL queries off of!

Ethereum is easier to understand when you learn how data is stored and managed on smart contracts, and SQL is easier to learn when you have more than just the simple two or three basic data tables to query off of.

By the end of this article, you’ll understand the basics of Ethereum, as well as the following SQL functions:

  • SELECT, WHERE, LIMIT
  • SUM, COUNT, MAX, GROUP BY, HAVING
  • DISTINCT, COUNT DISTINCT
  • JOIN
  • Time conversions/parsing (DATE_TRUNC, Interval)
  • UNION and UNION ALL

I’ll be doing an intermediate and advanced SQL/Ethereum guide as well, so be sure to follow me if you’re…


This is a non-technical intro to crypto products and community alignment, not an explainer of the new technology or its asset valuations.

A Lego community, it’ll make more sense later. (Photo by James Orr on Unsplash)

I know the article title is a very strong statement to lead with, but over the last few years I have witnessed and personally experienced how building products and businesses in crypto (namely on Ethereum) is unlike anything else I’ve ever seen. Technically, decentralized applications (dApps) or decentralized finance (DeFi) are the best examples of everything I’m going to discuss — otherwise called Web 3.0. Don’t worry if you have no idea what that is, I’ll build up to it in a non-technical fashion.

Also, my point here is not to say crypto is perfect (it’s still far from it)…

Andrew Hong

Trying to provide some structure to our world. @andrewhong5297 on twitter and github, https://www.linkedin.com/in/andrew-hong-nyc/

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store