datavortexxenogeneic-gray
    Updated 2025-04-22
    /*
    SELECT * FROM ton.core.fact_jetton_metadata
    where address = '0:B113A994B5024A16719F69139328EB759596C38A25F59028B146FECDC3621DFE'
    limit 5;\
    */
    select * FROM ton.defi.fact_dex_trades
    limit 1
    Last run: about 2 months ago
    BLOCK_TIMESTAMP
    EVENT_TYPE
    TX_HASH
    PROJECT_TYPE
    PROJECT
    POOL_ADDRESS
    VERSION
    TRADER_ADDRESS
    TOKEN_BOUGHT_ADDRESS
    TOKEN_SOLD_ADDRESS
    AMOUNT_BOUGHT_RAW
    AMOUNT_SOLD_RAW
    ROUTER_ADDRESS
    VOLUME_TON
    VOLUME_USD
    REFERRAL_ADDRESS
    PLATFORM_TAG
    TRACE_ID
    QUERY_ID
    EVENT_TIME
    FACT_DEX_TRADES_ID
    INSERTED_TIMESTAMP
    MODIFIED_TIMESTAMP
    1
    2024-08-31 19:27:19.000tradefAnlQK6PSdu4EBBQg3HfCq1J7c3/RRY7rL0xzj0tNZ4=dexston.fi0:9C0FDEB2C07BE55C18EE7F88A1886C87EBA4028477AC372A09490E9628AAA86F10:987CD1DF3185D944D159B06E259FACC790F022881CA378C13102E828753A5F6A0:8CDC1D7640AD5EE326527FC1AD0514F468B30DC84B0173F0E155F451B4E11F7C0:AFC49CB8786F21C87045B19EDE78FC6B46C51048513F8E9A6D44060199C1BF0C7030575813000000000000140:95E99C8DC6A438526DF4961936FF51209F307A28C37C6C78310CE140AB78AB658lpeIkCQgTCJvmGYFrQEE0AD5FGAGWTtz3XohByCfl0=6977118190741725132439bc51f2da8cd211e97beff44f971405eb2025-04-14 14:14:15.5762025-04-14 14:14:15.576
    1
    643B
    2s