Kruys-CollinsSquid Transaction Count
Updated 2024-04-17
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
›
⌄
⌄
SELECT
DATE_TRUNC('week', BLOCK_TIMESTAMP) AS Week,
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS transaction_date,
COUNT(*) AS transaction_count
FROM
axelar.defi.ez_bridge_squid
where block_timestamp >= '2024-01-01'
GROUP BY
1,2
ORDER BY
transaction_date DESC;
union
SELECT
DATE_TRUNC('week', BLOCK_TIMESTAMP) AS Week,
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS transaction_date,
COUNT(*) AS transaction_count
FROM
axelar.defi.ez_bridge_satellite
where block_timestamp >= '2024-01-01'
GROUP BY
1,2
ORDER BY
transaction_date DESC;
QueryRunArchived: QueryRun has been archived