SocioAnalyticaFjord Foundary copy
Updated 2024-04-11
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 ali_lifi / Fjord Foundary @ https://flipsidecrypto.xyz/ali_lifi/q/Jz9uKPMERdVp/fjord-foundary
WITH fjord_foundary_arb AS (
SELECT
*, rank()over(partition by tx_hash order by event_index) as rank
FROM
arbitrum.core.ez_decoded_event_logs
WHERE
topics [0] IN (
'0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef',
'0x846c37eef631e0943682d87352ec117c20008eb7f425c9b85ac011a6d4774cc0'
)
AND block_timestamp >= '2023-01-15'
),
fjord_foundary_pol AS (
SELECT
*, rank()over(partition by tx_hash order by event_index) as rank
FROM
polygon.core.ez_decoded_event_logs
WHERE
topics [0] IN (
'0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef',
'0x846c37eef631e0943682d87352ec117c20008eb7f425c9b85ac011a6d4774cc0'
)
AND block_timestamp >= '2023-01-15'
),
fjord_foundary_base AS (
SELECT
*, rank()over(partition by tx_hash order by event_index) as rank
FROM
base.core.ez_decoded_event_logs
WHERE
topics [0] IN (
'0xbeae048c6d270d9469f86cf6e8fedda3c60ad770f16c24c9fc131c8e9a09101d',
'0x846c37eef631e0943682d87352ec117c20008eb7f425c9b85ac011a6d4774cc0'
)
QueryRunArchived: QueryRun has been archived