Untitled Query

nitsUntitled Query

Updated 2022-05-12

-- SELECT COUNT(DISTINCT address) as impact from

-- (SELECT address, sum(balance) as amt from terra.daily_balances

-- where date = CURRENT_DATE -4 and currency = 'LUNA'

-- GROUP by 1 )

-- where amt > 10

-- SELECT COUNT(DISTINCT user_address)

-- from ethereum.erc20_balances

-- where symbol = 'ETH' and balance_date = CURRENT_DATE -4

-- AND balance > 0.5

-- limit 100

Run a query to Download Data

flipside