All Users NFT Bridges

freemartianAll Users NFT Bridges

Updated 12 minutes ago

with

dune_data AS (

SELECT live.udf_api(

'https://api.dune.com/api/v1/query/4930489/results?api_key={dune_key}',

'APIs'

) AS response

flatten_dune_data AS (

SELECT * FROM dune_data, lateral FLATTEN (input => response:data:result:rows)

datas as (

-- ============ honey comb ============

-- Gateway: '0x33a76173680427CBa3ffC3A625B7bC43B08ce0c5'

-- nft address: '0xcb0477d1af5b8b05795d89d59f4667b59eae9244'

select

block_timestamp,

tx_hash,

contract_address,

origin_from_address as user,

contract_name,

utils.udf_hex_to_int(topic_3) as nft_id,

'Ethereum' as chain

from ethereum.core.ez_decoded_event_logs

where origin_to_address = '0x33a76173680427cba3ffc3a625b7bc43b08ce0c5'

and contract_address = '0xcb0477d1af5b8b05795d89d59f4667b59eae9244'

and event_name = 'Transfer'

and tx_succeeded and block_timestamp::date >= '2025-01-01'

-- ================================================

union all

Last run: 12 minutes agoAuto-refreshes every 1 hour

	USER	TOTAL_NFTS	Honey Comb	Honey Jar Gen1	Honey Jar Gen2 - Enigma Key	Honey Jar Gen4 - Triskelion Key	Honey Jar Gen5 - Hivelexicon Key	Honey Jar Gen6 - Colony Key
1	0x7bfee91193d9df2ac0bfe90191d40f23c773c060	782	491	149	35	35	35	37
2	0x69a60ff8e7e6beecf11253867551fea9018075a5	392	65	67	65	65	65	65
3	0xedc4b084686ac3c32179334618195ff26596eab9	294	36	50	52	52	52	52
4	0x60559b4cc92292b589ded75295f5331adcc69e04	267	145	27	23	24	24	24
5	0xc6e5c042b34a0b88df9d4fa00849ba8ecfad1894	212	32	36	36	36	36	36
6	0x9154d0ba26b7c98b18b3daf3c7af3d5c18bcf113	195	33	34	32	32	32	32
7	0x0b0a6c36ad7f696a41f7de287eeb390f6167d339	177	44	36	24	24	24	25
8	0xc1fa63bd4189a9c49a30010b6a3ab11194a95842	145	40	21	21	21	21	21
9	0x335750d1a6148329c3e2bcd18671cd594d383f9b	136	50	26	15	15	15	15
10	0x20c6f73a8f39cba0597b8bba1073cd515e4d7edf	133	23	22	22	22	22	22
11	0x1eb7d411f416946e33d9856bbf00d5886a6c3a66	128	18	22	22	22	22	22
12	0xf8ab77507e7b3044d4cc53952d94660924e272c1	120	50	14	14	14	14	14
13	0xa0eb44b173af64f2fdb47c7d76ff3a33e04103b6	105	50	10	10	10	13	12
14	0x5286bc17220d51a36e55f5664d63a61bf9b127a6	104	20	17	17	17	17	16
15	0x8973afd9566c4c306f97890dc0d092608c0ba31f	100	100	0	0	0	0	0
16	0x29a031f1f19a04f341bc941fc84c093f22334a9c	97	29	25	11	10	10	12
17	0x1bc3e2c44e0b2dabb1b06a1890273571825d3e03	91	61	6	6	6	6	6
18	0x8717e37b8507039952fd12c195a8c3a628cd341a	88	33	11	11	11	11	11
19	0x6ffbb6c376d0cf590289671d652ae92213614828	87	57	6	6	6	6	6
20	0xaf6193fd81b4c8435e6e81c45ee7cdc511fe5f3a	87	12	14	13	12	24	12

...

3470

214KB

66s

flipside