zakkisyed#7 Gnosis: Daily Active accounts per project
Updated 2023-03-14
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
›
⌄
select date_trunc(day,block_timestamp) as block_time,
Case when to_address = lower('0x678ACb78948Be7F354B28DaAb79B1ABD81574c1B') then 'Dark Forest'
when to_address = lower('0x1f566931438F5c8ae408A07a02502046a771FD3b') then 'Dark Forest'
when to_address = lower('0x661Aa290fdA44736742844C496afd81c7F983EDc') then 'Dark Forest'
when to_address = lower('0x0F8E1785f850d4bF1155614883c2cB778a69c463') then 'Dark Forest'
when to_address = lower('0xafb1A0C81c848Ad530766aD4BE2fdddC833e1e96') then 'Dark Forest'
when to_address = lower('0x71340606E119de5a4dc3f1CA6bc5ec102a7fA7c0') then 'Dark Forest'
when to_address = lower('0x621ce133521c3B1cf11C0b9423406F01835af0ee') then 'Dark Forest'
when to_address = lower('0x6C5b4B9b835e4e085C5B8124E44045D5b3b57Cd9') then 'Dark Forest'
when to_address = lower('0xc278c106777E4a3a51FAdD5fF2489394Af0ACddA') then 'Dark Forest'
when to_address = lower('0x15b96fa1BB22CD67A7270fDA87d2491859391a6e') then 'Dark Forest'
when to_address = lower('0x111491bE388a9edb9180A94Ae729c157AD0B1089') then 'Dark Forest'
when to_address = lower('0x53B0aF9cfe7f9FCAAa530702754EA05D70592E28') then 'Dark Forest'
when to_address = lower('0x044823869f814bA6e36f8f63FEe97EbFfaD67440') then 'Dark Forest'
when to_address = lower('0x9733188Cb05d3e070A4bf47A705Cf6a5b82aE74d') then 'Dark Forest'
when to_address = lower('0x542B74c71adaEa9F6BeEeB916c85dC4785C26311') then 'Dark Forest'
when to_address = lower('0x3f67B15395b730689e64196093A9f11B513f7DCd') then 'Dark Forest'
when to_address = lower('0x8b04d70Efc21A58bD6c3030D22aAE93a7763d52F') then 'Dark Forest'
when to_address = lower('0x27a166aE00C33Bef64306760aCd7C9fD3c2fEB74') then 'Dark Forest'
when to_address = lower('0x8e7Fc9c67Cf2bc5D001682d17355dc5c7f41e4C1') then 'Dark Forest'
when to_address = lower('0x71eF8b8D795AEbaf6dd6a2A0397B5D3A0e2B226E') then 'Dark Forest'
when to_address = lower('0xed6b8BC35405bF6aa231CDDe9ec994b9DBF1f501') then 'Dark Forest'
when to_address = lower('0x204104155100d6bc0d8928d720b3CD8d845B0F28') then 'Dark Forest'
when to_address = lower('0x5da117b8aB8b739346F5EdC166789E5aFb1a7145') then 'Dark Forest'
when to_address = lower('0xb5157671d80601A5F26c0256232FAb035e3Af609') then 'Guild W DF Round 1'
when to_address = lower('0x1C232F01118CB8B424793ae03F870aa7D0ac7f77') then 'Honeyswap'
when to_address = lower('0xA818b4F111Ccac7AA31D0BCc0806d64F2E0737D7') then 'Honeyswap'
when to_address = lower('0xB44825cF0d8D4dD552f2434056c41582415AaAa1') then 'Honeyswap'
when to_address = lower('0xfBA19af3bE412E08AF9c7Cf60756d238D3cEAd25') then 'Honeyswap'
when to_address = lower('0xdD36008685108aFafc11F88bBc66C39A851Df843') then 'Honeyswap'
when to_address = lower('0x82374C59709AAc2f7864191a3c492932379536F4') then 'Honeyswap'
when to_address = lower('0xbA13a6414C677d9e7BD3c0BDE5BA4055BF2e72f7') then 'Honeyswap'
when to_address = lower('0xf712a82DD8e2Ac923299193e9d6dAEda2d5a32fd') then 'Bao Finance'
when to_address = lower('0x5870b0527DeDB1cFBD9534343Feda1a41Ce47766') then 'RANDAO'
when to_address = lower('0x7301CFA0e1756B71869E93d4e4Dca5c7d0eb0AA6') then 'xDai Bridge'
when to_address = lower('0xE43e60736b1cb4a75ad25240E2f9a62Bff65c0C0') then 'Swapr'
Run a query to Download Data