Updated 2025-02-17
    select *
    from stellar.core.dim_labels
    where label_type = 'dex'



    select *
    from stellar.core.fact_transactions
    where transaction_hash = '0x6aa62afabaa035ec5ff9fe225daa22ca29729a1ea5fff092e462768accebe630'

    Last run: 28 days ago
    BLOCKCHAIN
    CREATOR
    ADDRESS
    LABEL_TYPE
    LABEL_SUBTYPE
    LABEL
    ADDRESS_NAME
    DIM_LABELS_ID
    INSERTED_TIMESTAMP
    MODIFIED_TIMESTAMP
    1
    stellarflipsideGAEGOS7I6TYZSVHPSN76RSPIVL3SELATXZWLFO4DIAFYJF7MPAHFE7H4dexgeneral_contractpapayapapaya8bfedae1caded8b9f163b52a1e50a1612025-02-12 02:51:06.4582025-02-15 02:47:26.291
    2
    stellarflipsideGBR3RS2Z277FER476OFHFXQJRKYSQX4Z7XNWO65AN3QPRUANUASANG3Ldexgeneral_contractpapayapapayabot45e5fbcfc8e84c1e9828bd0904c9a92a2025-02-12 02:51:06.4582025-02-15 02:47:26.291
    3
    stellarflipsideGAUTUYY2THLF7SGITDFMXJVYH3LHDSMGEAKSBU267M2K7A3W543CKUEFdexgeneral_contractpapayapapayae5b8a65ecf74af85bac3f405692458ec2025-02-12 02:51:06.4582025-02-15 02:47:26.291
    4
    stellarflipsideGC5LOR3BK6KIOK7GKAUD5EGHQCMFOGHJTC7I3ELB66PTDFXORC2VM5LPdexgeneral_contractpapayapapaya5ab070e7031d6333b296fd9498e773e22025-02-12 02:51:06.4582025-02-15 02:47:26.291
    5
    stellarflipsideGBVAOIACNSB7OVUXJYC5UE2D4YK2F7A24T7EE5YOMN4CE6GCHUTOUQXMdexgeneral_contractvcbearvcbearf35dda9d2104c77ee7de48716a6f4a002025-02-12 02:51:06.4582025-02-15 02:47:26.291
    6
    stellarflipsideGDFI6NFZR6QXPEX7RRVSIWBQHROGR4JYFT4ZJISKAFUPQQF33DRDR7C5dexgeneral_contractsimpleswapsimpleswap6bf505ccd4ef7b90920d697c235c50572025-02-12 02:51:06.4582025-02-15 02:47:26.291
    7
    stellarflipsideGC5AD5DUPU5HOHLVARBR7S7JE6EOXZQF5Z4OP3IZA4KMIIDULOEB6GRYdexgeneral_contractsimpleswapsimpleswap3d69b73616070c8022864645c60bffb12025-02-12 02:51:06.4582025-02-15 02:47:26.291
    8
    stellarflipsideGDQQ56KG2RSSL6H4CNSZM4BCUDOWS2PM5DWROR6K7RGPHVUQDILUXD6Tdexgeneral_contractsimpleswapsimpleswap6d3184209489fb5237d21d0faf3ad5602025-02-12 02:51:06.4582025-02-15 02:47:26.291
    9
    stellarflipsideGDXTJEK4JZNSTNQAWA53RZNS2GIKTDRPEUWDXELFMKU52XNECNVDVXDIdexgeneral_contractvcbearvcbear3dc1de5920666a360a3e7b419346c3042025-02-12 02:51:06.4582025-02-15 02:47:26.291
    10
    stellarflipsideGBDEVU63Y6NTHJQQZIKVTC23NWLQVP3WJ2RI2OTSJTNYOIGICST6DUXRdexgeneral_contractpapayapapaya521202764f626650ec1d9e55b8ad28b72025-02-12 02:51:06.4582025-02-15 02:47:26.291
    11
    stellarflipsideGBGVRE5DH6HGNYNLWQITKRQYGR4PWQEH6MOE5ELPY3I4XJPTZ7CVT4YWdexgeneral_contractpapayapapayaswap7362d6f27ea30fda4ed03a05644480b62025-02-12 02:51:06.4582025-02-15 02:47:26.291
    12
    stellarflipsideGA7FCCMTTSUIC37PODEL6EOOSPDRILP6OQI5FWCWDDVDBLJV72W6RINZdexgeneral_contractvcbearvcbeara06f98a4b8d9cc32de78d6c796dd79622025-02-12 02:51:06.4582025-02-15 02:47:26.291
    12
    3KB
    1s