Sandeshholograph base transactions
Updated 2024-04-15
999
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 holograph Ethereum transactions @ https://flipsidecrypto.xyz/edit/queries/c15d081e-a875-4775-b978-1b233afaa489
-- WHile the dune dashboard has a cutoff time for v1 contracts as 1st jan 2024, there were
-- users continued to transact with even after that, so you can see a higher number in our method.
with deployed_and_holograph_address as
(
with
v1 as
(
(
select
cast(concat('0x',substr(topics[1],27,64))as varchar(42)) as cont_address
from base.core.fact_event_logs
where block_timestamp >= '2022-11-01 00:00:00'
AND contract_address = lower('0x4f92ae4960a6ac49fa88bcf9d6d4b8c53f626a55')
and topics[0]='0xa802207d4c618b40db3b25b7b90e6f483e16b2c1f8d3610b15b345a718c6b41b'
)
union all
(
SELECT
CAST(cont_address AS VARCHAR(42)) as cont_address
FROM
(
SELECT
'0x6429b42da2a06aa1c46710509fc96e846f46181e' AS cont_address -- Holograph
UNION ALL
SELECT
'0xd85b5e176a30edd1915d6728faebd25669b60d8b' -- HolographBridge
UNION ALL
SELECT
'0x4f92ae4960a6ac49fa88bcf9d6d4b8c53f626a55' -- HolographFactory
UNION ALL
SELECT
'0xf2b701062cef0ebbbff6d388fd793e176e7ab185' -- HolographInterfaces
UNION ALL
QueryRunArchived: QueryRun has been archived