QUEST_ID | BLOCK_TIMESTAMP | TX_ID | ACTION_COUNT | ADDRESS | VALID | QUEST_STEP | TOKEN_AMOUNT | FEE_AMOUNT | CURRENCY | |
|---|---|---|---|---|---|---|---|---|---|---|
1 | :questId | 2025-02-09 00:52:31.000 | 5936a2d9a940c08aefb5999f75fe103112f6ede3540705137065c1cf795bcb0f | 1 | CA6PUJLBYKZKUEKLZJMKBZLEKP2OTHANDEOWSFF44FTSYLKQPIICCJBE | TRUE | 1 | 163.403362 | 0.047915 | XLM |
2 | :questId | 2025-02-09 00:07:53.000 | c98ff9735677030bac4fe70895d8f46a11406b66867bfd92e44b020f3de0c375 | 1 | CBQDHNBFBZYE4MKPWBSJOPIYLW4SFSXAXUTSXJN76GNKYVYPCKWC6QUK | TRUE | 1 | 0.22401 | 0.1093756 | XLM |
3 | :questId | 2025-02-12 08:51:17.000 | 1e9b876fb58fd5582d68bb1ddb2186325e4d6e90542d141c57dcf701ad948674 | 1 | GA6L2HMDXVTV7C2ONSCITALK2XUMFVLM5CVGAYZ6WOTUU47F24FURFPJ | TRUE | 1 | 33.450278 | 0.0933753 | XLM |
4 | :questId | 2025-02-09 22:49:00.000 | ce2830aa9bf3a0df5935e95cac52c5a332809a99aa35612dce8b1b314752f306 | 1 | GA7MUE5RKHLHMQBD3EIQJXFRVX4OTWAMLN5QPCOYXMYEBFVKFSJDP3JH | TRUE | 1 | 104.7317528 | 0.093199 | XLM |
5 | :questId | 2025-02-12 23:24:54.000 | 58c841c9482c1d888249e66cdb239fb23be0630db543e1d35b99e172e1608618 | 1 | GAHEFYR2L7ELTCFMZYEKNNDCF4LDPTBG7WEQAEVAU6V2ESI4WNQ5IKYZ | TRUE | 1 | 3.0070878 | 0.0479571 | XLM |
6 | :questId | 2025-02-12 10:06:02.000 | b7cb2799b4edebe743a2b1f72c58e2f76e3025099ae3ffc5f4a4416ab30468cd | 1 | GAIJ6FS2UJAITVLZ7CNA7QYLWNWOA6ESEDS66LDKSE7ZQ7U7TE5AKJFX | TRUE | 1 | 1.527943 | 0.1102718 | XLM |
7 | :questId | 2025-02-12 23:24:18.000 | 95bc54d47325900b6312129cb5b6612b4424ca74ba239f2399cbb58773fbba89 | 1 | GAJGAQP467AQCN2A2VZ7IFII4IIL3SZSUKUUV5IBD2JGXBFA7X5EDPUS | TRUE | 1 | 15.0356715 | 0.0478665 | XLM |
8 | :questId | 2025-02-09 03:35:36.000 | 04ed8bff319958811343141254ad5a169b2f43bc9e563acfd7fe88eea0de45ac | 1 | GAKDDQ4KCGU76O7VAXB4HRBKPJDYYGIDTUFWCRBGOIBT2FYJVAMRUGS5 | TRUE | 1 | 7.3654577 | 0.0931228 | XLM |
9 | :questId | 2025-02-10 23:20:24.000 | ae3d9fa820ac984a22ce9d5eb7a793866ac3cdf5d8aa444c4c8dd1ac789fa22d | 1 | GANBQQVSCJWSOQEI6XEQZHYHRECTZZIZZLH4Q4K4MGWE3E46YM2G77TJ | TRUE | 1 | 8.5886385 | 0.047955 | XLM |
10 | :questId | 2025-02-13 01:08:20.000 | 7c63410cee1cb9841c665020f53a218174b2de48bedf24e402f9cb629ef2ffdc | 1 | GAPI6HOJDBZ36BOI3NSVIM25ULNQNIHMCETKPTTQ7QHXFTK2WLJMRQCI | TRUE | 1 | 90.4241545 | 0.0479329 | XLM |
11 | :questId | 2025-02-14 11:29:20.000 | 389753be9d1b3e6b28d40fb2faddef324445ce343c29c9cb7a16aa988a4e1bae | 1 | GARA74OFGOVEMSMS7FEMJDRZV6VFC5PZSJTSTFJL62WK44FDAXCPCRUU | TRUE | 1 | 0.5066204 | 0.080561 | XLM |
12 | :questId | 2025-02-09 22:51:00.000 | a7e7ca846e57167805a2716ead7f1fd38c39fdccbb79f70161e7700607e13e48 | 1 | GASJGSKPGJ3GZ2XP44BTDP4DMWDQZML5I7N5JNEZ5YHJIJKZ75I3VTKK | TRUE | 1 | 810.8801328 | 0.0479461 | XLM |
13 | :questId | 2025-02-13 11:48:04.000 | bf6f00af2b5f2927ab10577d9ebc30d1872ed718122139b31126a67dd1200177 | 1 | GAVZXRQ7OAVNBQKYU3MOBN5NKBDKXT5FBOARZKSI4FHPLCGA2BLGF5EZ | TRUE | 1 | 3.0151697 | 0.0931526 | XLM |
14 | :questId | 2025-02-11 20:04:11.000 | d0f2cb385cf4b4c98b9092c8fd65b18c54ac0e782fa10c634bde83f8cfa3ce92 | 1 | GAWXA3LKYRAR2M63MCTFXCTQYY2YH3JRUVLNDEOMPKKGDCDY3RVEIOG3 | TRUE | 1 | 2650.6878077 | 0.0479505 | XLM |
15 | :questId | 2025-02-11 07:56:23.000 | 7355b34d71415cb6f560286ecb843ef28bfa2fde16fb1f67522ebb5db946a05d | 1 | GAXJ6UQWJVZEFFVFVBFC4NM44WR6WWVVWX5ISMKZ6OJSQEFJPPIYQELF | TRUE | 1 | 1194.1336952 | 0.0479493 | XLM |
16 | :questId | 2025-02-14 03:37:14.000 | c84209653ae48ca64faa41694c95ddc88b0b20e7937b763ce768d78a28bcad7c | 1 | GAXW2Z2T7HBFUPHJYVDCJ4N2N5Z7HYZUOFXY6FPXM2A4QL4CVFMAEV32 | TRUE | 1 | 562.1660284 | 0.0479432 | XLM |
17 | :questId | 2025-02-09 16:49:56.000 | 2aad1c46dbf0876d14bdb79fd34869bcb82491c02c42b6e1b98c839b1ce7bc5a | 1 | GB2EVUM2UB7QVJV3Z3SLHSQL322ZPAW22G3XCZXQFEPJQSIP6CNSH2HD | TRUE | 1 | 1006.8624823 | 1.0931662 | XLM |
18 | :questId | 2025-02-11 04:28:42.000 | da6fcfe35673cf5aad9473cfb0151ac91abce129f6b2a185f2b1d74cad5c79a2 | 1 | GB2NXQO3YMB4FJ7XYCXMTWANF5SLT4UXXW7TCDWZVZJZXEYSXQBFEVQS | TRUE | 1 | 96.138132 | 0.0931693 | XLM |
19 | :questId | 2025-02-11 19:07:07.000 | af3203b2f1c90c9b07958d192cb3a97c7eeca341c66ed4fd531514bba01f68d0 | 1 | GB4ZRZCPRQIGQZS7TBY43CWBKLVTCDOWGKAQO72VDYNNRRIJFEQLHSZE | TRUE | 1 | 3112.4005901 | 0.0479251 | XLM |
20 | :questId | 2025-02-09 22:42:56.000 | d194cf80e94926676b847cd08337f27506504f88f5a866e4e7726cd184a41624 | 1 | GB63OLIX7KYKJWGB7BOSG5HRYUA3JZPYGNF4DT6QVYS7ZEFTIZZ2DC42 | TRUE | 1 | 3594.2768672 | 0.0479208 | XLM |
Flipside Data ScienceFebruary Onboarding #2 - Swap USDC for XLM
Updated 2025-02-14
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
›
⌄
with stellar_prices as (
Select
TO_TIMESTAMP(value [0] :: string) as hour,
'XLM' as token,
avg(value [1]) as avg_price
from
(
SELECT
livequery.live.udf_api(
'https://api.coingecko.com/api/v3/coins/stellar/market_chart?vs_currency=usd&days=365'
) as resp
),
LATERAL FLATTEN (input => resp:data:prices)
group by
all
),
base as (
SELECT
op.*,
f.value as balance_change
FROM stellar.core.ez_operations op,
LATERAL FLATTEN(input => PARSE_JSON(asset_balance_changes)) f
where contract_id = 'CBQDHNBFBZYE4MKPWBSJOPIYLW4SFSXAXUTSXJN76GNKYVYPCKWC6QUK'
and (f.value:from::string in (:userAddresses) or f.value:to::string in (:userAddresses))
and block_timestamp :: date >= :startsAt
-- and (f.value:from::string = 'GAJGAQP467AQCN2A2VZ7IFII4IIL3SZSUKUUV5IBD2JGXBFA7X5EDPUS' or f.value:to::string = 'GAJGAQP467AQCN2A2VZ7IFII4IIL3SZSUKUUV5IBD2JGXBFA7X5EDPUS')
-- and block_timestamp > current_date - 6
)
,
usdc_tx as (
select
balance_change:from::string as address,
transaction_hash as tx_id
from
base
where balance_change:asset_code::string = 'USDC'
Last run: about 1 month ago
54
11KB
3s