ATTRIBUTE_VALUE | |
|---|---|
1 | ORDER_UNORDERED |
2 | {"amount":"22200","denom":"uatom","receiver":"neutron1unc0549k2f0d7mjjyf... |
3 | 102779 |
4 | 103193 |
5 | 102314 |
6 | 1706205983710000128 |
7 | 103253 |
8 | 1706173507035000064 |
9 | {"amount":"4000","denom":"uatom","receiver":"neutron1unc0549k2f0d7mjjyfm... |
10 | {"amount":"283","denom":"uatom","receiver":"neutron1unc0549k2f0d7mjjyfm9... |
11 | 102376 |
12 | {"amount":"100","denom":"uatom","receiver":"neutron1unc0549k2f0d7mjjyfm9... |
13 | 1706219230135000064 |
14 | {"amount":"449955","denom":"uatom","receiver":"neutron1unc0549k2f0d7mjjy... |
15 | 1706271790887000064 |
16 | 7b22616d6f756e74223a2233222c2264656e6f6d223a227561746f6d222c227265636569... |
17 | 1705542252535000064 |
18 | {"amount":"5500","denom":"uatom","receiver":"neutron1unc0549k2f0d7mjjyfm... |
19 | 1706209304176999936 |
20 | {"amount":"180","denom":"uatom","receiver":"neutron1unc0549k2f0d7mjjyfm9... |
SocioAnalyticalist cft-20 tokens
Updated 2024-01-28
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
›
⌄
with txns as (
SELECT DISTINCT tx_id
FROM cosmos.core.fact_msg_attributes
--WHERE tx_id = 'A53E004ECEA26E61608512E251D8503801B71D2E707079DF054A80B716AE0034'
WHERE msg_type = 'ibc_transfer'
AND ATTRIBUTE_KEY = 'receiver'
AND ATTRIBUTE_VALUE = 'neutron1unc0549k2f0d7mjjyfm94fuz2x53wrx3px0pr55va27grdgmspcqgzfr8p'
AND block_timestamp::date >= '2024-01-01'
)
SELECT
DISTINCT ATTRIBUTE_VALUE
FROM cosmos.core.fact_msg_attributes a
JOIN txns b using(tx_id)
WHERE msg_type = 'send_packet'
AND ATTRIBUTE_KEY = 'packet_channel_ordering'
AND block_timestamp::date >= '2024-01-01'
-- buy cft-token -- first reserve and after that buy
SELECT *
FROM cosmos.core.fact_msg_attributes
WHERE tx_id = '77CB2E1CB93818C16AA1FAEB853B6E13653E0426A69DDC2FCA74F53621C79F33'
SELECT *
FROM cosmos.core.fact_transactions
WHERE tx_id = 'A53E004ECEA26E61608512E251D8503801B71D2E707079DF054A80B716AE0034'
Last run: over 1 year ago
...
53839
6MB
10s