adriaparcerisasFlowfrogs Holdings List
Updated 2024-05-01
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
›
⌄
with
info as (
select
distinct event_data:id as flowfrog,
event_data:to as holder,
block_timestamp
from flow.core.fact_events
where tx_id in (
SELECT
tx_id
from flow.core.fact_events x
--join prices y on trunc(block_timestamp,'hour')=hour
where event_contract='A.4eb8a10cb9f87357.NFTStorefrontV2'
and event_type='ListingCompleted' and event_data:customID='flowverse-nft-marketplace'
and event_data:purchased='true' and event_data:nftType ilike '%A.9212a87501a8a6a2.Ordinal.NFT%'
and to_number(event_data:nftID)>=2453 and to_number(event_data:nftID) not in (2473,2530,2531,2587,2588,2589,2622,2623,2624,2625,2662)
)
),
info2 as (
SELECT
distinct flowfrog,
max(block_timestamp) as last_trade
from info
group by 1
)
SELECT
info2.flowfrog as "Flowfrog", last_trade as "Last Trade", holder as "Holder"
from info2 join info on info2.last_trade=info.block_timestamp and info2.flowfrog=info.flowfrog
having holder is not null
order by info2.flowfrog asc
QueryRunArchived: QueryRun has been archived