vilppu2024-03-31 09:57 PM
Updated 2024-03-31
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
--select distinct event_name from blast.core.ez_decoded_event_logs where contract_address = '0x0000000000acc01064aa5280da3f1c41a35827bc' limit 10
select *,
from blast.core.ez_decoded_event_logs where contract_address = lower('0x0000000000acc01064aa5280da3f1c41a35827bc')
and origin_from_address = lower('0x7Ed9dC4698e7517031290712A0C542996DDD6e40')
and event_name = 'DepositsRolledOver'
--Mar-24-2024
select
origin_from_address as user_address,
cast(decoded_log['rollovers'][0]['caveId'] as float) as cave_id,
array_size(decoded_log['rollovers'][0]['rolledOverRoundIds']) as number_of_rounds,
from blast.core.ez_decoded_event_logs where contract_address = lower('0x0000000000acc01064aa5280da3f1c41a35827bc')
and origin_from_address = lower('0x7Ed9dC4698e7517031290712A0C542996DDD6e40')
and event_name = 'DepositsRolledOver'
-- select distinct
-- cast(decoded_log ['caveId'] as float) as cave_id,
-- cast(decoded_log ['enterAmount'] as float) / 10^18 as entry_fee,
-- from blast.core.ez_decoded_event_logs
-- where contract_address = lower('0x0000000000acc01064aa5280da3f1c41a35827bc')
-- and event_name = 'CaveAdded'
-- and cast(decoded_log ['enterCurrency'] as float) = '0x0000000000000000000000000000000000000000'
QueryRunArchived: QueryRun has been archived