SNX & SDS Price

synthquestSNX & SDS Price

Updated 2025-02-15

-- with SDS_price_feed as (

-- select

-- block_number,

-- block_timestamp,

-- tx_hash,

-- origin_from_address,

-- origin_to_address,

-- contract_address,

-- event_name,

-- decoded_log:current as raw_value,

-- decoded_log:roundId as round_id,

-- decoded_log:updatedAt::timestamp as updated_at,

-- coalesce(lead(decoded_log:updatedAt::timestamp) over (order by block_number),

-- current_timestamp())

-- as updated_at_end,

-- raw_value / pow(10,27) as price, 'SDS' as token,

-- date_trunc('hour', block_timestamp) as hour_timestamp

-- from ethereum.core.ez_decoded_event_logs

-- where contract_address = '0xc7bb32a4951600fbac701589c73e219b26ca2dfc'

-- and topics[0] = '0x0559884fd3a460db3073b7fc896cc77986f16e378210ded43186175bf646fc5f'

-- order by block_timestamp desc

-- ),

with SDS_price_feed as (

SELECT block_number, block_timestamp, tx_hash, decoded_log:current *1e-27 AS price

, 'SDS' as token

, date_trunc('hour', block_timestamp) as hour_timestamp

FROM ethereum.core.ez_decoded_event_logs

WHERE contract_address = '0xc7bb32a4951600fbac701589c73e219b26ca2dfc'

AND event_name = 'AnswerUpdated'

ORDER BY block_timestamp DESC

-- SNX Price

-- forked from fc654414-c36e-4b14-992d-b7c42189d4d8

Last run: about 2 months agoAuto-refreshes every 12 hours

...

720

27KB

547s

flipside