KowalskiDeFiPlanet IX + Aavegotchi Core + Creative
Updated 2023-02-28
999
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
›
⌄
-- forked from 96858717-701d-4183-b0f4-b66ac2750fa7
WITH
core AS (
SELECT
DATE(
DATE_TRUNC('{{period}}', block_timestamp)
) as date_time,
COUNT(DISTINCT tx_hash) as number_txns,
COUNT(DISTINCT from_address) as unique_active_users,
SUM(tx_fee) as transaction_fees,
CASE
WHEN lower(to_address) IN (
'0xd5543237c656f25eea69f1e247b8fa59ba353306',
'0x86935f11c86623dec8a25696e1c19a8659cbf95d',
'0x385eeac5cb85a38a9a07a70c73e0a3271cfb54a7',
'0x1d86852b823775267ee60d98cbcda9e8d5c2faa7',
'0xa44c8e0ecaefe668947154ee2b803bd4e6310efe',
'0x1d0360bac7299c86ec8e99d0c1c9a95fefaf2a11',
'0x403e967b044d4be25170310157cb1a4bf10bdd0f',
'0x44a6e0be76e1d9620a7f76588e4509fe4fa8e8c8',
'0x6a3e7c3c6ef65ee26975b12293ca1aad7e1daed2',
'0x42e5e06ef5b90fe15f853f59299fc96259209c5c',
'0x3801c3b3b5c98f88a9c9005966aa96aa440b9afc'
) THEN 'Aavegotchi'
ELSE 'Planet IX'
END as label
FROM
polygon.core.fact_transactions
WHERE
DATE(block_timestamp) >= DATE('2021-08-15')
AND lower(to_address) IN (
'0xba6666b118f8303f990f3519df07e160227cce87',
'0x5cb9fcd65cfe3eefde88a7084caf2625d516bdd0',
'0xd5543237c656f25eea69f1e247b8fa59ba353306',
'0x86935f11c86623dec8a25696e1c19a8659cbf95d',
'0x385eeac5cb85a38a9a07a70c73e0a3271cfb54a7',
Run a query to Download Data