Pine AnalyticsASC MInt 1 copy
Updated 2024-12-11
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
›
⌄
SELECT
inner_instruction['instructions'][5]['parsed']['info'],
inner_instruction['instructions'][5]['parsed']['info']['source'] as nft_mint,
*
from eclipse.core.fact_events
where tx_id in (
SELECT
tx_id
FROM eclipse.core.fact_transfers
where tx_to like '7jB2kzg5FbuNjETEgjnERfznGMFs7sQ7nhoXcJzwJpxj'
and block_timestamp > '2024-11-20'
and mint like 'Eth1111111111111111111111111111111111111111'
and amount = 40000000
AND SUCCEEDED
--LIMIT 100
GROUP BY 1
order by 1 DESC
)
--and not mint like 'Eth1111111111111111111111111111111111111111'
and program_id like 'RariUNM3vz1rwxPg8UJyRAN7rSKXxgd2ncS2ddCa4ZE'
--and tx_id like '3YW6oTPHXZGRVidvdVJMbG91CraanGFDcdcHs6khWxkmkkktPRvvY8aruJhJuKxPGRscpyB4LZfvWbHFKKkvfAr9'
LIMIT 100
QueryRunArchived: QueryRun has been archived