DAY | TIME_PERIOD | BUSINESS_VISA | |
|---|---|---|---|
1 | 2024-02-24 00:00:00.000 | Future | 0 |
2 | 2024-02-23 00:00:00.000 | Future | 2 |
3 | 2024-02-22 00:00:00.000 | Future | 5 |
4 | 2024-02-17 00:00:00.000 | Future | 6 |
5 | 2024-02-15 00:00:00.000 | Future | 7 |
6 | 2024-02-14 00:00:00.000 | Future | 8 |
7 | 2024-02-13 00:00:00.000 | Future | 11 |
8 | 2024-02-10 00:00:00.000 | Future | 12 |
9 | 2024-02-08 00:00:00.000 | Future | 13 |
10 | 2024-02-07 00:00:00.000 | Future | 14 |
11 | 2024-02-06 00:00:00.000 | Future | 15 |
12 | 2024-02-05 00:00:00.000 | Future | 17 |
13 | 2024-01-30 00:00:00.000 | Future | 26 |
14 | 2024-01-29 00:00:00.000 | Future | 27 |
15 | 2024-01-28 00:00:00.000 | Future | 28 |
16 | 2024-01-27 00:00:00.000 | Future | 29 |
17 | 2024-01-26 00:00:00.000 | Past | 30 |
18 | 2024-01-25 00:00:00.000 | Past | 31 |
19 | 2024-01-24 00:00:00.000 | Past | 32 |
20 | 2024-01-23 00:00:00.000 | Past | 33 |
jackguyb pass 2
Updated 2024-01-26
999
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 tab1 as (
SELECT
tx_id,
block_timestamp,
INNER_INSTRUCTIONS[1]['instructions'][7]['parsed']['info']['owner'] as user1,
INNER_INSTRUCTIONS[1]['instructions'][8]['parsed']['info']['owner'] as user2,
case when user1 is null then user2 else user1 end as user
FROM solana.core.fact_transactions
WHERE block_timestamp > '2023-08-01'
AND (
INNER_INSTRUCTIONS[1]['instructions'][7]['parsed']['info']['delegate'] LIKE 'FWga3fVXnkFbvBCfSAkudeqGyUEPTqZbDWFwB3EJvo72'
OR INNER_INSTRUCTIONS[1]['instructions'][8]['parsed']['info']['delegate'] LIKE 'FWga3fVXnkFbvBCfSAkudeqGyUEPTqZbDWFwB3EJvo72'
)
--and tx_id LIKE '58ghZCXXUXmHvsLTAXGFCBRdpAToc1m5CyfBHNMa8bwpbu9GNLAP13n6AGAvHEGhfUJAsPBFMNpFztht4rZpbCit'
), tab2 as (
SELECT --*
tx_from,
count(*) as amt,
max(block_timestamp) as max_bt,
min(block_timestamp) as min_bt
FROM solana.core.fact_transfers
WHERE tx_to in (
'7VFhBgyAxdhRxRTqASRHR1YKkErmCLkP6dvQvuVLg5D3'
)
AND mint LIKE 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
AND block_timestamp > '2021-01-01'
and amount = 5
--and tx_id like '2KSdcXsAYZ1XzbKPyz5HTAJqUQZeFRLjL2ebvXUkoe5VhVUyQj5Wt6T8BeTTvns1dWEwyWpdq3k7fdL4ktd6zJp4'
--AND amount = 4.95
GROUP BY 1
), ExistingQuery AS (
SELECT
block_timestamp as mint_time,
USER,
CASE when amt is null then 0 else amt end as renew_amt,
Last run: over 1 year ago
...
115
4KB
773s