TX_HASH | BLOCK_TIMESTAMP | AMOUNT | |
|---|---|---|---|
1 | 3aB3jWHhgvByDqDq1DjbaBwGQeiLDRbHqmSC7WAJu8t4 | 2024-05-19 17:13:41.637 | 0.3 |
2 | 3s1sPNTRX5HmmbCrj4LHuNSt9AqHHf5P44cVZ7u12A5x | 2024-05-19 17:31:13.275 | 0.5 |
3 | C9i3TmBj9MbhPZqFGKMLpcTMXASWQ8fMYAcNWf3ZtDEj | 2024-05-19 17:14:22.943 | 0.3 |
4 | 83XvUYM6f7bYv7f8gER4UUVqcF8cdacoxFo8pqpoR6dV | 2024-05-19 17:13:57.745 | 0.3 |
5 | AaVPaLQKeUHZ1Tev1T6cTaVdMMRaAcaoUvZLRACZ3eHA | 2024-06-08 03:39:49.100 | 0.1 |
6 | EiJx4bpshf8n8qoUyguXY69RGdPeSoRmZu3KqwQJdjiG | 2024-05-19 17:14:37.558 | 0.3 |
datavortex1:1
Updated 2025-02-15
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 ReceiptStatus AS (
SELECT
tx_hash,
CASE
WHEN COUNT(CASE WHEN receipt_succeeded = FALSE THEN 1 END) > 0 THEN FALSE
ELSE TRUE
END AS receipt_succeeded
FROM near.core.fact_receipts
GROUP BY tx_hash
HAVING COUNT(CASE WHEN receipt_succeeded = FALSE THEN 1 END) = 0
)
SELECT
t.block_timestamp,
t.tx_hash,
t.amount,
FROM near.core.ez_token_transfers t
JOIN ReceiptStatus r
ON t.tx_hash = r.tx_hash
WHERE
t.from_address = 'kingofjank.near'
AND t.to_address = 'marketing.v1.potfactory.potlock.near';
*/
WITH filtered_receipts AS (
SELECT
tx_hash,
block_timestamp
FROM
near.core.fact_receipts
GROUP BY
tx_hash,
block_timestamp
HAVING
COUNT(CASE WHEN receipt_succeeded = FALSE THEN 1 END) = 0
)
Last run: 3 months ago
6
475B
1s