CARD_NAME::STRING | TOTAL_AMOUNT_USD | TX_COUNT | |
|---|---|---|---|
1 | Happy Mother's Day | 173749.246859714 | 5968 |
2 | Happy Father's Day | 97100.199636468 | 4266 |
3 | Well Done | 54334.912187774 | 1796 |
4 | BONK Boxing | 38052.669172898 | 1558 |
5 | Party Time | 37971.41720838 | 1256 |
6 | Arrg-mazing Matey | 35514.743341047 | 1054 |
7 | Happy Birthday | 30994.296616049 | 1047 |
8 | You Did It | 28673.508847245 | 970 |
9 | Congratulations | 24493.302987154 | 948 |
10 | BONK AWA | 18682.710588684 | 910 |
11 | Happy Easter | 20315.650554866 | 777 |
12 | Congrats Matey | 13293.683520306 | 750 |
13 | BONK x TBW | 1914.1863046 | 690 |
14 | Happy Valentines | 13190.509273454 | 469 |
15 | Warmest Wishes | 8514.010526906 | 366 |
16 | Happy Lunar New Year | 3719.82309264 | 100 |
17 | Happy Thanksgiving | 3121.68370943 | 90 |
18 | Zombonk | 2174.01978302 | 63 |
19 | Happy Holidays | 2046.914200955 | 62 |
20 | Gobble Gobble | 4719.158637482 | 53 |
h4wkCard type
Updated 7 days ago
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
›
⌄
-- forked from BONK amount send type @ https://flipsidecrypto.xyz/studio/queries/5e54372b-68d3-47b2-97b7-a19823bfe1ca
-- forked from how long before claiming type @ https://flipsidecrypto.xyz/studio/queries/302be25a-4828-4954-b0ff-a67d63dacbe7
-- forked from how long before claiming @ https://flipsidecrypto.xyz/studio/queries/42f097f7-71b6-43cb-8886-ed96edec1573
-- forked from new wallet creation rate @ https://flipsidecrypto.xyz/studio/queries/bf68f220-97c2-4a58-93c8-1f182435e5af
with bonk_price as (
select hour,
avg(price) as bonk_price
from solana.price.ez_prices_hourly
where token_address = 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'
group by hour
)
, base as (
select *
from $query('69837e2b-feff-468e-84e1-d25106cf0031')
join bonk_price on (date_trunc('hour', block_timestamp) = hour)
)
select card_name::string,
sum(bonk_amount * bonk_price) as total_amount_usd,
count(distinct tx_id) as tx_count
from base
group by 1
order by tx_count desc
Last run: 7 days ago
30
1KB
2s