rajsGodmode Mint Balance > 0.1
Updated 2022-06-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
SELECT
balance_date,
user_address,
balance
from flipside_prod_db.ethereum.erc20_balances
where user_address IN
(
SELECT
nft_to_address
from flipside_prod_db.ethereum_core.ez_nft_mints
where nft_address = lower('0x903E2F5d42EE23156D548DD46bb84B7873789E44')
and block_timestamp <= '2022-06-07 17:00:00.000'
and mint_price_eth > 0
)
and balance_date = '2022-06-06'
and contract_address = 'ETH'
and balance > 0.1
order by balance desc
-- limit 3
Run a query to Download Data