zakkisyedNear Scavenger Hunt
Updated 2022-07-13
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select *
from flipside_prod_db.mdao_near.transactions
where TXN_HASH = '7M7qUGS2X99NQT7uWx9vso8Dak3ETSvWhZbaianvbMDw' -- funding near wall
or TXN_HASH = 'Bo36JybpDMRHSRgiDahwNhhMiBzrC4xq6Fer6Mpc2vrx' -- wrapping near
or TXN_HASH = '2BFKXqLZv1bLz4CAuzKKUdfHUa3CyAzz4CCd3EPzLbCD' --swap wnear to usn
and block_timestamp >= current_date-2
--explorer link https://explorer.near.org/transactions/7M7qUGS2X99NQT7uWx9vso8Dak3ETSvWhZbaianvbMDw (binance to Near)
-- https://nearblocks.io/txns/Bo36JybpDMRHSRgiDahwNhhMiBzrC4xq6Fer6Mpc2vrx (wrap near)
-- https://nearblocks.io/txns/2BFKXqLZv1bLz4CAuzKKUdfHUa3CyAzz4CCd3EPzLbCD (swap wnear to USN)
Run a query to Download Data