flipside

    sweat economy token burns
    adriaparcerisassweat economy token burns
    Updated 4 hours ago
    with all_burns as (
    select *,
    TRY_PARSE_JSON(clean_log):"data" AS data,
    data[0]:"amount"/pow(10,18) as tokens_burnt
    from near.core.fact_logs
    where
    predecessor_id='vote1.sweat'
    and receiver_id='token.sweat'
    and signer_id='treasury.sweat'
    and TRY_PARSE_JSON(clean_log):"data" is not null
    and data[0]:"amount" is not null

    UNION ALL

    select *,
    TRY_PARSE_JSON(clean_log):"data" AS data,
    data:"burnt_amount"/pow(10,18) as tokens_burnt
    from near.core.fact_logs
    where
    receiver_id='claim.sweat'
    and signer_id='token.sweat'
    and predecessor_id='claim.sweat'
    and event_standard='sweat_claim'
    and TRY_PARSE_JSON(clean_log):"data" is not null
    and data:"burnt_amount" is not null
    and receipt_succeeded='TRUE'

    UNION ALL

    select *,
    TRY_PARSE_JSON(clean_log):"data" AS data,
    data[0]:"amount"/pow(10,18) as tokens_burnt
    from near.core.fact_logs
    where
    receiver_id='token.sweat'
    and signer_id='community.sweat'
    Last run: about 4 hours ago
    BLOCK_ID
    BLOCK_TIMESTAMP
    TX_HASH
    RECEIPT_ID
    PREDECESSOR_ID
    RECEIVER_ID
    SIGNER_ID
    LOG_INDEX
    CLEAN_LOG
    EVENT_STANDARD
    GAS_BURNT
    RECEIPT_SUCCEEDED
    FACT_LOGS_ID
    INSERTED_TIMESTAMP
    MODIFIED_TIMESTAMP
    DATA
    TOKENS_BURNT
    1
    		1454571392025-04-30 21:27:01.830DPVaatFv35bGsRMtt5pBi9W96Cc7AC6G93TPkpVcpXQsFrZ8bPuB2r3BvuXsbo71pVn9GrMJqj2Ba9KkFnWNEDzMvote1.sweattoken.sweattreasury.sweat0
    {"data":[{"amount":"50000000000000000000000000","owner_id":"vote1.sweat"...
    		nep1411732265336371TRUE4544cd8bde0ae103afaac0d31311d1bb2025-04-30 22:38:48.3232025-04-30 23:37:12.815
    [{"amount":"50000000000000000000000000","owner_id":"vote1.sweat"}]
    		50000000
    2
    		1431533242025-03-31 18:19:54.514DSkCxmutun6mfXJisL7MvGCzGY9eMUYR3n2Cvtf3AYyS6SeiCLusSbSZaLfGENKngu45Msmp6EZb1mp7ZrmPNUFyvote1.sweattoken.sweattreasury.sweat0
    {"data":[{"amount":"50000000000000000000000000","owner_id":"vote1.sweat"...
    		nep1412072686410817TRUE8d3c5458807b5b8a63c7f8752ba0168c2025-03-31 20:13:28.6102025-03-31 20:13:28.610
    [{"amount":"50000000000000000000000000","owner_id":"vote1.sweat"}]
    		50000000
    3
    		1407985112025-02-28 15:26:17.736F6JFGKmUD8U9G2WBaoN3pux79L6arUZdRGq5jfwXynrj3AVvj1Utqp8wdiKLsvch7m9gFTZher6Rt5DRd8d2gMh2vote1.sweattoken.sweattreasury.sweat0
    {"data":[{"amount":"50000000000000000000000000","owner_id":"vote1.sweat"...
    		nep1411746087292297TRUE5f00929e1abe1d6e9e6f43799ac39f5f2025-02-28 16:49:06.7262025-02-28 16:49:06.726
    [{"amount":"50000000000000000000000000","owner_id":"vote1.sweat"}]
    		50000000
    4
    		1386303552025-01-31 10:33:21.711CtptexKJBn7KxfPmG489syCooYjXLQnbMUdeyNjNRL928marbM3KCLPzXqFc4MK4ioAY6LbgJSrDa64JJ4hpZNmFvote1.sweattoken.sweattreasury.sweat0
    {"data":[{"amount":"50000000000000000000000000","owner_id":"vote1.sweat"...
    		nep1411743807292297TRUEe9df85cbeaadddedb741d0292c71b2b92025-01-31 20:42:53.0892025-01-31 20:42:53.089
    [{"amount":"50000000000000000000000000","owner_id":"vote1.sweat"}]
    		50000000
    5
    		1363450952025-01-01 15:26:52.546FNts7DrBfT9ygxfWuuXZKSyjFi3btKw7bdxCLz5juhp57D1h7gStsYvejrKjsmhU3xR1Q2bEFkV34GMWDFL6vSQsvote1.sweattoken.sweattreasury.sweat0
    {"data":[{"amount":"31000000000000000000000000","owner_id":"vote1.sweat"...
    		nep1411743807292297TRUEbf94710f6a2ec90790f784cb3da590ff2025-01-01 16:32:27.4572025-01-01 17:29:07.427
    [{"amount":"31000000000000000000000000","owner_id":"vote1.sweat"}]
    		31000000
    6
    		1362811472024-12-31 19:34:40.750DxwGU8v2S6kP6hfQtjYp4ekxcfkA6TLSNVYGdJHiusdJ5cmUvybZJYcT3bCdFctgiPRVJSQEqLRm3DW1FomTYb6Fvote1.sweattoken.sweattreasury.sweat0
    {"data":[{"amount":"19000000000000000000000000","owner_id":"vote1.sweat"...
    		nep1412109592278595TRUE8eebc65cb7b46a809a9da71754b3e0d02024-12-31 20:29:42.6242024-12-31 21:30:19.085
    [{"amount":"19000000000000000000000000","owner_id":"vote1.sweat"}]
    		19000000
    7
    		1339331152024-11-30 22:32:40.953AHz9BWYzCvcMLAHiDarWw3sEtqfqbBpFLBL2rfFftCdqBqkAWmik4VR36Z674emGUDrSKJzQzdvos9izQbcSf6DDvote1.sweattoken.sweattreasury.sweat0
    {"data":[{"amount":"80000000000000000000000000","owner_id":"vote1.sweat"...
    		nep1411743807292297TRUE3ae95897ddb37d9024eb9c71a90e1f5c2024-11-30 23:27:42.0202024-11-30 23:27:42.020
    [{"amount":"80000000000000000000000000","owner_id":"vote1.sweat"}]
    		80000000
    8
    		1317309562024-11-01 20:09:40.9034oVJmyf8RqH5ZAgz7vL9K5n7a5NbtS9Aduvw21AiJZeTDSAxL7hZw1P6mA5t8yGTmKrBhiFn6LGerV1XGBJJRewNvote1.sweattoken.sweattreasury.sweat0
    {"data":[{"amount":"50000000000000000000000000","owner_id":"vote1.sweat"...
    		nep1411743807292385TRUEe002d0224c9ce8d84c97c346be35eb252024-11-01 21:32:31.6842024-11-01 21:32:31.684
    [{"amount":"50000000000000000000000000","owner_id":"vote1.sweat"}]
    		50000000
    9
    		1246974242024-07-31 16:41:39.533GNgZ463zFKpfRp6LbLhFae8xL3An9DSjcejEK63GV46HAqG6YXSEi2D8bGqKQ9RmnTWrogksFcJHyjsTjw93HaH4claim.sweatclaim.sweattoken.sweat0
    {"data":{"burnt_amount":"27000000000000000000000000"},"event":"burn","st...
    		sweat_claim1403753265757TRUE7b83ff6b4facd2fad2c56148254d034f2024-07-31 17:24:38.4362024-07-31 17:24:38.436
    {"burnt_amount":"27000000000000000000000000"}
    		27000000
    10
    		1246974152024-07-31 16:41:30.5134jndvAmkC6pXvWk1gtPX9CMTzs87nHAQLKzbB9xX3Vuh3xwnkoPtd79qS9kQuayKtLPnQT5nMP6b9XuQya7LHVtYvote1.sweattoken.sweattreasury.sweat0
    {"data":[{"amount":"73000160260000000000000000","owner_id":"vote1.sweat"...
    		nep1411743820456481TRUEcb0c84771f2abdc783c920514ff454a82024-07-31 17:24:38.4362024-07-31 17:24:38.436
    [{"amount":"73000160260000000000000000","owner_id":"vote1.sweat"}]
    		73000160.26
    11
    		1246337472024-07-30 20:53:29.866DciozVGWPsubMTtGrUMVpueACZURe5p1q2P4qYWj3Kxt5ZtGXL5TWqacCix6YCPLnaBTVZLeFacjVYzyM4mLwTHkclaim.sweatclaim.sweattoken.sweat0
    {"data":{"burnt_amount":"1000000000000000000"},"event":"burn","standard"...
    		sweat_claim1635420222861TRUE051a322438659edb5a3d5932cf5932ce2024-07-30 22:23:56.1482024-07-30 22:23:56.148
    {"burnt_amount":"1000000000000000000"}
    		1
    12
    		1223459842024-06-30 21:19:45.650DgWEgjod7iqtLhgmm3Tz9fWCAYagaZoLW8zVjY647ZXGCp9K4ryiopFgH5F69jxd8jYtyZ3rqnRT7kG4n8hWC52Uvote1.sweattoken.sweattreasury.sweat0
    {"data":[{"amount":"110000000000000000000000000","owner_id":"vote1.sweat...
    		nep1411730524098258TRUEa211817acba1d1d8ac4bdb1c5ab165992024-06-30 21:33:35.1842024-06-30 21:33:35.184
    [{"amount":"110000000000000000000000000","owner_id":"vote1.sweat"}]
    		110000000
    13
    		1201633082024-05-31 22:36:50.7862Xmfvhdpccy4q7RoRd4sVvGtKaVxGE97cjukk87EqxEZ7Hcxwp827gE7nVGqMyJicvzt9qJ4EmKXPWdDNLFPFBzbvote1.sweattoken.sweattreasury.sweat0
    {"data":[{"amount":"128000000000000000000000000","owner_id":"vote1.sweat...
    		nep1411730524098258TRUE525bf7db782f637ae1a73acb051f58722024-06-01 00:53:00.1382024-06-01 00:53:00.138
    [{"amount":"128000000000000000000000000","owner_id":"vote1.sweat"}]
    		128000000
    14
    		1179787642024-04-30 22:49:48.781BYTF2zqGfstEuhENiT52qHtyfFG6GAWC1YvCrDkx7CRq4Y8yUS1AUwL1LJv6VMnzpcxFqk1F7CSGmaSgTtzgaPUavote1.sweattoken.sweattreasury.sweat0
    {"data":[{"amount":"182000000000000000000000000","owner_id":"vote1.sweat...
    		nep1411744346054184TRUE7d5e06a4a248a6215f623a478c8d837d2024-05-01 00:51:57.2692024-05-01 00:51:57.269
    [{"amount":"182000000000000000000000000","owner_id":"vote1.sweat"}]
    		182000000
    15
    		1158714212024-03-31 19:47:11.1435c8ZVDzFa2z4Fogbd56wwB1csGAioF2DBf3XonZoNk9u94i5dUvVPXwxnS6Q9Rm7FmjY7oM2qh7xAQJPvb2Nyj7gvote1.sweattoken.sweattreasury.sweat0
    {"data":[{"amount":"165000000000000000000000000","owner_id":"vote1.sweat...
    		nep1413461551614467TRUEd441abe4dce19cddd86b7a119d2c245d2024-03-31 21:26:35.9882024-03-31 21:26:35.988
    [{"amount":"165000000000000000000000000","owner_id":"vote1.sweat"}]
    		165000000
    16
    		1138355612024-02-29 19:22:26.211HHpiLWYAu6hWzy9XkCDR1tCiWkQ9GSkGj8wjhFdrcbHdEQ3aAQihGMUxkxknBN7SpZ4Q2jwKLHMc1pyTF3uvgbbyvote1.sweattoken.sweattreasury.sweat0
    {"data":[{"amount":"50000000000000000000000000","owner_id":"vote1.sweat"...
    		nep1413095227866370TRUE483eda0584608e22f8bffb600af6ef242024-03-07 04:36:19.3852024-03-07 04:36:19.385
    [{"amount":"50000000000000000000000000","owner_id":"vote1.sweat"}]
    		50000000
    17
    		1118058372024-01-31 22:53:51.850EDhTcZhLsLGjcjs3xD2qUiWXeDDQqQAGwrZoGLhuK6PGGpmZ8CWe8fFLg2WpZZdYigTAKkMGeBDr7A6pPaphqHwCvote1.sweattoken.sweattreasury.sweat0
    {"data":[{"amount":"50000000000000000000000000","owner_id":"vote1.sweat"...
    		nep1413095262546370TRUE4391776d72b984d8145dfcf8349aaee92024-03-07 04:36:19.3852024-03-07 04:36:19.385
    [{"amount":"50000000000000000000000000","owner_id":"vote1.sweat"}]
    		50000000
    18
    		1092573592023-12-31 18:18:33.841AUCVjh6m7nhwSPE5fZfeHPtGxgAGhH1meYCW51hVA6sK2azDY6E8rrgq6LSEurSYTwBkn9eSeoVvY2CUMVcSYgrmvote1.sweattoken.sweattreasury.sweat0
    {"data":[{"amount":"50000000000000000000000000","owner_id":"vote1.sweat"...
    		nep1413080851562836TRUEacf62206363a0682f207c56094b022092024-03-07 04:36:19.3852024-03-07 04:36:19.385
    [{"amount":"50000000000000000000000000","owner_id":"vote1.sweat"}]
    		50000000
    19
    		1068904282023-11-30 21:41:31.6004PbH8ga1YXgdDwUoDwuHBHXafFC4mpCnDdp6babEGQHw5R5JgVLQyTQkBZipYt1FnhUNiBX37aWcZQXR6LKh3pVWvote1.sweattoken.sweattreasury.sweat0
    {"data":[{"amount":"275000000000000000000000000","owner_id":"vote1.sweat...
    		nep1413095220508121TRUEb640165f7b14602e52f10dca79c56a232024-03-07 04:36:19.3852024-03-07 04:36:19.385
    [{"amount":"275000000000000000000000000","owner_id":"vote1.sweat"}]
    		275000000
    20
    		1046336812023-10-31 19:38:34.1039XT3hWTKiy5qgjhpujGGPgD81bSc2jAtHRoFCdgWFA3e3C1siShxw8JLdzPTYvHL6fmB8csr3Vc5WcNRHSTKFxvivote1.sweattoken.sweattreasury.sweat0
    {"data":[{"amount":"261000000000000000000000000","owner_id":"vote1.sweat...
    		nep1413095220508121TRUEa1ea3b359a16de4e0627cc8f313566a82024-03-07 04:36:19.3852024-03-07 04:36:19.385
    [{"amount":"261000000000000000000000000","owner_id":"vote1.sweat"}]
    		261000000
    27
    14KB
    24s