QUEST_ID | BLOCK_TIMESTAMP | TX_ID | ACTION_COUNT | ADDRESS | VALID | QUEST_STEP | TOKEN_AMOUNT | FEE_AMOUNT | CURRENCY | |
|---|---|---|---|---|---|---|---|---|---|---|
1 | :questId | 2025-01-31 19:32:04.000 | cfb84fb409d1549b8c43bf0664c3816bf4bd1270e5e6bcfe542ee4ccd7a6dc24 | 1 | GAA66A522CHULZSFGT3OHQ2GBMU5DXG3PWRMUO43Z7Y3B5FCG5EGVNN4 | TRUE | 1 | 16.394722378 | 0.0303939 | XLM |
2 | :questId | 2025-03-01 20:14:15.000 | b0bd875106dc869690bfb1591254e51d73ecbf4e6b6586ed301e630956ef7adf | 1 | GAAAXTSRR27NDODG6IMGEFWW3CGISUHPFH5QN4A2WBO2H2SWWJI5KNNR | TRUE | 1 | 87.281304442 | 0.0303619 | XLM |
3 | :questId | 2025-02-18 21:55:21.000 | 0d26a551932f6c4ccb7c45f195b423eb01b3e062d0bd9ec0c20f17a432064baa | 1 | GAACP3QSTOGXEWKQMH7CHBG3DNIB2LFZJE26USE4SI3X6NJG6JMERJAV | TRUE | 1 | 299.788197968 | 0.0303601 | XLM |
4 | :questId | 2025-02-13 18:26:36.000 | 34ac4b45114116277347c8c50e6a80383e3024e3b931f23e50385b9154b676de | 1 | GAAG2UW6G5SEGYKF22S36GCHZBMSGPGHRQEVBLOV2SZSE6KE55UP7VE3 | TRUE | 1 | 60.087221175 | 0.1973211 | XLM |
5 | :questId | 2025-01-30 23:13:16.000 | 585a686ef523c1ca2f4412b23523f47ac18a2afbbc37a518c15a52fe46019de7 | 1 | GAAL4YBHWQFO32VO2QPAHFUK3BOASM7DRP354GTEGR72UOF2LOFV3JG6 | TRUE | 1 | 50.888096588 | 0.0303824 | XLM |
6 | :questId | 2025-02-04 17:01:34.000 | 58d74f3778ea36ef4b992e6856d55c988292907a0d0d332b51a42db86e2cbdb7 | 1 | GAAM34M37T7XQ54Y7MXYXII7SVPWLIYQVD2QUN2SW5DLURFF33LZT47E | TRUE | 1 | 1580.086977417 | 0.0303461 | XLM |
7 | :questId | 2025-02-01 22:25:09.000 | 26c55f40edf4a8e87d44be2301961fa3594d630f7c78c0301e1e409b65f7f9c4 | 1 | GAAXSQWCD3XRLF2EN2TPK3F4NN4KKLMXK3FW6VA7VFELUBB7CYTD4AE2 | TRUE | 1 | 2.413474793 | 0.0303936 | XLM |
8 | :questId | 2025-02-03 04:29:32.000 | c1ece4e3024d06d6c19b82f10aec8e875b04606f2bceca5c83bfc96d3d514cd1 | 1 | GAAZRVYH4OVO6YVONYXDAKSM7WJPJXSZCWTZ65PWHZWZ4DIKMRE4DLGC | TRUE | 1 | 850.875242179 | 0.1748155 | XLM |
9 | :questId | 2025-02-21 21:19:22.000 | f4cd6a9f700ed048ff3dcca85578997e53ae28c08f671b88e8b1112ed1d5641c | 1 | GAAZYLOFYVCGL566E336KAABHC4GP46NI656TTQXUO26LRGMU4Y7K6HL | TRUE | 1 | 38.740547612 | 0.464829 | XLM |
10 | :questId | 2025-02-04 23:53:26.000 | c65e28a78258b9f7154a1befdbe87edc813b12eaa439e2e2d0801f9720b87aad | 1 | GAB7RTWG7FZLWA2V52MLEHMAKZRPUEDDO3XT6U4UCECQZQQNNHJA3FK2 | TRUE | 1 | 9.141267259 | 0.0303468 | XLM |
11 | :questId | 2025-02-07 11:22:30.000 | d5a3de66c2d7f679452108dd0ee9d93f69c25f0db4711f575790eed252b2f34a | 1 | GABB44JCDU3OS66THYB7WEKNX74XJQ56S7F67PZMHH4RAFAJYDDDI6LR | TRUE | 1 | 15.727929276 | 0.0303513 | XLM |
12 | :questId | 2025-02-09 19:58:55.000 | a8357a68da82e108cd0a572ec87d2e5d0638f8f8e85e78034f30829f95cda094 | 1 | GABJBMUVFJ2QJGNF2LUGCQGFA2ZDPHYDSOM5QEE3DPMBOBUUK3VZQSVX | TRUE | 1 | 3015.315566953 | 0.1436174 | XLM |
13 | :questId | 2025-01-30 16:28:18.000 | 88ca25e4acc64a666c3b1b1f9cf8cdca1c6a35f12df19bb63f0260ae7523cf87 | 1 | GABOUHLV7GQ27MGVXLAN7EJSIUENCHYT5SLHGHFFW6LGAYU7TALDFTLS | TRUE | 1 | 127.220241471 | 0.0303819 | XLM |
14 | :questId | 2025-02-14 15:19:08.000 | 558593926a7a476e3c2646cd10cd072cfdd2439177fb12b5fa87d0b66f98c1b6 | 1 | GABQIN4A226WELGDNDGL5EHEUKXQQVRSF3TFOJ5WJTRF7Y6CDVUIG6YF | TRUE | 1 | 26.719329352 | 0.030363 | XLM |
15 | :questId | 2025-02-14 16:19:05.000 | 5e7146f3824b3b286acf5e13a06f8ed618af22532f7ae63fd9b9ce8998d03f02 | 1 | GAC44CHEOYAJ5W73VC63FLMY6ZIZPOGB2HRHZC42FTHHO42VXNJ23C3K | TRUE | 1 | 2285.987066786 | 0.1271849 | XLM |
16 | :questId | 2025-02-03 18:01:06.000 | 2f3827bfb15e96b3812de1e0651b2daad6f7abf8fe09245b74c55a9ba0f38440 | 1 | GAC6E3PNMVLCDTS5NZQO5VA62OJSGORYTJYLVAUCWYXDPKJHWC2DZEUU | TRUE | 1 | 28.759583186 | 0.2713864 | XLM |
17 | :questId | 2025-02-04 04:54:43.000 | 024e5d3b22174450fd9e149832bd0e6d55bc17fcd493aac03b0aa1bff4425bbd | 1 | GACCBSKZSBXIJTQQ3XI6AJVWBMRJFHS2VRSN3YLUVGCR5UTTS74DMXUX | TRUE | 1 | 18931.618584694 | 0.0591179 | XLM |
18 | :questId | 2025-02-28 19:48:31.000 | 6df90181c07565971b89c971b154901e367780239dfb24fc708954a2bf6b28e0 | 1 | GACFIZTF7D6BDMKN75KNPEE3HISHEARUX5MQHGR2KAUBFEJJN27NWKKL | TRUE | 1 | 88.100367763 | 0.0303599 | XLM |
19 | :questId | 2025-02-10 23:49:21.000 | 16b0c79acdb99116c50900dc84b035eb4094d2407707cf571ad653dec5b6e503 | 1 | GACH2U2W6BRNOOKQPAX5RP2PCX3KANTHWL3OC5EOSFYVEB5IQVLJPN52 | TRUE | 1 | 3.176254128 | 0.0303524 | XLM |
20 | :questId | 2025-02-01 06:17:40.000 | 11cb864aa6984d36cd96bd9cc29126760a821cf7f7a567c7ba8b6d66abc36abd | 1 | GA23IZLI4576FJS7NH2KCHBNGQC5W777U3U6VME4WY52TBNX27RZNWP6 | TRUE | 1 | 3.95809842 | 0.0303939 | XLM |
Flipside Data ScienceMarch Onboarding #5 - Borrow on Blend
Updated 2025-03-07
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
),
bridge as (
SELECT distinct
t.transaction_hash as tx_id,
t.block_timestamp as block_timestamp,
asset_balance_changes[0]:to::string as address,
1 as action_count,
TRUE as valid,
1 as quest_step,
'XLM' as currency,
asset_balance_changes[0]:amount::FLOAT AS amount_usd,
amount_usd/sp.avg_price as token_amount,
tx.fee_charged/pow(10,7) as fee_amount
from stellar.core.ez_operations t
LEFT JOIN stellar.core.fact_transactions tx
on t.transaction_hash = tx.transaction_hash
left join stellar_prices sp
on sp.hour::date = t.block_timestamp::date
Last run: 10 days ago
...
1114
221KB
11s