flipside

    2024-02-05 07:25 PM
    0xblid2024-02-05 07:25 PM
    Updated 2024-02-06
    SELECT *
    FROM near.core.dim_address_labels
    WHERE PROJECT_NAME = 'metapool'
    LIMIT 100


    SELECT *
    FROM near.core.fact_transactions
    WHERE TX_RECEIVER = 'meta-pool.near' OR
    TX_SIGNER = 'meta-pool.near'
    --WHERE PROJECT_NAME = 'metapool'
    --AND block_timestamp > '2022-01-01'
    LIMIT 100

    Last run: about 1 year ago
    SYSTEM_CREATED_AT
    BLOCKCHAIN
    ADDRESS
    ADDRESS_NAME
    PROJECT_NAME
    LABEL_TYPE
    LABEL_SUBTYPE
    L1_LABEL
    L2_LABEL
    CREATOR
    DIM_ADDRESS_LABELS_ID
    INSERTED_TIMESTAMP
    MODIFIED_TIMESTAMP
    1
    		2023-05-04 20:31:52.000nearmetapool.sputnik-dao.nearmetapool daometapooldappdaodappdaoflipside36413f21cfc8a3ff1086d53f0d37eb472024-01-31 19:58:03.8212024-01-31 19:58:03.821
    2
    		2022-12-01 15:53:20.000nearoperator.meta-pool.nearmetapool operatormetapooldefichadmindefichadminflipside858597ec7887864e5b9e635007a5ae232024-01-31 19:58:03.8212024-01-31 19:58:03.821
    3
    		2022-12-01 15:53:20.000neartreasury.meta-pool.nearmetapool treasury addressmetapooldefitreasurydefitreasuryflipsidee520fb4dbfda74f85f7c9b98a0ca18dd2024-01-31 19:58:03.8212024-01-31 19:58:03.821
    3
    672B
    1s