SajjadiiiNew User Onboarding 2
    Updated 2022-06-28
    SELECT
    min(block_timestamp) as date1,
    count (distinct TO_ADDRESS ) AS user1,
    case
    when FROM_ADDRESS = 'thor1ty6h2ll07fqfzumphp6kq3hm4ps28xlm2l6kd6' then 'Crypto.com'
    when FROM_ADDRESS = 'thor1t60f02r8jvzjrhtnjgfj4ne6rs5wjnejwmj7fh' then 'Binance Cold Wallet'
    when FROM_ADDRESS = 'thor1uz4fpyd5f5d6p9pzk8lxyj4qxnwq6f9utg0e7k' then 'Binance hot Wallet'
    when FROM_ADDRESS in (select distinct (to_address) from flipside_prod_db.thorchain.upgrades where BURN_ASSET = 'BNB.RUNE-B1A' ) then 'from BNB.RUNE upgraded'
    when FROM_ADDRESS in (select distinct (to_address) from flipside_prod_db.thorchain.upgrades where BURN_ASSET = 'ETH.RUNE-0X3155BA85D5F96B2D030A4966AF206230E46849CB' ) then 'from ETH.RUNE upgraded'
    when FROM_ADDRESS in (select distinct NATIVE_TO_ADDRESS from flipside_prod_db.thorchain.swaps where BLOCKCHAIN = 'BNB') then 'from BNB blockchain'
    when FROM_ADDRESS in (select distinct NATIVE_TO_ADDRESS from flipside_prod_db.thorchain.swaps where BLOCKCHAIN = 'BCH') then 'from BCH blockchain'
    when FROM_ADDRESS in (select distinct NATIVE_TO_ADDRESS from flipside_prod_db.thorchain.swaps where BLOCKCHAIN = 'BTC') then 'from BTC blockchain'
    when FROM_ADDRESS in (select distinct NATIVE_TO_ADDRESS from flipside_prod_db.thorchain.swaps where BLOCKCHAIN = 'TERRA') then 'from TERRA blockchain'
    when FROM_ADDRESS in (select distinct NATIVE_TO_ADDRESS from flipside_prod_db.thorchain.swaps where BLOCKCHAIN = 'THOR') then 'from THOR blockchain'
    when FROM_ADDRESS in (select distinct NATIVE_TO_ADDRESS from flipside_prod_db.thorchain.swaps where BLOCKCHAIN = 'LTC') then 'from LTC blockchain'
    when FROM_ADDRESS in (select distinct NATIVE_TO_ADDRESS from flipside_prod_db.thorchain.swaps where BLOCKCHAIN = 'ETH') then 'from ETH blockchain'
    when FROM_ADDRESS in (select distinct NATIVE_TO_ADDRESS from flipside_prod_db.thorchain.swaps where BLOCKCHAIN = 'DOGE') then 'from DOGE blockchain'
    else 'direct transfer' end as type
    FROM flipside_prod_db.thorchain.transfers
    GROUP BY 3
    order by 2

    Run a query to Download Data