Date | Transfer_From Volume | Transfer_From Count | CEX | |
|---|---|---|---|---|
1 | 2023-01-01 00:00:00.000 | 990746.88909159 | 1361 | gate.io deposit_wallet |
2 | 2023-01-01 00:00:00.000 | 112380.47495646 | 86 | bitfinex deposit_wallet |
3 | 2023-01-01 00:00:00.000 | 670914.94416943 | 173 | coinbase deposit_wallet |
4 | 2023-01-01 00:00:00.000 | 5509601.76203286 | 7552 | okx deposit_wallet |
5 | 2023-01-01 00:00:00.000 | 77463.97580428 | 424 | bitget |
6 | 2023-01-01 00:00:00.000 | 29491587.0130675 | 54005 | binance deposit_wallet |
7 | 2023-01-01 00:00:00.000 | 453336.26844113 | 5276 | mexc deposit_wallet |
8 | 2023-01-01 00:00:00.000 | 454619.70957411 | 4983 | mexc |
9 | 2023-01-01 00:00:00.000 | 741472.51737056 | 452 | kraken |
10 | 2023-01-01 00:00:00.000 | 1807096.86646601 | 1003 | coinbase |
11 | 2023-01-01 00:00:00.000 | 982890.81773 | 629 | gate.io |
12 | 2023-01-01 00:00:00.000 | 112380.20446331 | 84 | bitfinex |
13 | 2023-01-01 00:00:00.000 | 77471.2793805 | 543 | bitget deposit_wallet |
14 | 2023-01-01 00:00:00.000 | 3490371.64568332 | 7659 | bybit deposit_wallet |
15 | 2023-01-01 00:00:00.000 | 3490404.62640692 | 7464 | bybit |
16 | 2023-01-01 00:00:00.000 | 12094902.464652 | 8165 | okx |
17 | 2023-01-01 00:00:00.000 | 44157766.671811 | 45458 | binance |
18 | 2023-01-01 00:00:00.000 | 741473.41927508 | 452 | kraken deposit_wallet |
19 | 2023-02-01 00:00:00.000 | 391857.35823733 | 452 | gate.io |
20 | 2023-02-01 00:00:00.000 | 184097.70958886 | 139 | bitfinex deposit_wallet |
Eman-Raztransfers from
Updated 6 hours ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
-- WithdrawEvent
with tab1 as (select block_timestamp, amount, account_address, tx_hash
from aptos.core.fact_transfers
where success='true' and TRANSFER_EVENT='DepositEvent'
AND token_address='0x1::aptos_coin::AptosCoin'),
tab2 as (select address, address_name
from aptos.core.dim_labels
where LABEL_TYPE='cex'
order by 1)
select date_trunc('{{Time_Frame}}',block_timestamp) as "Date", sum(amount)/pow(10,8) as "Transfer_From Volume",
count(distinct tx_hash) as "Transfer_From Count", address_name as "CEX"
from tab1 LEFT JOIN tab2 on tab1.account_address=tab2.address
where block_timestamp::date>='{{Start_Date}}' and block_timestamp::date<='{{End_Date}}' and address_name is not null
group by 1,4
order by 1
Last run: about 6 hours agoAuto-refreshes every 24 hours
...
232
15KB
62s