flipside

    opensea sales 1
    jackguyopensea sales 1
    Updated 2024-01-29
    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
    HOUR
    NFT_SALES_VOLUME
    1
    		2023-11-29 22:00:00.0000.366705888
    2
    		2023-10-21 14:00:00.0000.152576299
    3
    		2023-08-20 11:00:00.0000.7968871
    4
    		2023-08-20 15:00:00.0000.2648964567
    5
    		2023-08-09 23:00:00.0009.31994988
    6
    		2023-11-18 10:00:00.0000.13052439
    7
    		2023-12-06 09:00:00.0000.1596253
    8
    		2023-10-19 07:00:00.0000.01831787
    9
    		2023-12-12 22:00:00.0000.0973855
    10
    		2023-09-30 21:00:00.0000.023187
    11
    		2024-01-26 09:00:00.00064.7710379
    12
    		2023-09-10 02:00:00.0000.212524299
    13
    		2023-09-03 21:00:00.0000.5258685001
    14
    		2023-11-08 18:00:00.0000.0347175
    15
    		2023-08-11 00:00:00.0001.137064533
    16
    		2024-01-01 15:00:00.0000.164314897
    17
    		2023-09-16 00:00:00.0000.207848
    18
    		2023-08-29 22:00:00.0001.85934106
    19
    		2023-10-05 23:00:00.000-0.0421503
    20
    		2023-09-06 08:00:00.0000.5958381942
    ...
    4312
    163KB
    14s