Sei AnalysisTransfers and Stakes for Select Addresses -- SEI EVM
    Updated 29 minutes ago
    -- Read Google Sheet
    with res AS (
    SELECT

    livequery.live.udf_api(
    'GET',
    'https://science.flipsidecrypto.xyz/googlesheets/readsheet',
    { 'Content-Type': 'application/json' },
    { 'sheets_id': '1xUNsWuDAsn-8Et4y3RKmqS5L8bWdWKnfqQDmC0l6kso',
    'tab_name': 'ERC' }
    ) as result
    from
    DUAL
    ),
    data AS (
    select
    result:data as json_result_must_pivot
    from
    res
    ),
    sei_prices as (
    Select
    TO_DATE(value [0] :: string) as hour,
    'SEI' as token,
    avg(value [1]) as avg_price
    from
    (
    SELECT
    livequery.live.udf_api(
    'https://api.coingecko.com/api/v3/coins/sei-network/market_chart?vs_currency=usd&days=365'
    ) as resp
    ),
    LATERAL FLATTEN (input => resp:data:prices)
    group by
    all
    ),
    Last run: 29 minutes agoAuto-refreshes every 24 hours
    TX_ID
    TRANSACTION_TYPE
    BLOCK_TIMESTAMP
    BLOCK_DATE
    DAY
    MONTH
    YEAR
    TIME
    DIRECTION
    FROM_ADDRESS
    FROM_NAME
    FROM_TYPE
    TO_ADDRESS
    TO_NAME
    TO_TYPE
    AMOUNT
    TOKEN_PRICE
    AMOUNT_USD
    FEE
    TOKEN_NAME
    GL_CODE
    BLOCKHEIGHT
    IS_INTERNAL
    IS_INTERNAL_RELATED_PARTY
    1
    0x25ff0ebe754bec74d9ae5ca4890c4b5a19048683085f91fccc4a2fd446327946transfer out2025-06-13 14:09:04.0002025-06-13 00:00:00.000136202514:09:04outgoing0x95e9605276d8b4118d5076c150eaee0de2fa2453Arman Compass 2 (EVM)internal0x5f0795a28de013db99443ef491890d3877e333e210.170.170.00002314138669SEI152042128NN
    2
    0xbb919e4d2cafe4afa77c4dcc969ae830834790fa3a7fc697bdb2635b0d7f3a8ctransfer out2025-06-11 22:54:38.0002025-06-11 00:00:00.000116202522:54:38outgoing0x95e9605276d8b4118d5076c150eaee0de2fa2453Arman Compass 2 (EVM)internal0x71b4d69878ae7bb2f46fce0d8d54cdbb502ecb24100.2032.030.0000231SEI151765851NN
    3
    0x27ca8275068ad8eb939dd0b5dcf91521f3f38d3ceb8bbf6d777031eb1e4dad49transfer out2025-06-11 19:02:51.0002025-06-11 00:00:00.000116202519:02:51outgoing0x95e9605276d8b4118d5076c150eaee0de2fa2453Arman Compass 2 (EVM)internal0xa04f01523b8382d28074cb069ffa48042b0fff2a1.50.20666666670.310.0000231SEI151738359NN
    4
    0x24db25c0bb60c78f84499f5e7afd93a1d1592faae09619df8f1bec60dd3c2f83transfer out2025-06-09 21:06:43.0002025-06-09 00:00:00.00096202521:06:43outgoing0x95e9605276d8b4118d5076c150eaee0de2fa2453Arman Compass 2 (EVM)internal0x012af2e7d702b0d7eb2aa10d83b18f59db31a6961300000.19190124947.130.00002992449862SEI151419234NN
    5
    0x5301aaf8df041c8457de79146076f8919549ca5dc0efc4f84b38605a8c653591transfer out2025-06-09 19:22:25.0002025-06-09 00:00:00.00096202519:22:25outgoing0x95e9605276d8b4118d5076c150eaee0de2fa2453Arman Compass 2 (EVM)internal0x012af2e7d702b0d7eb2aa10d83b18f59db31a6961300000.19253525029.550.000022407SEI151407450NN
    6
    0x90d5044c00a3d115a9cd4a3276e4231dadc74f4cb35f47206489cfcc746e44eatransfer out2025-06-09 19:20:37.0002025-06-09 00:00:00.00096202519:20:37outgoing0x95e9605276d8b4118d5076c150eaee0de2fa2453Arman Compass 2 (EVM)internal0x0df28752e1d23b9360364c7f03fcf4fe161c0da3648000.192535030912476.270.00002239629808SEI151407244NN
    7
    0xa851f13d4134c50d180188bfcc6d4db4a71f2806365184d9b8552652c7064c2dtransfer out2025-06-09 19:11:13.0002025-06-09 00:00:00.00096202519:11:13outgoing0x95e9605276d8b4118d5076c150eaee0de2fa2453Arman Compass 2 (EVM)internal0x304f52b86d670e794140bf53cb491a0c0531aff0131340.19253464292528.750.000022407SEI151406161NN
    8
    0x80b62a86a987a408029381d24aa09b9febbeddc6b2e883deecd7c8bb064ae55btransfer out2025-06-09 19:08:01.0002025-06-09 00:00:00.00096202519:08:01outgoing0x95e9605276d8b4118d5076c150eaee0de2fa2453Arman Compass 2 (EVM)internal0x441bc84aa07a71426f4d9a40bc40ac7183d124b95200.1925384615100.120.000022407SEI151405795NN
    9
    0x7ad3b73b2b62a4e07f9de29c8d9cbfb32becdaa401cabea38a41049f5566e4b3transfer out2025-06-06 16:23:50.0002025-06-06 00:00:00.00066202516:23:50outgoing0x95e9605276d8b4118d5076c150eaee0de2fa2453Arman Compass 2 (EVM)internal0x304f52b86d670e794140bf53cb491a0c0531aff0530000.189016037710017.850.0000231SEI150909433NN
    10
    0x9c1b38ca65ba029b50661ebae8c374286242bde663ab8854f9ff36ca41d6665etransfer out2025-06-05 00:55:50.0002025-06-05 00:00:00.00056202500:55:50outgoing0x95e9605276d8b4118d5076c150eaee0de2fa2453Arman Compass 2 (EVM)internal0xeafca51e7b3050cb4e1a96b36aef0c37704c0d5e25800000.194136500870.880.0000231SEI150645038NN
    11
    0x369bdacd7e13d6cf5684ee2998b06a461f44d0d728a5c243e721e0162a669efdtransfer out2025-06-04 16:05:49.0002025-06-04 00:00:00.00046202516:05:49outgoing0x95e9605276d8b4118d5076c150eaee0de2fa2453Arman Compass 2 (EVM)internal0xff75c2a2660bd0701deabf1892e1cffd553dd22188730560.19660699991744504.920.0000231SEI150585716NN
    12
    0x873f184ea01f6cd1ac17246f6b8c0daac17b497a86ac60343df95d4e8c9f6daatransfer out2025-06-04 15:13:03.0002025-06-04 00:00:00.00046202515:13:03outgoing0x95e9605276d8b4118d5076c150eaee0de2fa2453Arman Compass 2 (EVM)internal0xff75c2a2660bd0701deabf1892e1cffd553dd22110.20.20.0000231SEI150579653NN
    13
    0x9f7309f4ff7d4c29154ae399f79d214681204f259552e74cfeb680b85763f81etransfer out2025-06-03 03:46:36.0002025-06-03 00:00:00.00036202503:46:36outgoing0x95e9605276d8b4118d5076c150eaee0de2fa2453Arman Compass 2 (EVM)internal0x6cfb7ebabb4817ce2d3e5d7e1f8ec2357496c20dKeyrockexternal49900000.2031591013763.410.00002310255505SEIMM150341738NN
    14
    0x601c41ba1a7d2ec65a4f00ce6d65bb9f9eda9fc2638667517854a2d3424e14eetransfer out2025-06-03 03:43:29.0002025-06-03 00:00:00.00036202503:43:29outgoing0x95e9605276d8b4118d5076c150eaee0de2fa2453Arman Compass 2 (EVM)internal0xee5d872058e2f2fe10767e78f548d7ca6f5088a819350630.2031589979393125.460.00003007113433SEI150341436NN
    15
    0x4162b1076a37db43163d31441f1689d6866c8e67f7168a22bba42cfbe6adbcdftransfer out2025-06-02 14:49:14.0002025-06-02 00:00:00.00026202514:49:14outgoing0x95e9605276d8b4118d5076c150eaee0de2fa2453Arman Compass 2 (EVM)internal0xee5d872058e2f2fe10767e78f548d7ca6f5088a810.190.190.00002861943553SEI150258076NN
    16
    0x3f94ddd0a760f621ba280aacda6a06f53b70902dc7658c873112cd1e7626a290transfer out2025-05-30 15:01:59.0002025-05-30 00:00:00.000305202515:01:59outgoing0x95e9605276d8b4118d5076c150eaee0de2fa2453Arman Compass 2 (EVM)internal0x8cce1afe2c45f63bc4ec022f2db02984c4e9293e4926000.2032100081100101.250.000021945SEI149789814NN
    17
    0x5dc1c6abe06efc21f372a451dcb04a153659199ae03f9f15ebaea60709da9384transfer out2025-05-30 02:29:25.0002025-05-30 00:00:00.000305202502:29:25outgoing0x95e9605276d8b4118d5076c150eaee0de2fa2453Arman Compass 2 (EVM)internal0xe0b1e2468c687ea19652d85d89a81254d657a49411962000.2120110015253607.560.00002195733813SEI149706541NN
    18
    0x391a5d4eeab781a1914fcde896ddb65dcca3a2f39931b602a1fc89831bcbcbe0transfer out2025-05-30 01:17:07.0002025-05-30 00:00:00.000305202501:17:07outgoing0x95e9605276d8b4118d5076c150eaee0de2fa2453Arman Compass 2 (EVM)internal0xe0b1e2468c687ea19652d85d89a81254d657a49410.210.210.00002854492026SEI149698680NN
    19
    0xb56e63a19d9aacd763d633599c24822488ce864875a3498b7b6bfbf26c30f60ctransfer out2025-05-28 18:24:19.0002025-05-28 00:00:00.000285202518:24:19outgoing0x95e9605276d8b4118d5076c150eaee0de2fa2453Arman Compass 2 (EVM)internal0x8cce1afe2c45f63bc4ec022f2db02984c4e9293e10.220.220.000021945SEI149494935NN
    20
    0x0bc1e913c8519c4fb6bc8167b1ec31e362de856fbc3058a241fe02a1163079adtransfer out2025-05-26 18:56:33.0002025-05-26 00:00:00.000265202518:56:33outgoing0x95e9605276d8b4118d5076c150eaee0de2fa2453Arman Compass 2 (EVM)internal0x7fcbd9d429932a11884cb5ce9c61055b369f56f761763850.22171199981369378.670.000021945SEI149188232NN
    ...
    365
    130KB
    20s