marqudegods 404 - y00ts bridged back to sol and burned
Updated 2024-09-17
99
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
›
⌄
with
y00t_burns as (
select
block_timestamp
, tx_id
, signers[0] as user_address
, instruction :accounts[11] ::string as mint
from solana.core.fact_events
where succeeded
and program_id = '8avhY6jYWsHMfxxsdcp1rwpW5rGmQCacG8tZbzctQ53e'
and substr(livequery.utils.udf_base58_to_hex(instruction :data), 3, 16) = '4c8f0ab72592f9b3' -- ClaimWithYoot
and block_timestamp > '2024-09-15'
),
bridge_sol_txs as (
select
fact_events.block_timestamp
, fact_events.tx_id
, y00t_burns.mint
from solana.core.fact_events
inner join y00t_burns
on fact_events.instruction :accounts[7] = y00t_burns.mint
where fact_events.succeeded
and fact_events.program_id = '35iLrpYNNR9ygHLcvE1xKFHbHq6paHthrF6wSovdWgGu'
and substr(utils.udf_base58_to_hex(fact_events.instruction :data), 3, 16) = '02601f70a097a1d8' -- ReceiveAndMint
and fact_events.block_timestamp > '2024-04-22'
),
aggregated as (
QueryRunArchived: QueryRun has been archived