DATE | FLOW | VOLUME | EVENTS | VALUE_USD | |
|---|---|---|---|---|---|
1 | 2025-03-26 00:00:00.000 | Deposit | 108.23223653 | 39 | 9482659.17133942 |
2 | 2025-03-26 00:00:00.000 | Withdraw | 102.13035709 | 24 | 8948049.10608326 |
3 | 2025-03-25 00:00:00.000 | Withdraw | 94.01717764 | 54 | 8199520.11351732 |
4 | 2025-03-25 00:00:00.000 | Deposit | 78.83855116 | 56 | 6875746.56231708 |
5 | 2025-03-24 00:00:00.000 | Deposit | 130.30173023 | 65 | 11364330.5528746 |
6 | 2025-03-24 00:00:00.000 | Withdraw | 107.57252878 | 42 | 9381991.88381209 |
7 | 2025-03-23 00:00:00.000 | Deposit | 167.77574189 | 52 | 14130156.8698467 |
8 | 2025-03-23 00:00:00.000 | Withdraw | 194.80867254 | 53 | 16406883.8056551 |
9 | 2025-03-22 00:00:00.000 | Deposit | 106.41905766 | 46 | 8946384.12983205 |
10 | 2025-03-22 00:00:00.000 | Withdraw | 114.8985203 | 36 | 9659231.35532025 |
11 | 2025-03-21 00:00:00.000 | Withdraw | 208.28861453 | 44 | 17495514.6103691 |
12 | 2025-03-21 00:00:00.000 | Deposit | 215.06896987 | 63 | 18065040.7276855 |
13 | 2025-03-20 00:00:00.000 | Deposit | 150.23477459 | 63 | 12834406.5584491 |
14 | 2025-03-20 00:00:00.000 | Withdraw | 146.81841823 | 57 | 12542550.6509707 |
15 | 2025-03-19 00:00:00.000 | Deposit | 290.10530727 | 81 | 24172444.5176582 |
16 | 2025-03-19 00:00:00.000 | Withdraw | 328.95447773 | 70 | 27409473.9478968 |
17 | 2025-03-18 00:00:00.000 | Deposit | 208.58022657 | 44 | 17215481.8702948 |
18 | 2025-03-18 00:00:00.000 | Withdraw | 163.36933122 | 43 | 13483932.8062395 |
19 | 2025-03-17 00:00:00.000 | Deposit | 80.35383845 | 41 | 6694519.34278485 |
20 | 2025-03-17 00:00:00.000 | Withdraw | 123.0352795 | 60 | 10250438.2409835 |
Pine Analyticsexotic-harlequin copy
Updated 2025-03-26
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 tab1 as (
SELECT
block_timestamp,
'Deposit' as flow,
f.value['value'] as amount
FROM bitcoin.core.fact_transactions,
LATERAL FLATTEN(input => outputs) f
WHERE block_timestamp > '2025-01-01';
and f.value['scriptPubKey']['address'] = 'bc1pdwu79dady576y3fupmm82m3g7p2p9f6hgyeqy0tdg7ztxg7xrayqlkl8j9'
), tab2 as (
select
block_timestamp,
'Withdraw' as flow,
value as amount
from bitcoin.core.fact_inputs
where PUBKEY_SCRIPT_ADDRESS like 'bc1pdwu79dady576y3fupmm82m3g7p2p9f6hgyeqy0tdg7ztxg7xrayqlkl8j9'
), tab3 as (
select
date(block_timestamp) as date,
flow,
sum(amount) as volume,
count(*) as events
from (
select * from tab1
union all
select * from tab2
)
group by 1,2
order by 1 desc
)
select
Last run: 11 days ago
99
7KB
17s