TIME | BURNTODRAW | LASTBTD | |
|---|---|---|---|
1 | 2025-01-24 00:00:00.000 | 4931 | 2025-01-24 23:59:37.000 |
2 | 2025-01-17 00:00:00.000 | 4908 | 2025-01-17 23:59:37.000 |
3 | 2024-12-13 00:00:00.000 | 3168 | 2024-12-13 23:59:37.000 |
4 | 2024-10-03 00:00:00.000 | 2581 | 2024-10-03 23:59:07.000 |
5 | 2024-09-19 00:00:00.000 | 2547 | 2024-09-19 23:57:11.000 |
6 | 2024-08-15 00:00:00.000 | 2529 | 2024-08-15 23:59:57.000 |
7 | 2024-08-29 00:00:00.000 | 2464 | 2024-08-29 23:59:49.000 |
8 | 2025-01-10 00:00:00.000 | 2262 | 2025-01-10 23:59:31.000 |
9 | 2025-01-18 00:00:00.000 | 2190 | 2025-01-18 23:39:03.000 |
10 | 2024-08-22 00:00:00.000 | 2096 | 2024-08-22 23:59:17.000 |
11 | 2024-10-04 00:00:00.000 | 2088 | 2024-10-04 23:59:41.000 |
12 | 2025-01-22 00:00:00.000 | 1889 | 2025-01-22 23:25:35.000 |
13 | 2024-09-05 00:00:00.000 | 1846 | 2024-09-05 23:57:01.000 |
14 | 2025-01-23 00:00:00.000 | 1836 | 2025-01-23 23:59:37.000 |
15 | 2024-08-30 00:00:00.000 | 1786 | 2024-08-30 23:59:17.000 |
16 | 2025-01-03 00:00:00.000 | 1767 | 2025-01-03 23:56:03.000 |
17 | 2024-12-14 00:00:00.000 | 1763 | 2024-12-14 23:56:33.000 |
18 | 2024-10-24 00:00:00.000 | 1688 | 2024-10-24 23:57:55.000 |
19 | 2024-09-26 00:00:00.000 | 1675 | 2024-09-26 23:54:49.000 |
20 | 2024-08-16 00:00:00.000 | 1660 | 2024-08-16 23:59:13.000 |
killadelphiaburn to draw transactions copy copy
Updated 2024-09-19
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
›
⌄
-- forked from 0x23896B6a6ca0CF6B9d20248c16258935F64f2cC3 / burn to draw transactions copy @ https://flipsidecrypto.xyz/0x23896B6a6ca0CF6B9d20248c16258935F64f2cC3/q/GHd73jmtcMAa/burn-to-draw-transactions-copy
-- forked from themolt / burn to draw transactions @ https://flipsidecrypto.xyz/themolt/q/62JDcBE_5Z4i/burn-to-draw-transactions
select
--from_address,
date_trunc('day', block_timestamp) AS time,
COUNT(*) BurnToDraw,
max(block_timestamp) lastbtd
from
blast.core.fact_transactions
where
to_address = '0x86b58ca576c24f79ad1e5459aee01d40bea22828' --and tx_hash = '0x81c5cf0b7e797920b4ce2f90dc0b8cc3e8a6b84a7add660b6e7b69d5ce4afa11'
and ORIGIN_FUNCTION_SIGNATURE = '0x8094cee4' --burntodraw
--and time >= date_trunc('day', current_timestamp - interval '3 months')
-- and from_address = '0x31f849d0f4c2f5c7f2e7db0aad859203e4e93bc6'
--and block_timestamp > '2024-06-03 00:00:00.000' --exclude early test
and block_timestamp > '2024-07-01 00:00:00.000' --post tge
group by
1
order by
2 desc
Last run: about 2 months ago
...
209
12KB
5s