princefarzamAlgos to/from CEXs
Updated 2022-03-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
With TO_binance AS (SELECT
date_trunc('day',block_timestamp) AS DAY,
sum(AMOUNT) AS ALGOS_TO_binance
FROM algorand.payment_transaction
WHERE receiver='SP745JJR4KPRQEXJZHVIEN736LYTL2T2DFMG3OIIFJBV66K73PHNMDCZVM'
AND DAY >= '2022-02-10' --Appointed new CEO staci warden
GROUP BY 1
ORDER BY 1 ASC),
From_binance AS(
SELECT
date_trunc('day',block_timestamp) AS DAY,
sum(AMOUNT) AS ALGOS_FROM_binance
FROM algorand.payment_transaction
WHERE sender='SP745JJR4KPRQEXJZHVIEN736LYTL2T2DFMG3OIIFJBV66K73PHNMDCZVM'
AND DAY >= '2022-02-10'
GROUP BY 1
ORDER BY 1 ASC
),
To_coinbase AS(
SELECT
date_trunc('day',block_timestamp) AS DAY,
sum(AMOUNT) AS ALGOS_TO_coinbase
FROM algorand.payment_transaction
WHERE receiver='UXVAPU4KERSMNUILDVZUKKF4KMWQ7RFSSYPXYSEGSYNYILC4FEHISKRBNM'
AND DAY >= '2022-02-10'
GROUP BY 1
ORDER BY 1 ASC),
From_coinbase AS(
SELECT
date_trunc('day',block_timestamp) AS DAY,
sum(AMOUNT) AS ALGOS_FROM_coinbase
FROM algorand.payment_transaction
WHERE sender='UXVAPU4KERSMNUILDVZUKKF4KMWQ7RFSSYPXYSEGSYNYILC4FEHISKRBNM'
AND DAY >= '2022-02-10'
GROUP BY 1
ORDER BY 1 ASC)