theericstoneBSC Exploration
Updated 2021-02-25
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 senders as (
SELECT
from_address
--sum(amount) as amount,
--symbol,
--from_address,
--from_address_name,
--from_label
from gold.ethereum_events
where to_address = LOWER('0x131A99859a8bfa3251D899F0675607766736FFaE')
and amount > 10
and block_timestamp > getdate() - interval '30 days'
group by 2,3,4,5
order by 1 desc
),
receivers as (
SELECT
sum(amount) as amount,
symbol,
to_address,
from_address_name,
from_label
from gold.ethereum_events
where from_address = LOWER('0x131A99859a8bfa3251D899F0675607766736FFaE')
and amount > 10
and block_timestamp > getdate() - interval '30 days'
group by 2,3,4,5
order by 1 desc
)
*/
select * from gold.ethereum_events where contract_address = LOWER('0x131A99859a8bfa3251D899F0675607766736FFaE') and
origin_label IS NOT NULL AND
block_timestamp > getdate() - interval '100 days' order by 1 desc limit 100;
Run a query to Download Data