SajjadiiiNew User Onboarding 2
Updated 2022-06-28Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
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