flipsidecrypto⚡️ LQ / CoinGecko LiveQuery Function Guide
99
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
›
⌄
-- CoinGecko 🤝 Flipside LiveQuery Function Guide
-------------------------------------------------------------------------
-- The CoinGecko LiveQuery integration enables you to interact with
-- any CoinGecko API endpoint directly in SQL.
-- -----------------------------------------------------------------
-- 🚨 WARNING 🚨
-- To run these examples you must associate your CoinGecko API Key
-- with your Flipside Account here:
-- https://flipsidecrypto.xyz/livequery/coingecko
-- ======================================================================
--
-- ⚡️ CoinGecko Functions
-- schema: `coingecko`
-- function docs: https://www.coingecko.com/en/api/documentation
--
-- ======================================================================
--
-- #️⃣ coingecko.get('url', 'query args')
-- Issue a GET request to a CoinGecko Endpoint
--
-- examples:
--
SELECT
coingecko.get('/api/v3/coins/list', {}) as resp
--
SELECT coingecko.get('/api/v3/simple/price', {
'ids': '0x',
'vs_currencies': 'btc,usd,eth'
}) as resp
Run a query to Download Data