flipside

    opensea sales 2
    jackguyopensea sales 2
    Updated 2024-01-30
    with tab1 as (
    SELECT
    block_timestamp,
    tx_hash,
    case when DECODED_LOG['offer'][0]['token'] IN ('0x4200000000000000000000000000000000000006', '0x0000000000000000000000000000000000000000')then DECODED_LOG['offer'][0]['amount'] end as o1,
    case when DECODED_LOG['offer'][1]['token'] IN ('0x4200000000000000000000000000000000000006', '0x0000000000000000000000000000000000000000') then DECODED_LOG['offer'][1]['amount'] end as o2,
    case when DECODED_LOG['offer'][2]['token'] IN ('0x4200000000000000000000000000000000000006', '0x0000000000000000000000000000000000000000')then DECODED_LOG['offer'][2]['amount'] end as o3,
    case when DECODED_LOG['offer'][3]['token'] IN ('0x4200000000000000000000000000000000000006', '0x0000000000000000000000000000000000000000') then DECODED_LOG['offer'][3]['amount'] end as o4,
    case when DECODED_LOG['offer'][4]['token'] IN ('0x4200000000000000000000000000000000000006', '0x0000000000000000000000000000000000000000')then DECODED_LOG['offer'][4]['amount'] end as o5,
    case when DECODED_LOG['offer'][5]['token'] IN ('0x4200000000000000000000000000000000000006', '0x0000000000000000000000000000000000000000') then DECODED_LOG['offer'][5]['amount'] end as o6,
    case when DECODED_LOG['offer'][6]['token'] IN ('0x4200000000000000000000000000000000000006', '0x0000000000000000000000000000000000000000')then DECODED_LOG['offer'][6]['amount'] end as o7,
    case when DECODED_LOG['offer'][7]['token'] IN ('0x4200000000000000000000000000000000000006', '0x0000000000000000000000000000000000000000') then DECODED_LOG['offer'][7]['amount'] end as o8,
    case when DECODED_LOG['offer'][8]['token'] IN ('0x4200000000000000000000000000000000000006', '0x0000000000000000000000000000000000000000')then DECODED_LOG['offer'][8]['amount'] end as o9,
    case when DECODED_LOG['offer'][9]['token'] IN ('0x4200000000000000000000000000000000000006', '0x0000000000000000000000000000000000000000') then DECODED_LOG['offer'][9]['amount'] end as o10,
    case when DECODED_LOG['consideration'][0]['token'] IN ('0x4200000000000000000000000000000000000006', '0x0000000000000000000000000000000000000000') then DECODED_LOG['consideration'][0]['amount'] end as c1,
    case when DECODED_LOG['consideration'][1]['token'] IN ('0x4200000000000000000000000000000000000006', '0x0000000000000000000000000000000000000000') then DECODED_LOG['consideration'][1]['amount'] end as c2,
    case when DECODED_LOG['consideration'][2]['token'] IN ('0x4200000000000000000000000000000000000006', '0x0000000000000000000000000000000000000000') then DECODED_LOG['consideration'][2]['amount'] end as c3,
    case when DECODED_LOG['consideration'][3]['token'] IN ('0x4200000000000000000000000000000000000006', '0x0000000000000000000000000000000000000000') then DECODED_LOG['consideration'][3]['amount'] end as c4,
    case when DECODED_LOG['consideration'][4]['token'] IN ('0x4200000000000000000000000000000000000006', '0x0000000000000000000000000000000000000000') then DECODED_LOG['consideration'][4]['amount'] end as c5,
    case when DECODED_LOG['consideration'][5]['token'] IN ('0x4200000000000000000000000000000000000006', '0x0000000000000000000000000000000000000000') then DECODED_LOG['consideration'][5]['amount'] end as c6,
    case when DECODED_LOG['consideration'][6]['token'] IN ('0x4200000000000000000000000000000000000006', '0x0000000000000000000000000000000000000000') then DECODED_LOG['consideration'][6]['amount'] end as c7,
    case when DECODED_LOG['consideration'][7]['token'] IN ('0x4200000000000000000000000000000000000006', '0x0000000000000000000000000000000000000000') then DECODED_LOG['consideration'][7]['amount'] end as c8,
    case when DECODED_LOG['consideration'][8]['token'] IN ('0x4200000000000000000000000000000000000006', '0x0000000000000000000000000000000000000000') then DECODED_LOG['consideration'][8]['amount'] end as c9,
    case when DECODED_LOG['consideration'][9]['token'] IN ('0x4200000000000000000000000000000000000006', '0x0000000000000000000000000000000000000000') then DECODED_LOG['consideration'][9]['amount'] end as c10

    FROM base.core.ez_decoded_event_logs
    WHERE contract_address LIKE lower('0x00000000000000ADc04C56Bf30aC9d3c0aAF14dC')
    AND event_name LIKE 'OrderFulfilled'
    ORDER by block_timestamp
    )

    SELECT
    -- date_trunc('hour', block_timestamp) as hour,
    sum(c - o) as nft_sales_volume

    FROM (
    Last run: about 1 year agoAuto-refreshes every 3 hours
    NFT_SALES_VOLUME
    1
    		1696.875107664
    1
    18B
    93s