TOTAL_LQTY_ISSUED | |
|---|---|
1 | 29639406.6373544 |
chispasTotal LQTY Issued Updated
Updated 2025-01-07
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT
CAST(livequery.utils.udf_hex_to_int(SUBSTRING(data, 3)) AS DECIMAL(38, 0)) / POWER(10, 18) AS total_lqty_issued
FROM
ethereum.core.fact_event_logs
WHERE
contract_address = LOWER('0xD8c9D9071123a059C6E0A945cF0e0c82b508d816') -- Community Issuance contract address
AND topics[0] = LOWER('0x033068abf93bdec23e781d0a3b3f3e688bfa8471c68b629ad68652cdc63a6e49') -- TotalLQTYIssuedUpdated event signature
ORDER BY
block_timestamp DESC
LIMIT 1;
Last run: 2 months ago
1
20B
9s