TIME | TOTAL_AMOUNT | DONATOORS_COUNT | |
|---|---|---|---|
1 | 2023-06-23 20:00:00.000 | 35.674 | 14 |
2 | 2023-06-03 13:00:00.000 | 1395.205 | 542 |
3 | 2023-06-03 14:00:00.000 | 1402.62 | 498 |
4 | 2023-06-02 18:00:00.000 | 721.496 | 272 |
5 | 2023-06-02 10:00:00.000 | 296.93 | 72 |
6 | 2023-06-01 20:00:00.000 | 177.979 | 15 |
7 | 2023-06-05 08:00:00.000 | 609.345 | 291 |
8 | 2023-07-07 05:00:00.000 | 6.99 | 5 |
9 | 2023-06-08 23:00:00.000 | 83.70799 | 73 |
10 | 2023-06-11 00:00:00.000 | 16.96 | 14 |
11 | 2023-06-18 01:00:00.000 | 7.262481 | 7 |
12 | 2023-06-06 14:00:00.000 | 338.746 | 129 |
13 | 2023-06-07 15:00:00.000 | 446.79877 | 133 |
14 | 2023-06-04 20:00:00.000 | 521.753 | 228 |
15 | 2023-06-04 15:00:00.000 | 714.906 | 377 |
16 | 2023-06-26 11:00:00.000 | 48.379547 | 26 |
17 | 2023-06-27 01:00:00.000 | 42 | 5 |
18 | 2023-06-13 05:00:00.000 | 67.39 | 36 |
19 | 2023-06-04 04:00:00.000 | 566.001 | 250 |
20 | 2023-06-10 13:00:00.000 | 119.977 | 55 |
freemartianHourly Donation
Updated 2024-01-29
9
1
2
3
4
5
6
7
8
9
›
⌄
select
date_trunc('hour', block_timestamp) as time,
sum(raw_amount)/pow(10,6) as total_amount,
count(distinct from_address) as donatoors_Count
from optimism.core.fact_token_transfers
where contract_address = '0x7f5c764cbc14f9669b88837ca1490cca17c31607'
and origin_function_signature = '0x160e3f3d'
and to_address = '0x19793c7824be70ec58bb673ca42d2779d12581be'
group by time
Last run: over 1 year agoAuto-refreshes every 3 hours
...
766
28KB
30s