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…

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:

  • JOIN
  • Time conversions/parsing (DATE_TRUNC, Interval)

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)…

Web Scraping and Data Visualization

Basic web scraping with Selenium and BeautifulSoup4 to identify trends in how Bridgewater is investing.

I’m sure I’m not the first to tell you this, but there is a treasure trove of data online for you to use to help answer any questions you might have. For example, what if we were curious how some of the smartest minds in Finance were navigating the last ten years of equity markets in the U.S.? Bridgewater is a perfect example of this, and luckily for us they are mandated to publicly document the name and size of their holdings in a quarterly SEC report dubbed 13F-HR.

The Securities and Exchange Commission’s (SEC) Form 13F is a quarterly…

Chainlink on Ethereum

In this article, I will cover how my team set up dog walking data on MongoDB Atlas, exposed a GraphQL authenticated endpoint with Realm, and created a Chainlink External Adapter to get that data onto Ethereum Smart Contracts.

Photo by Feifei Peng on Unsplash

Last week, my team finished developing and submitting our MarketMake 2021 product FidoByte — a tokenized shelter-dog walking protocol. One of the most difficult parts of this project was figuring out how to manage a flexible database both on and off chain.

In this article, I want to show how data flows through our project and how you can replicate the same architecture.

Building a risk assessment framework with an interactive Plotly Dash app, natural language processing, statistics, and a lot of climate science.

Photo by Jonathan Ford on Unsplash

With climate change and climate risks moving to the forefront of the conversation in almost every industry, it’s more important now than ever to understand where we are today and what trajectory we are heading on. In this article, I want to focus on flooding specifically in three parts:

  1. What are the risks and causes of flooding and what are the impacts?
  2. What could an assessment framework look like, one that is generalized enough to be helpful for anyone?
  3. How can we fill the framework using data of any type from states along the U.S. …

Being tech forward as a credit analyst at a top investment bank has taught me a lot about bridging two fundamentally different learning curves.

All images except this first one are by the author.

Photo by Anders Jildén on Unsplash

If you work in technology, you likely see finance as just markets — where people try too hard to make “spreads wider” by 0.01%. And if you work in finance, you probably see technology as just a tool — where anything that doesn’t have a clear UI is too technical and the command line is never to be touched. While both are equal in terms of complexity, I’ve found it’s usually harder to convince someone in finance to pick up coding skills compared to the other way around. It’s easy…

Andrew Hong

Trying to provide some structure to our world. @andrewhong5297 on twitter and github,

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