denze-e7j2NURoyalties
Updated 2023-11-08
99
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
›
⌄
WITH
contract AS (
SELECT
*
FROM VALUES
(lower('0x300e7a5fb0ab08af367d5fb3915930791bb08c2b'))
AS data(nft_contract_address)
)
, input_token_ids AS (
SELECT distinct
F.value AS input_token_ids_num
, 'tid' || F.value || '_' AS input_token_ids_string
FROM (
SELECT
SPLIT(data.input_token_id_list, '_') AS input
FROM VALUES
('{{royalty_token_ids}}')
AS data(input_token_id_list)
) i
, Table(Flatten(i.input)) AS F
)
, input_time AS (
SELECT
to_timestamp_ntz(data.time_period_start) AS time_period_start
, CASE
WHEN to_timestamp_ntz(data.time_period_end) > date_trunc('minute', current_timestamp) THEN date_trunc('minute', current_timestamp)
ELSE date_trunc('minute', to_timestamp_ntz(data.time_period_end))
END AS time_period_end
FROM VALUES
('{{time_start}}', '{{time_end}}')
AS data(time_period_start, time_period_end)
)
Run a query to Download Data