StangFASTaurobots - inflow [ airdrop ]
Updated 2025-02-13
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
›
⌄
--- creator -- from 0xa7be2cdd6026933b9e968c357a55b4390f2a6016 -- to 0xb4f9b3424b25bcf8abfa474a6d0f337c2cdb493b [ minting ]
--- claim -- from other not 2 up -- to 0xb4f9b3424b25bcf8abfa474a6d0f337c2cdb493b []
--- aurobots - 0xb4f9b3424b25bcf8abfa474a6d0f337c2cdb493b
with
minting AS
(
SELECT
date_trunc( 'month' , a.block_timestamp ) AS "date"
, count( DISTINCT a.tx_hash ) AS "transactions"
, 'Minting' AS "type"
FROM
aurora.core.fact_receipts a
WHERE
a.from_address = '0xa7be2cdd6026933b9e968c357a55b4390f2a6016'
AND a.to_address = '0xb4f9b3424b25bcf8abfa474a6d0f337c2cdb493b'
AND a.tx_success = 'true'
GROUP BY 1
ORDER BY 1 DESC
)
,
outflow AS
(
SELECT
date_trunc( 'month' , a.block_timestamp ) AS "date"
, count( DISTINCT a.tx_hash ) AS "transactions"
, 'Outflow' AS "type"
FROM
aurora.core.fact_receipts a
WHERE
a.logs[0]:address = '0xb4f9b3424b25bcf8abfa474a6d0f337c2cdb493b'
AND a.from_address != '0xa7be2cdd6026933b9e968c357a55b4390f2a6016'
AND a.tx_success = 'true'
GROUP BY 1
QueryRunArchived: QueryRun has been archived