theericstoneWhat's goin on with Paxos
Updated 2021-11-11
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 prespike as (
select
to_address,
to_label,
to_address_name,
sum(amount) as amount_received
from
gold.ethereum_events
where block_timestamp < '2020-11-02'
and block_timestamp > '2020-10-01'
and contract_address = '0x8e870d67f660d95d5be530380d0ec0bd388289e1' --paxos stablecoin
group by 1,2,3
order by 4 desc
limit 50
),
postspike as (
select
to_address,
to_label,
to_address_name,
sum(amount) as amount_received
from
gold.ethereum_events
where block_timestamp > '2020-11-01'
and block_timestamp < '2020-12-02'
and contract_address = '0x8e870d67f660d95d5be530380d0ec0bd388289e1' --paxos stablecoin
group by 1,2,3
order by 4 desc
limit 50
)
select
postspike.to_address,
postspike.to_address_name,
postspike.to_label,
postspike.amount_received as after_received,
prespike.amount_received as before_received,
Run a query to Download Data