GEN_KONGZ_HOLDER | GEN_KONGZ_HELD | |
|---|---|---|
1 | 0xf2d2346935ea48048d2af23bd7f9de6fa6899df3 | 1 |
2 | 0x73e4a2b60cf48e8baf2b777e175a5b1e4d0c2d8f | 1 |
3 | 0xcaace51e89e7ba99522b43e31f72cc3b7be213f3 | 1 |
4 | 0x8cf20bf7ecbb1d253c5b9bb3b5451ec3bab83c75 | 1 |
5 | 0x7c88df0fc154d7cfd19489e948775195a5649058 | 1 |
6 | 0x8a167428f3c5124293a6d1b80141b27c66360cab | 1 |
7 | 0x545ce9efb15d264ab7416e935051a2d09f083b82 | 1 |
8 | 0x1b6fbff5acac492b995a9e97b60e69c37c932bb5 | 1 |
9 | 0x0d932eb22c1e68b2209b01181e5bfd7a7faa3088 | 1 |
10 | 0x15f7320adb990020956d29edb6ba17f3d468001e | 1 |
11 | 0x7afc3d65e4e3bbedb76cb326ee9c7117070b12da | 1 |
12 | 0xcf3a0215446f39e77099db25015489e96159e7bd | 1 |
13 | 0x7f19c7da5fa56ee87c71e62072b361fe8460c3d1 | 1 |
14 | 0x10472fea972d9dde0c7ef98bd81209a4e4d13277 | 1 |
15 | 0xd266d61ac22c2a2ac2dd832e79c14ea152c998d6 | 1 |
16 | 0x668e961736454a2444adb485340cb7f0844ddd3d | 1 |
17 | 0x6ac2db5b98d72a7f40be3dd1e36a6a806b0cd287 | 1 |
18 | 0xee903f65cffb0834994871df856591dbc21b5883 | 1 |
19 | 0x2ea4889df9d2d8dd1a96d7db2b51dcb9b7a85172 | 1 |
20 | 0x381294090348573e2a679f51149a8fc151c7665b | 1 |
banterlyticsgen-kongz holder list
Updated 6 hours ago
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
›
⌄
-- forked from gen-kongz-tree @ https://flipsidecrypto.xyz/studio/queries/b231af71-10ec-4c4b-843c-219a425b6454
with all_tx as (
select
date_trunc('day', block_timestamp :: date) as dt,
tx_hash,
decoded_log:to :: string as event_to,
decoded_log:from :: string as event_from,
decoded_log:tokenId :: string as token_id
from
ethereum.core.fact_decoded_event_logs
where
contract_address = lower('0x57a204aa1042f6e66dd7730813f4024114d74f37')
and event_name = 'Transfer'
and block_timestamp > '2021-01-05'
and decoded_log:tokenId :: string < 1000
),
transfers as (
(
SELECT
event_to as wallet,
dt,
'mint' as action,
1 as value
FROM
all_tx
where
event_from = '0x0000000000000000000000000000000000000000'
)
union
all (
SELECT
event_to as wallet,
dt,
'gain' as action,
1 as value
FROM
Last run: about 6 hours agoAuto-refreshes every 6 hours
...
491
24KB
40s