DATE | TRANSACTIONS | TOTAL_TRANSACTIONS | |
---|---|---|---|
1 | 2023-01-01 00:00:00.000 | 0 | 0 |
2 | 2023-01-02 00:00:00.000 | 0 | 0 |
3 | 2023-01-03 00:00:00.000 | 0 | 0 |
4 | 2023-01-04 00:00:00.000 | 0 | 0 |
5 | 2023-01-05 00:00:00.000 | 0 | 0 |
6 | 2023-01-06 00:00:00.000 | 9 | 9 |
7 | 2023-01-07 00:00:00.000 | 9 | 18 |
8 | 2023-01-08 00:00:00.000 | 0 | 18 |
9 | 2023-01-09 00:00:00.000 | 6 | 24 |
10 | 2023-01-10 00:00:00.000 | 35 | 59 |
11 | 2023-01-11 00:00:00.000 | 107 | 166 |
12 | 2023-01-12 00:00:00.000 | 280 | 446 |
13 | 2023-01-13 00:00:00.000 | 346 | 792 |
14 | 2023-01-14 00:00:00.000 | 254 | 1046 |
15 | 2023-01-15 00:00:00.000 | 431 | 1477 |
16 | 2023-01-16 00:00:00.000 | 425 | 1902 |
17 | 2023-01-17 00:00:00.000 | 647 | 2549 |
18 | 2023-01-18 00:00:00.000 | 562 | 3111 |
19 | 2023-01-19 00:00:00.000 | 641 | 3752 |
20 | 2023-01-20 00:00:00.000 | 476 | 4228 |
Flipside Teamholograph avalanche transactions
Updated 1 hour ago
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 avalanche.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
SELECT
Last run: about 1 hour agoAuto-refreshes every 1 hour
...
741
28KB
47s