misaghlbAlgorand Competitive advantages Algorand NFTs Atomic Transfer Sales
Updated 2022-06-15
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
standard69 as (
SELECT
asset_id from algorand.asset where asset_id in (
select distinct asset_id from algorand.asset_configuration_transaction where try_base64_decode_string(tx_message:txn:note::string) like '%{"standard":"arc69"%') and closed_at is null
),
standard3 as (
select asset_id from algorand.asset where asset_url like '%#arc3%' and closed_at is null
),
tx_ids69 as (
SELECT tx_group_id
from flipside_prod_db.algorand.transactions
WHERE asset_id in (SELECT asset_id from standard69) -- 418142231
and tx_group_id = 'SPtV0lbAJEPGKjaa0vYRXvvm9BFMfi1vCZBB0eL1pRY='
and TX_ID not in (SELECT TX_ID from flipside_prod_db.algorand.application_call_transaction where date(BLOCK_TIMESTAMP) >= '2022-01-01')
and date(BLOCK_TIMESTAMP) >= '2022-01-01'
group by tx_group_id
),
tx_692_2 as (
SELECT tx_group_id, count(*) as tx_count,
COUNT(DISTINCT SENDER) as wallet_count
from flipside_prod_db.algorand.transactions
-- asset_id in (SELECT asset_id from standard69) -- 418142231
WHERE tx_group_id in (SELECT tx_group_id from tx_ids69)
-- and TX_ID not in (SELECT TX_ID from flipside_prod_db.algorand.application_call_transaction where date(BLOCK_TIMESTAMP) >= '2022-01-01')
and date(BLOCK_TIMESTAMP) >= '2022-01-01'
group by tx_group_id HAVING tx_count = 3
),
tx_ids3 as (
SELECT tx_group_id
from flipside_prod_db.algorand.transactions
WHERE asset_id in (SELECT asset_id from standard3) -- 418142231
-- and tx_group_id = 'SPtV0lbAJEPGKjaa0vYRXvvm9BFMfi1vCZBB0eL1pRY='
and TX_ID not in (SELECT TX_ID from flipside_prod_db.algorand.application_call_transaction where date(BLOCK_TIMESTAMP) >= '2022-01-01')
and date(BLOCK_TIMESTAMP) >= '2022-01-01'
group by tx_group_id
Run a query to Download Data