lagandispensernumber of NFT atomic transfers
Updated 2022-06-16
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, created_at as block_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 distinct asset_id, created_at as block_id from algorand.asset where asset_url like '%#arc3%' and closed_at is null
),
datetimes as (
SELECT
block_timestamp,
block_id
from algorand.block
),
s69_final as (
SELECT
asset_id,
block_timestamp,
'ARC69' as standard
from standard69 x, datetimes y where x.block_id=y.block_id
),
s3_final as (
SELECT
asset_id,
block_timestamp,
'ARC3' as standard
from standard3 x, datetimes y where x.block_id=y.block_id
),
final_data as (
select * from s69_final
union ALL
select * from s3_final
)
select
trunc(block_timestamp,'day') as date,
Run a query to Download Data