Aephiaanonymous-scarlet
Updated 2024-09-03
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
›
⌄
⌄
select
ft.*
/*
date_trunc('day', block_timestamp::date) as date
----------------------------------------------------
,zeroifnull(sum(case when instruction:accounts[3] = 'A1YadVHXXJG2jsnwWUxe6kwGvitzqyBQkAWkWbHr4rgJ'
AND value:parsed:info:authority = 'C4xiT3ZkC3XqrTNWLvZ9stKnNaq428FGzXcfHkJWWpC'
then value:parsed:info:amount
end)) as ARCO_mined
,zeroifnull(sum(case when instruction:accounts[3] = 'EYTRX7sedAaSpTbXeYaAZ8QwrjLrnvgnufGEEXuZJGaE'
AND value:parsed:info:authority = 'BMVcHYaU9iFHvsSKVqDZAZgUKLem6GjwQga2Kv7SfE32'
then value:parsed:info:amount
end)) as BIOMASS_mined
,zeroifnull(sum(case when instruction:accounts[3] IN ('HCwcs4XvmTJNFAMYxCjxdtBZWRZyi3ZGv77Zd5RtFgmW', '6Fy8jqtbNugu4kab1awaoskds7TqcHJVaH6pAzqSYNCZ')
AND value:parsed:info:authority IN ('6RELLTiYaFo6eQgfphFyrAhfbKKrHXYNguC49PnHJ544', '8XopaamjHACCqvwQ4aHGBay5gdtRZ4jjwjVFvXyjvu6J', '12EhZLDeFPAkyjTrarBnL8jtyNhBfVZ9bDme3vsz4WBH')
then value:parsed:info:amount
end)) as CARBON_mined
,zeroifnull(sum(case when instruction:accounts[3] = 'BgZz8f8hjtjo7hSPGKkjBSfQBye1qJw8EMrCQC2MQmBE'
AND value:parsed:info:authority = 'HaJpPb4YoQQpURYfbkSVqu9MBnBup3GFD5oTRmMvWjsu'
then value:parsed:info:amount
end)) as CUORE_mined
,zeroifnull(sum(case when instruction:accounts[3] IN ('HMm6azpfo6u1GzZpsrjEGNxJL6r98vmGmQMXxqx7vYv6', '5ezwRcjYUBhXKNgkWow6S5JvDpiW1SQekpCoWRRKUJ7H')
AND value:parsed:info:authority IN ('C7vAHHm1zgMttkhNk7KrKhSp6EuGD9MpBTiha9yVX3pL', 'G55rzSDcBs2fcvsmR4ezWteCZ3L7vYn8RtqGZWptuW7k')
then value:parsed:info:amount
end)) as HYG_mined
,zeroifnull(sum(case when instruction:accounts[3] IN ('YZ9uC1opxcC5NRbGNwBnYZ168LhTcgrP7n5a6yd5QLk', 'FRkJkhgkE5aFG7DLGU96v3ZhrHEyqT79vcpZPLLQDRNa')
AND value:parsed:info:authority IN ('2idCMoMqBe4KX2jJYo4nJ7TbSedBYuXGFVUVcYF7s4mo', '9hj3A7HyrByHBgG626a8sZibLy7ruRJy3eEdPgZX4dKn', '9SCCanZfWfrVR2sRPy8Dkn4eXetmPJGorscb1Kst5WiY')
then value:parsed:info:amount
end)) as NITRO_mined
,zeroifnull(sum(case when instruction:accounts[3] IN ('4qB5xPEpTvJQq56SqXEVhNWbTcPsekN6DSeuXVMm4nVZ', '6n4S5H4mADdGhRmkPpQrBLKqHRbeCRBewfDF47iF6vW4')
AND value:parsed:info:authority IN ('3k38J6jUNx9PC6wUBHr36BewzvpXTUy8e5wYnNFFFg5Z', '4cZRpfmURakQSzoksgAisB5Quepj1y2MF9Mr5Sag56Fk')
then value:parsed:info:amount
end)) as TIORE_mined,
-----------------------------------------------------------------
QueryRunArchived: QueryRun has been archived