flipside

    penguins (with clause)
    Jefferspenguins (with clause)
    Updated 2025-03-02
    with penguins as
    (
    select *
    from ethereum.nft.ez_nft_sales
    WHERE
    nft_address = LOWER('0xBd3531dA5CF5857e7CfAA92426877b022e612cf8') -- pudgy penguins
    AND
    block_timestamp :: date between '2024-01-01' and '2024-12-31'
    )

    select buyer_address, count(distinct token_id) as n_nfts
    from penguins
    GROUP BY buyer_address
    ORDER BY n_nfts DESC
    LIMIT 5;

    Last run: about 2 months ago
    BUYER_ADDRESS
    N_NFTS
    1
    		0x29469395eaf6f95920e59f858042f0e28d98a20b820
    2
    		0xa69833b9fda816f1bfc79517e7932e64708df0dd725
    3
    		0x95ff3f04eccfa15a2bd12d6daf3ccfc5ad354510425
    4
    		0x458dbf62e68463fe0b14c0f8dd69e695d23ca0cb351
    5
    		0x9c731c50fb63ee893121245b58816e212f64df6e299
    5
    256B
    3s