carsonbrownUntitled Query
Updated 2022-09-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
-- 0x8e19899e = WITHDRAW
-- 0xd5eed868 = borrow
-- 0xa415bcad = Borrow (detailed)
-- 0x42b0b77c = Flash Loan
-- 0x69328dec = Withdraw Detailed
with transfers AS (
SELECT TX_HASH, ORIGIN_FUNCTION_SIGNATURE, ORIGIN_FROM_ADDRESS, ORIGIN_TO_ADDRESS, TO_ADDRESS, RAW_AMOUNT / POW(10,18)
FROM optimism.core.fact_token_transfers
WHERE FROM_ADDRESS = LOWER('0x82E64f49Ed5EC1bC6e43DAD4FC8Af9bb3A2312EE')
AND ORIGIN_TO_ADDRESS = '0x794a61358d6845594f94dc1db02a252b5b4814ad'
)
SELECT * FROM transfers
-- SELECT ORIGIN_FUNCTION_SIGNATURE, COUNT(*)
-- FROM transfers
-- GROUP BY ORIGIN_FUNCTION_SIGNATURE
Run a query to Download Data