SpecterBridge by event copy
Updated 2024-07-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
-- forked from Bridge by event @ https://flipsidecrypto.xyz/edit/queries/a6e120a5-1fb0-47a6-a54e-6d79b05332c4
WITH DepWith AS (
SELECT*
FROM blast.core.ez_decoded_event_logs
WHERE
EVENT_NAME in ('BridgedDeposit','BridgedWithdrawal')
AND tx_status = 'SUCCESS' and Contract_address = '0x5e023c31e1d3dcd08a1b3e8c96f6ef8aa8fcacd1'
AND block_timestamp::date >= '2024-06-26' AND block_timestamp::date <= '2024-07-02'
)
SELECT 'Bridge In' AS BridgeType, COUNT(*) AS BridgeCount
FROM DepWith
WHERE event_name = 'BridgedDeposit'
UNION ALL
SELECT 'Bridge Out' AS BridgeType, COUNT(*) AS BridgeCount
FROM DepWith
WHERE event_name = 'BridgedWithdrawal'
QueryRunArchived: QueryRun has been archived