samUntitled Query
Updated 2022-05-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
select*,
RIGHT(attribute_value, LENGTH(attribute_value) - LENGTH(SPLIT_PART(TRIM(REGEXP_REPLACE(attribute_value, '[^[:digit:]]', ' ')), ' ', 0)))
AS currency,
SPLIT_PART(TRIM(REGEXP_REPLACE(
attribute_value,
'[^[:digit:]]',
' ')), ' ', 0) AS amount
from osmosis.core.fact_msg_attributes
where tx_id = '06728732C635BEF4EB69EEC32A9416580B7518F113952C84A23683FDD28B1F5B'
and block_timestamp::date = '2022-04-20'
-- attribute_value = 'lock_and_superfluid_delegate'
select* from osmosis.core.fact_transactions
where tx_id = '06728732C635BEF4EB69EEC32A9416580B7518F113952C84A23683FDD28B1F5B'
and block_timestamp::date = '2022-04-20'
Run a query to Download Data