flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
Become a Partner
flipside
2024-07-06 04:54 AM
cryptall
2024-07-06 04:54 AM
Updated 2024-07-20
Copy Reference
Fork
9
1
2
3
4
5
6
7
8
9
›
⌄
SELECT
DATE_TRUNC
(
'week'
,
block_timestamp
::
date
)
AS
week
,
count
(
DISTINCT
sender
)
AS
users
,
sum
(
amount
)
AS
volume
FROM
axelar
.
defi
.
ez_bridge_squid
WHERE
destination_chain
=
'injectiv'
GROUP
BY
week
ORDER
BY
week
;
Results
QueryRunArchived: QueryRun has been archived