flipside

    OLAS holders on Base
    Flipside TeamOLAS holders on Base
    Updated 6 days ago

    with t1 as (SELECT address, SUM(holding) AS total_value
    FROM (
    SELECT
    TO_ADDRESS AS address,
    sum(RAW_AMOUNT /1e18 ) AS holding
    FROM base.core.fact_token_transfers
    WHERE contract_address = lower('0x54330d28ca3357F294334BDC454a032e7f353416')
    --and TO_ADDRESS <> lower('0xBA12222222228d8Ba445958a75a0704d566BF2C8')
    GROUP BY 1
    UNION ALL
    SELECT
    FROM_ADDRESS AS address,
    -sum(RAW_AMOUNT /1e18 ) AS holding
    FROM base.core.fact_token_transfers
    WHERE contract_address = lower('0x54330d28ca3357F294334BDC454a032e7f353416')
    --and FROM_ADDRESS <> lower('0xBA12222222228d8Ba445958a75a0704d566BF2C8')
    GROUP BY 1
    )
    GROUP BY 1
    --having sum(holding) > 0.05
    ORDER BY total_value DESC
    )

    select
    address as "Address",
    total_value as "OLAS Balance",
    round(total_value/118370 * 100, 3) as "(%) of Supply"

    from t1
    where total_value > 0
    order by "OLAS Balance" desc


    Last run: 6 days agoAuto-refreshes every 12 hours
    Address
    OLAS Balance
    (%) of Supply
    1
    		0xcddd9d9abab36ffa882530d69c73fee5d4001c2d959066.999020062810.228
    2
    		0xba12222222228d8ba445958a75a0704d566bf2c8816247.641098287689.573
    3
    		0x7d7af0903bcb5e0edeaa04cb1d348f96806e966282161.37675469169.411
    4
    		0xc8f7030a4e25585624e2fc792255a547255cd77c7100059.981
    5
    		0x61030434a8535b649cfe36c5f6194f2b6e9bf24746462.28903364739.252
    6
    		0xca61633b03c54f64b6a7f1f9a9c0a6feb231cc4d33879.26680558528.621
    7
    		0xc99e3c3f2a91aa972f30ee5c93084dad3dd40c4e23513.83000003319.865
    8
    		0xb14cd66c6c601230ea79fa7cc072e5e0c2f3a75622800.0000000219.262
    9
    		0x4d4233ebf0473ca8f34d105a6256a2389176f0ce22800.0000000219.262
    10
    		0x7da5c3878497ba7dc9e3f3fd6735e3f26a110b2a21678.28568099318.314
    11
    		0x708e511d5fcb3bd5a5d42f42aa9a69ec5b0ee2e816519.4821805713.956
    12
    		0x34c895f302d0b5cf52ec0edd3945321eb0f83dd51555013.137
    13
    		0xfdf0e167e6c94c93c8d51c9f46bda6ee5ea4b38414619.78904770512.351
    14
    		0x11bc20025dce07f10ae154587112abcf86875e2510322.1481930568.72
    15
    		0xf6e76bd170097e7f305d9ecd098632ab69b69c0710000.111035298.448
    16
    		0xc362756d13e9dcb2c59ddfc8dc260f100bceb9f48394.8125376717.092
    17
    		0xfa12612a0c2ef2e88861794422d379f1c92f70b46921.455.847
    18
    		0xfb7669c3adf673b3a545fa5acd987dbfda805e226839.999999775.778
    19
    		0x5108d87b6fc032689b9467fbad58c97936e395256116.5667126195.167
    20
    		0x22bb6549ce78be16d5888e833dc5b79357f0c94c6116.0946300015.167
    ...
    15666
    1022KB
    23s