flipside

    Tokens on Tama.Meme based on Buy and Sell Volumes
    pepperatziTokens on Tama.Meme based on Buy and Sell Volumes
    Updated 2025-02-17
    --Trade --TokenCreated --TokenMigrated --FirstBuyerFeePaid
    with raw as (
    select
    block_timestamp,
    tx_hash,
    '0x'|| substr(topics[1], 27) as token_address,
    '0x'|| substr(topics[2], 27) as creator,
    regexp_substr_all(substr(data, 3), '.{64}') as segmented,
    livequery.utils.udf_hex_to_int(segmented[7]) * 2 as one,
    livequery.utils.udf_hex_to_int(segmented[9]) * 2 as two,
    livequery.utils.udf_hex_to_int(segmented[11]) * 2 as three,
    from ronin.core.fact_event_logs
    where contract_address = '0xa54b0184d12349cf65281c6f965a74828ddd9e8f'
    and topics[0] = '0xf372df0af3c16a1deb41b25691dd807a3836ba8f443e83d24c1406ae3748232e'
    ),

    tokencreated as (
    SELECT
    block_timestamp as created_date,
    tx_hash as created_transaction,
    token_address,
    datediff('day', block_timestamp, current_date) as created_interval,
    creator,
    livequery.utils.udf_hex_to_string(left(segmented[8], one)) as token_created,
    livequery.utils.udf_hex_to_string(left(segmented[10], two)) as symbol,
    livequery.utils.udf_hex_to_string(left(segmented[12], three)) as description
    from raw
    ),

    -- 1 is buy
    --0 is sell
    trades as (
    SELECT
    block_timestamp,
    tx_hash,
    origin_from_address as user,
    Last run: about 2 months ago
    TOKEN
    TOKEN_CREATED
    SYMBOL
    CREATED_INTERVAL
    TOTAL_USERS_INTERACTED
    BUY_VOLUME
    SELL_VOLUME
    1
    		0x81b2afc98db9c320eceef15870b317f4e8c766d3PantsuPANTSU231686291478.38287705.63
    2
    		0xe4b083c1732f388482adc4b251250e9944da1118Hantai ParadiseHANTAI261741252915.84247701.48
    3
    		0xf988f63bf26c3ed3fbf39922149e3e7b1e5c27cbRonin MonkeRonke231210242162.93223744.64
    4
    		0x5a53627f60f548163db7c06790cc8fae45ace6d8Axie InuAXI211324235368.13218533.09
    5
    		0x68a3a99b482b5f21b59557b766c1bf720df0f256FartFART271389234116.44230884.6
    6
    		0x88e9592b54e92b45a4e613da2824b532a5b725cfTrump Kongtrumpkong271706197440.65178732.68
    7
    		0xc76ee1b384a4c3c692d56f677a6f8a8842098988UglyAsianGirlUAG251639194020.6189042.76
    8
    		0x42251728e637f664751f1d21f36f22dac41ca381DETECTIVEDETECTIVE261232190985.24172971.39
    9
    		0x1329661fc0531ff63fd912346e8340c000bf16f4WOKI GENESIS COLLECTIONWOKU211469188781.76185365.63
    10
    		0x0bf9ee1118b245f471bc388fd550a9374f6108fcBRONINBRN221169186740.56183664.83
    11
    		0x214b8ba88244587b69c609214e0b3e6cf56025d1NOTUSNOTUS271505185423.43179950.64
    12
    		0x024ac9ebfadf58b9427b97b489b33349c8313b3bMochi InuMINU191234184050.38179702.6
    13
    		0xad4445e4a854f4497fb54331e9717f702126299aRANGARANGA271269173916.44170719.63
    14
    		0x0f1d1ee52f9809d4bebb04b131027cb4597c0dabSteamboat Mickey 1928MIKEY221128173340.56156408.65
    15
    		0x7d1f2854f92fda5532ab8262c650663163cc4ff9MillioMILLIO271332160951.72158512.37
    16
    		0x3370df8886d0beaede6f7e148ab01aae301ec155MUG MATESMUG261006158292.63142402.66
    17
    		0xfaaef3b09a3165aada1cd2816e3f74d85668f433Dump ForestDF271108152482.16139183.08
    18
    		0xcfb937a0a3162734a2535a6bb3c330c286b32149JinaJina5909151526.86147619.44
    19
    		0xbe83838c8bc9232d2cf2d67d37b657e1a85c0de5KROGKROG21644147500.53131042.79
    20
    		0x564fe5c73a32653a5df71d9e40265ba38b6fc40dbahtbaht241030147421.49145158.05
    ...
    17252
    1MB
    33s