SocioCryptointerchain name - over time
Updated 2023-04-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT date_trunc('day',a.block_timestamp) as date,
count(DISTINCT a.tx_id)
FROM osmosis.core.fact_msg_attributes a , osmosis.core.fact_msg_attributes b
WHERE a.attribute_key = 'name' AND b.attribute_value IS NOT NULL
AND b.attribute_key = 'minter' and b.attribute_value = 'osmo1llh07xn7pcst3jqm0xpsucf90lzugfskkkhk8a3u2yznqmse4l5smydwpw'
AND a.tx_id = b.tx_id
GROUP BY date
-- WHERE tx_id = 'A6F3ACB625A03DAB5B06E7877E13E9CA5602FDD3D57F4C98D6C5B5B00730CDF1'
--AND attribute_key not in ('_contract_address', 'module', 'action', 'sender')
--spender = owner = wallet_address | name | method = claim | minter = 'osmo1llh07xn7pcst3jqm0xpsucf90lzugfskkkhk8a3u2yznqmse4l5smydwpw'
-- msg_type = transfer and attribute_key = amount and attribute_value = 500000uosmo
Run a query to Download Data