flipside

    Transfers and Stakes for Select Addresses -- SEI EVM
    Sei AnalysisTransfers and Stakes for Select Addresses -- SEI EVM
    Updated 7 hours 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: about 7 hours 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
    		0x8a3b91f2a18c284431c76eb4cc8fabf4565fede6779fab48d7a3451eb98b3b6btransfer out2025-04-23 01:23:44.0002025-04-23 00:00:00.000234202501:23:44outgoing0x95e9605276d8b4118d5076c150eaee0de2fa2453Arman Compass 2 (EVM)internal0x0df28752e1d23b9360364c7f03fcf4fe161c0da31315800.189512007924935.990.00002625000105SEI143489353NN
    2
    		0xb6dd0addebfe7f6f7dca3696847349f8620dba00085f5915bed089af5ec32d3dtransfer out2025-04-17 19:46:26.0002025-04-17 00:00:00.000174202519:46:26outgoing0x95e9605276d8b4118d5076c150eaee0de2fa2453Arman Compass 2 (EVM)internal0xcaf0081584753def171221344b1af2ed785043f72385200.170341983940629.970.00002541SEI142592892NN
    3
    		0xf95195d70b352b93996a63455b6f8bbd50a21ca51c6f096ca7c6472023ac2752transfer out2025-04-17 19:45:11.0002025-04-17 00:00:00.000174202519:45:11outgoing0x95e9605276d8b4118d5076c150eaee0de2fa2453Arman Compass 2 (EVM)internal0x304f52b86d670e794140bf53cb491a0c0531aff0643780.170342042310966.280.00002541SEI142592742NN
    4
    		0xf0c678499acd83f72cb3efe1b072f8918078d55d73ab9cb3e700e71207abe322transfer in2025-04-16 16:09:40.0002025-04-16 00:00:00.000164202516:09:40incoming0x629539454f8c8fa5a98b8c366f904a04559371380x95e9605276d8b4118d5076c150eaee0de2fa2453Arman Compass 2 (EVM)internal657311.608171657311.608170.000071170069USDC142395460NN
    5
    		0x29db117c1dc3fd4ca078c75f2be4c879eb481cb0faf142ed73f27689181a4043transfer in2025-04-16 16:07:37.0002025-04-16 00:00:00.000164202516:07:37incoming0x4b8c1ccb589903af6b459f8bcdf96d0b2a1a4ef00x95e9605276d8b4118d5076c150eaee0de2fa2453Arman Compass 2 (EVM)internal4000000.00000214000000.0000020.00006473045857USDC142395210NN
    6
    		0xf210bfe81e9ba5ac93f535c63de0c138efbfd3cae733a25b995ca082d6a57ba1transfer in2025-04-16 16:03:05.0002025-04-16 00:00:00.000164202516:03:05incoming0x629539454f8c8fa5a98b8c366f904a04559371380x95e9605276d8b4118d5076c150eaee0de2fa2453Arman Compass 2 (EVM)internal2000000120000000.000071515624USDC142394657NN
    7
    		0x8dfeaec7fc466676c760f6f79a98de39e671fba4e51573289f6dcca5a93975bftransfer in2025-04-16 16:01:18.0002025-04-16 00:00:00.000164202516:01:18incoming0x629539454f8c8fa5a98b8c366f904a04559371380x95e9605276d8b4118d5076c150eaee0de2fa2453Arman Compass 2 (EVM)internal1110.000071064757USDC142394439NN
    8
    		0x6ee4370e180d38f643241acede432b353c7ae6cdd545175d18d0e0b872169f7atransfer out2025-04-16 15:56:15.0002025-04-16 00:00:00.000164202515:56:15outgoing0x95e9605276d8b4118d5076c150eaee0de2fa2453Arman Compass 2 (EVM)internal0x57475770bc41c817ea607c2ed757ea006db4adda21053000.1687289982355225.160.0000252SEI142393827NN
    9
    		0xa06bb25ab50a4bd4ec52024c46ee25b172b3369c10b471c8b69f7a1e5852a59atransfer out2025-04-16 15:54:51.0002025-04-16 00:00:00.000164202515:54:51outgoing0x95e9605276d8b4118d5076c150eaee0de2fa2453Arman Compass 2 (EVM)internal0x00a5ebdeaf111b5f247b69ca99cd87ef7a3ed1ee58480000.1687289997986727.190.0000231SEI142393659NN
    10
    		0x47a3af9ccf888e1a7564162508c8fef3beb3d8b314006ede1bc78b0f14629d5dtransfer out2025-04-16 15:53:52.0002025-04-16 00:00:00.000164202515:53:52outgoing0x95e9605276d8b4118d5076c150eaee0de2fa2453Arman Compass 2 (EVM)internal0x8cce1afe2c45f63bc4ec022f2db02984c4e9293e5848000.168729001498672.720.00003465SEI142393539NN
    11
    		0x61656914a3a62590416e49a8754e8d2535ceb3bf0c42ed936529bde512c05909transfer out2025-04-15 14:54:07.0002025-04-15 00:00:00.000154202514:54:07outgoing0x95e9605276d8b4118d5076c150eaee0de2fa2453Arman Compass 2 (EVM)internal0xee5d872058e2f2fe10767e78f548d7ca6f5088a818050000.1792770028323594.990.000054658SEI142214156NN
    12
    		0xc9215243a3f768e930067364ae799b86dc256133f1fc4d3a1cc5239ad72b98aftransfer out2025-04-14 16:13:11.0002025-04-14 00:00:00.000144202516:13:11outgoing0x95e9605276d8b4118d5076c150eaee0de2fa2453Arman Compass 2 (EVM)internal0x7fcbd9d429932a11884cb5ce9c61055b369f56f796588960.18360700021773440.920.0000231SEI142048339NN
    13
    		0x6801dc30ebda365a5a61185ff401b037b4bd6c836b6510605a9d818172007695transfer out2025-04-14 14:47:40.0002025-04-14 00:00:00.000144202514:47:40outgoing0x95e9605276d8b4118d5076c150eaee0de2fa2453Arman Compass 2 (EVM)internal0x7fcbd9d429932a11884cb5ce9c61055b369f56f710.180.180.00003465SEI142038145NN
    14
    		0x8373a1747aed4a5424cbafc3e7a815534734810d6c5204652a6dbb093bb6916ftransfer out2025-04-10 21:31:33.0002025-04-10 00:00:00.000104202521:31:33outgoing0x95e9605276d8b4118d5076c150eaee0de2fa2453Arman Compass 2 (EVM)internal0xf7333669508467c242c69722b511f40bd19de12367114100.1487539995998349.080.0000231SEI141405273NN
    15
    		0x6ed20f2893fdc4787b47c85f2d972baf559ac715670f0c3c7f5be009db6ca563transfer out2025-04-10 16:19:00.0002025-04-10 00:00:00.000104202516:19:00outgoing0x95e9605276d8b4118d5076c150eaee0de2fa2453Arman Compass 2 (EVM)internal0xe0b1e2468c687ea19652d85d89a81254d657a4943392150.151863007251514.210.00002629075535SEI141366723NN
    16
    		0xad05f63914207a49cdf8ae0e158f2642a07510f3e1fb09a772275b8e672b0bedtransfer out2025-04-04 02:31:17.0002025-04-04 00:00:00.00044202502:31:17outgoing0x95e9605276d8b4118d5076c150eaee0de2fa2453Arman Compass 2 (EVM)internal0xf7333669508467c242c69722b511f40bd19de123100000000.16430216430200.0000252SEI140216360NN
    17
    		0x5ae5e89de6259e37b294fc5fc19d1c724ba1b5b46af9b59c5ce3134d7f169784transfer out2025-04-04 02:30:17.0002025-04-04 00:00:00.00044202502:30:17outgoing0x95e9605276d8b4118d5076c150eaee0de2fa2453Arman Compass 2 (EVM)internal0x62e071c6d1295a6ad82be810ded285269b3b87bc181818180.16430199992987309.060.00002310273962SEI140216229NN
    18
    		0x60e4d9a4981df1a469e9758657f04486257f7830376537f75b1fa7d3ba278d47transfer out2025-04-03 19:50:00.0002025-04-03 00:00:00.00034202519:50:00outgoing0x95e9605276d8b4118d5076c150eaee0de2fa2453Arman Compass 2 (EVM)internal0xe0b1e2468c687ea19652d85d89a81254d657a4941543200.161074002124856.940.0000231SEI140165418NN
    19
    		0x123de68d2c189c3c29192d9c620103e09cefb02bb73289e0eca79a9a1ff56312transfer out2025-04-03 19:47:15.0002025-04-03 00:00:00.00034202519:47:15outgoing0x95e9605276d8b4118d5076c150eaee0de2fa2453Arman Compass 2 (EVM)internal0x3b47b6a52e2c5bd4ca23ef7295af7c435e63fc9230865000.1610739997497154.90.0000315SEI140165052NN
    20
    		0x111778b8cce98272963689c5112183e8640bcb6457409c74fb44748258d4f3batransfer out2025-04-02 19:02:29.0002025-04-02 00:00:00.00024202519:02:29outgoing0x95e9605276d8b4118d5076c150eaee0de2fa2453Arman Compass 2 (EVM)internal0x62e071c6d1295a6ad82be810ded285269b3b87bc70000000.17366812156760.00002317518414SEI139968879NN
    ...
    324
    115KB
    27s