lukekim

https://docs.google.com/presentation/d/1wRlh3nhQgsP6Tey5KYivmybN0SqgjPvF

lukekim

-- Given an Ethereum wallet address, return all of the transactions where that wallet address deployed an NFT (ERC721 or ERC1155) contract
WITH address_tx AS (
    SELECT "hash", from_address, receipt_contract_address, block_number
    FROM eth.transactions
    WHERE from_address = '0x5d307b9fd27cded1e0f72ede3c0b3269b603bdf0'
)

SELECT t.block_number, t."hash", t.from_address, t.receipt_contract_address
FROM address_tx t
INNER JOIN eth.nft_contracts nft

lukekim

"use strict"

import {
  UrlJsonRpcProvider,
  showThrottleMessage,
} from "@ethersproject/providers"

import { Logger } from "@ethersproject/logger"
const logger = new Logger("providers/5.5.1")

lukekim

curl --request POST \
  --url https://data.spiceai.io/eth/v0.1/sql \
  --header 'Content-Type: text/plain' \
  --data 'SELECT * FROM blocks ORDER BY number DESC LIMIT 500

lukekim

Get MAC address

ifconfig en0 | grep ether

Set MAC address

sudo ifconfig en0 ether MAC

lukekim

Keybase proof

I hereby claim:

• I am lukekim on github.
• I am lukekim (https://keybase.io/lukekim) on keybase.
• I have a public key ASDRWlrHmqVbDCgX5dcXrj1QyE8FP76nTAil2TVZv9aVyAo

To claim this, I am signing this object: