CryptoIcicleNear-Report-Weekly - NEAR -> Ethereum
Updated 2023-01-14
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- Pay by Quality Your score determines your final payout.
-- Grand Prize 35.489 NEAR (A score of 11 or 12 earns you a Grand Prize title)
-- Payout 23.659 NEAR
-- Score Multiplier 0-7 : 0% 8 : 50% 9 : 75% 10 : 100% 11 : 125% 12 : 150%
-- Payout Network Near
-- Level Intermediate
-- Difficulty Hard
-- It’s autumn in the Northern Hemisphere. What season is it in the City of NEAR?
-- Pick one of the districts from the NEAR Tournament and review how activity there has changed over the past 90 days.
-- What has changed? What trends can you spot? Is it truly “winter” in your chosen “district” or area (NFTs, DeFi, etc.)?
-- Grand Prize questions (11 or 12) will go deeper into the why - what is driving any of these changes?
-- BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
-- SQL Credit https://app.flipsidecrypto.com/velocity/queries/1d4b4746-da57-4448-a41f-d5a87f22671a
-- Dashbord: https://app.flipsidecrypto.com/dashboard/near-citizens-fQRyBU
with bridge_ERC20_from_near_to_ethereum as (
select block_timestamp::date as date, tx_hash::string as tx_hash, (parse_json(trim(args))):amount as asset_amount, (parse_json(args)):recipient as eth_address
from near.core.fact_actions_events_function_call
where action_name = 'FunctionCall'
and method_name = 'withdraw' -- ERC20 tokens
and args::string like '{"%'
and (parse_json(trim(args))):amount::string is not null
and (parse_json(trim(args))):recipient::string is not null
), bridge_NEAR_from_near_to_ethereum as (
select block_timestamp::date as date, tx_hash::string as tx_hash, deposit as asset_amount, (parse_json(args)):eth_recipient as eth_address
from near.core.fact_actions_events_function_call
where action_name = 'FunctionCall'
and method_name = 'migrate_to_ethereum' -- NEAR
and args::string like '{"%'
and (parse_json(args)):eth_recipient is not null
), bridge_all_from_near_to_ethereum as (
select * from bridge_ERC20_from_near_to_ethereum
union all
select * from bridge_NEAR_from_near_to_ethereum
), join_with_txs as (
Run a query to Download Data