Crypto Wednesday

Reports

February 2024

Stats

  • 27 accounts made 64 transfers (outside of topping up) for a total of 477 zinnes [1]
  • 48 holders to date (view on polygonscan)
  • Stripe revenue €251 (20 payments, 12 Apple Pay, 2 Google Pay, 3 bancontact, 2 mastercard, 1 visa, €8.59 fees = 3.4%)
  • 14 accounts topped up for a total of 240 zinnes (€1 of transaction fee on first top up from Jonas) [2]
  • 19 accounts made 34 transactions to @cryptobar for a total of 121 zinnes [3]
  • 14 accounts donated for a total of 63 zinnes to @pizza [4]

Queries:

[1]

```sql

SELECT count(distinct from_addr) as unique_accounts, count(*) as transactions, SUM(value::integer/1000000)  as total_transactions

FROM t_transfers_137_0x5491a3d35f148a44f0af4d718b9636a6e55ebc2d

WHERE from_addr != '0x0000000000000000000000000000000000000000'

  AND to_addr != '0x0000000000000000000000000000000000000000'

  AND from_addr != '0x5736A617711d11f92A9f6C32f9f8d01F88b832BA' -- @topup

```

[2]

```sql

SELECT count(distinct to_addr) as unique_toppers, count(*) as transactions, SUM(value::integer/1000000)  as total_transactions

FROM t_transfers_137_0x5491a3d35f148a44f0af4d718b9636a6e55ebc2d

WHERE from_addr = '0x5736A617711d11f92A9f6C32f9f8d01F88b832BA' -- @topup

```

[3]

```sql

SELECT count(distinct from_addr) as unique_customers, count(*) as transactions, SUM(value::integer/1000000)  as total_transactions

FROM t_transfers_137_0x5491a3d35f148a44f0af4d718b9636a6e55ebc2d

WHERE to_addr = '0x34C4360bd268a9d615Bc3382f35792e03C026Ca7' -- @cryptobar

```

[4]

```sql

SELECT count(distinct from_addr) as unique_donors, count(*) as transactions, SUM(value::integer/1000000)  as total_transactions

FROM t_transfers_137_0x5491a3d35f148a44f0af4d718b9636a6e55ebc2d

WHERE to_addr = '0x6C2Df884CA32903bB6354Dcc9FF1d37Fc3F9066e' -- @pizza

```

What went well

What could be improved

Action items

January 2024

What went well

- it was easy for people to enter, thanks to Alexandra attending the door

- relaxed atmosphere, interaction with participants

- trying out hardware wallet is quality activity

- using citizen wallet went relatively smooth

- Ilo brought Tom (Flordi Ghent) and he's potentially interested in launching a community currency with Citizen Wallet

What could be improved

- document bar prices

- bottle recycle

- any tablet/laptop would've worked to display https://live.citizenwallet.xyz/polygon/ZINNE

- waiting on transaction confirmation from monerium is a dozen awkward seconds every time

        - nice-to-have: automatically send Zinne on receiving EURe

- one person suggested receiving their Zinne on MetaMask and Bruno was like "sure that should work"... was more elaborate and took quite some time but we managed to get it working. Good learning experience and next time: keep it simple.

- be more visible on our socials/communicate events in time

Action items

- document bar prices

- @Xavier: move balance from @cryptobar-jan24 to the correct wallet (bar proceeds)

- @Xavier: reclaim bank

- @Bruno: give back badge and tablet holder to Xavier

- waiting for 20 EURe from Dries to appear on-chain