zakkisyedBSC Chain explorer
9999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
{{ config(
materialized = 'incremental',
unique_key = 'nft_log_id',
cluster_by = ['block_timestamp::DATE']
) }}
WITH seaport_fees_wallet AS (
SELECT
*
FROM
(
VALUES
('0x0000a26b00c1f0df003000390027140000faa719'),
('0x8de9c5a032463c561423387a9648c5c7bcc5bc90'),
('0x5b3256965e7c3cf26e11fcaf296dfc8807c01073')
) t (addresses)
),
raw_decoded_logs AS (
SELECT
*
FROM
{{ ref('silver__decoded_logs') }}
WHERE
block_number >= 42031942
AND contract_address = '0x00000000000000adc04c56bf30ac9d3c0aaf14dc'
AND event_name = 'OrderFulfilled'
{% if is_incremental() %}
AND _inserted_timestamp >= (
SELECT
MAX(
_inserted_timestamp
) :: DATE - 1
FROM
{{ this }}
Run a query to Download Data