Skip to content

Instantly share code, notes, and snippets.

View LFSCamargo's full-sized avatar
🕶️
Sunny Days Are Coming

Luiz Fernando Sousa Camargo LFSCamargo

🕶️
Sunny Days Are Coming
View GitHub Profile
@LFSCamargo
LFSCamargo / offer.js
Last active August 2, 2019 20:42
creating the offer
// Peer 1
pc.createOffer(
offer => {
pc.setLocalDescription(
offer,
() => {
// send the offer sdp to the other peer
},
e => console.log(e),
)
@LFSCamargo
LFSCamargo / Candlestick.sql
Created August 11, 2023 21:44
Candlestick
WITH initial_price as (
SELECT transaction_hash,
index,
blocks.number as block_number,
blocks.timestamp as block_timestamp,
sqrt_ratio as sqrt_ratio_after
FROM initializations
JOIN blocks ON initializations.block_number = blocks.number
WHERE pool_key_hash = 3444297103257838275074422089987936420839083129914207634282919550416207684544
),