flipside

    fit-gold
    SocioAnalyticafit-gold
    Updated 2025-02-07
    SELECT *
    FROM aptos.core.fact_events
    WHERE tx_hash in ('0xb46fe23f1f25ca55211af3f980df109073a0ca4bdbb4915bbf3e51c247e6ef16','0xf2f7c4b3d45e17e0fce8a10ea04058303d6bbb9685aeb5c241696a3cf70dd9af')


    SELECT event_data:integrator,
    event_data:order_type,
    event_data:x_type_info,
    case when event_data:side = 'true' then 'sell' else 'buy' end as trade_type,
    sum( then event_data:price*event_data:size elce 0 end) as
    count(DISTINCT event_data:user) as n_user,
    count(DISTINCT tx_hash) as count
    FROM aptos.core.fact_events
    WHERE event_resource = 'PlaceLimitOrderEvent'
    AND event_data:market_id = '7'
    GROUP BY 1,2,3
    Last run: 2 months ago
    BLOCK_NUMBER
    BLOCK_TIMESTAMP
    VERSION
    TX_HASH
    SUCCESS
    TX_TYPE
    PAYLOAD_FUNCTION
    EVENT_INDEX
    EVENT_TYPE
    EVENT_ADDRESS
    EVENT_MODULE
    EVENT_RESOURCE
    EVENT_DATA
    ACCOUNT_ADDRESS
    CREATION_NUMBER
    SEQUENCE_NUMBER
    FACT_EVENTS_ID
    INSERTED_TIMESTAMP
    MODIFIED_TIMESTAMP
    1
    		2874386542025-02-07 17:15:02.36323361316370xf2f7c4b3d45e17e0fce8a10ea04058303d6bbb9685aeb5c241696a3cf70dd9afTRUEuser_transaction
    0x1c3206329806286fd2223647c9f9b130e66baeb6d7224a18c1f642ffe48f3b4c::pano...
    		1
    0x1c3206329806286fd2223647c9f9b130e66baeb6d7224a18c1f642ffe48f3b4c::pano...
    		0x1c3206329806286fd2223647c9f9b130e66baeb6d7224a18c1f642ffe48f3b4cpanora_tradePlaceLimitOrderEvent
    {"integrator":"0xd0b17bea776bb87b70b2fb2ca631014f0ca94fc1acde4b8ff1a763f...
    		0x1c3206329806286fd2223647c9f9b130e66baeb6d7224a18c1f642ffe48f3b4c1571701a455c514b41af34e27ac24484996fc22025-02-07 17:32:44.0082025-02-07 17:32:44.008
    2
    		2873864212025-02-07 14:19:35.04123355751030xb46fe23f1f25ca55211af3f980df109073a0ca4bdbb4915bbf3e51c247e6ef16TRUEuser_transaction
    0x1c3206329806286fd2223647c9f9b130e66baeb6d7224a18c1f642ffe48f3b4c::pano...
    		20x1::transaction_fee::FeeStatement0x1transaction_feeFeeStatement
    {"execution_gas_units":"25","io_gas_units":"7","storage_fee_octas":"0","...
    		0x000fe20f7ba09760fbe96e660fb079b47cf2025-02-07 14:33:27.0162025-02-07 14:33:27.016
    3
    		2873864212025-02-07 14:19:35.04123355751030xb46fe23f1f25ca55211af3f980df109073a0ca4bdbb4915bbf3e51c247e6ef16TRUEuser_transaction
    0x1c3206329806286fd2223647c9f9b130e66baeb6d7224a18c1f642ffe48f3b4c::pano...
    		0
    0xc0deb00c405f84c85dc13442e305df75d1288100cdd82675695f6148c7ece51c::user...
    		0xc0deb00c405f84c85dc13442e305df75d1288100cdd82675695f6148c7ece51cuserPlaceLimitOrderEvent
    {"custodian_id":"0","integrator":"0xd0b17bea776bb87b70b2fb2ca631014f0ca9...
    		0x7b3f26e5238e7928255b54c0eb9b269be875a2b6c83215a8e1c6ef9c230b67d64714092492d3cb481629f05dbbc07a4155c882025-02-07 14:33:27.0162025-02-07 14:33:27.016
    4
    		2873864212025-02-07 14:19:35.04123355751030xb46fe23f1f25ca55211af3f980df109073a0ca4bdbb4915bbf3e51c247e6ef16TRUEuser_transaction
    0x1c3206329806286fd2223647c9f9b130e66baeb6d7224a18c1f642ffe48f3b4c::pano...
    		1
    0x1c3206329806286fd2223647c9f9b130e66baeb6d7224a18c1f642ffe48f3b4c::pano...
    		0x1c3206329806286fd2223647c9f9b130e66baeb6d7224a18c1f642ffe48f3b4cpanora_tradePlaceLimitOrderEvent
    {"integrator":"0xd0b17bea776bb87b70b2fb2ca631014f0ca94fc1acde4b8ff1a763f...
    		0x1c3206329806286fd2223647c9f9b130e66baeb6d7224a18c1f642ffe48f3b4c157168d736c9c8b88e2429624555e5ba1167042025-02-07 14:33:27.0162025-02-07 14:33:27.016
    5
    		2874386542025-02-07 17:15:02.36323361316370xf2f7c4b3d45e17e0fce8a10ea04058303d6bbb9685aeb5c241696a3cf70dd9afTRUEuser_transaction
    0x1c3206329806286fd2223647c9f9b130e66baeb6d7224a18c1f642ffe48f3b4c::pano...
    		0
    0xc0deb00c405f84c85dc13442e305df75d1288100cdd82675695f6148c7ece51c::user...
    		0xc0deb00c405f84c85dc13442e305df75d1288100cdd82675695f6148c7ece51cuserPlaceLimitOrderEvent
    {"custodian_id":"0","integrator":"0xd0b17bea776bb87b70b2fb2ca631014f0ca9...
    		0x7b3f26e5238e7928255b54c0eb9b269be875a2b6c83215a8e1c6ef9c230b67d6471438512e1db96ac2f62c09065d70d5bbe862025-02-07 17:32:44.0082025-02-07 17:32:44.008
    6
    		2874386542025-02-07 17:15:02.36323361316370xf2f7c4b3d45e17e0fce8a10ea04058303d6bbb9685aeb5c241696a3cf70dd9afTRUEuser_transaction
    0x1c3206329806286fd2223647c9f9b130e66baeb6d7224a18c1f642ffe48f3b4c::pano...
    		20x1::transaction_fee::FeeStatement0x1transaction_feeFeeStatement
    {"execution_gas_units":"22","io_gas_units":"7","storage_fee_octas":"0","...
    		0x00050163537fae66c5860052f773fbc449c2025-02-07 17:32:44.0082025-02-07 17:32:44.008
    6
    5KB
    5s