QUEST_ID | BLOCK_TIMESTAMP | TX_ID | ACTION_COUNT | ADDRESS | VALID | QUEST_STEP | TOKEN_AMOUNT | FEE_AMOUNT | CURRENCY | |
|---|---|---|---|---|---|---|---|---|---|---|
1 | :questId | 2025-02-02 21:29:45.000 | a44a3115538acecbe9f18e2550fb861e0c4e75eedc22392c09900680b63d33fa | 1 | GA6L2HMDXVTV7C2ONSCITALK2XUMFVLM5CVGAYZ6WOTUU47F24FURFPJ | TRUE | 1 | 205.7054532 | 0.0306256 | XLM |
2 | :questId | 2025-01-30 08:37:41.000 | d730cce2c22e25097a159a1b6d2eb51d46e23df58cbcec3673b3323966780b43 | 1 | GAGNU4JUDML3BYEAH5MOKWDNYSIMWNKP2WZX5XM4WZZ4H7Y4RPGYBLOX | TRUE | 1 | 44.4184911 | 0.0336665 | XLM |
3 | :questId | 2025-01-30 18:26:30.000 | bbbaecb46aa6ea87da3afa0601d87ccae16e260f2ed608e7050b33c389cde2b8 | 1 | GB5F2BYPFRSCMQPPR226EDCMZDVAVYNN5JIEDLPIN2AV3QMYKUFNXHNB | TRUE | 1 | 50000 | 0.0261952 | XLM |
4 | :questId | 2025-02-14 12:24:27.000 | ebfce57a2ce4f71f5bea278e09a16ab23fd0a1cc1dffc196a6fd4e461560df52 | 1 | GBUNDGF4GERH44WAOSJFBDZG5AFFHSZBAZVTFNN4SOE63BGDDDYQAV2G | TRUE | 1 | 1407 | 0.0304653 | XLM |
5 | :questId | 2025-02-02 23:32:23.000 | 1795d4d1e78982172ba6a66508f56e8211f9840badee71c5074d52eadd795174 | 1 | GBQPDBTU6Z6COF3AYFJNH3PWGN2I6T2LT6BN2W362IBVICJCCACIFEJ6 | TRUE | 1 | 3879.8867187 | 0.0306259 | XLM |
6 | :questId | 2025-02-07 16:36:02.000 | 8dc033d6454430d7006af274b53e863a8254e756078b4ca046a2b08c03de8c48 | 1 | GCW4SUVKGLI7CE4OMG2OHBKOYCL4VVEZODCXBZ6ND5PPYVVPQF6FGS7D | TRUE | 1 | 815.9359569 | 0.5843274 | XLM |
7 | :questId | 2025-02-02 18:09:53.000 | b5e4df76b712f2b5798a236c8e35bf0f14c1415855c7c983e5e226d514dc629a | 1 | GC2MYUXTFAINLGN3OSBLMKXIU4NH5GVSFYOVHSZMMZHQSILM7GFND633 | TRUE | 1 | 1000 | 0.0306256 | XLM |
8 | :questId | 2025-02-07 20:23:44.000 | 65dca950844f6f4d29747b038fcd6291dba5d09bd571b8a86fb0bfca6053ba0f | 1 | GCDJOIQAXVS524TI73TLEH7RBOSGN3RI4FRHTNNKWPDCPV3O4QJQUO2N | TRUE | 1 | 11653.737762 | 0.5080148 | XLM |
9 | :questId | 2025-02-03 14:43:18.000 | f94919ee23349a67df705647cd22580f413aea163ba24b404bfce39d72166506 | 1 | GBRULQUQFFBBMWVFNG4C4RQPMHSY7BWZGG3MJTTITVJ2ONDZN7P7P2P2 | TRUE | 1 | 515 | 0.0305653 | XLM |
10 | :questId | 2025-02-04 04:46:05.000 | 7b895f46565800ed42b08aaf16c2487c72d32a08af019493cbb4c2a0d2da49b8 | 1 | GACCBSKZSBXIJTQQ3XI6AJVWBMRJFHS2VRSN3YLUVGCR5UTTS74DMXUX | TRUE | 1 | 35000 | 0.0339383 | XLM |
11 | :questId | 2025-02-03 12:02:03.000 | 88dbc9c2a2a571326589822226d456569e9b4d753212492bfe73cf49ce088eee | 1 | GAVG3ODZ4SAVK2WJL3F3RT265RL7P6QNOMA6NL3XDAREKSX3OWWMXF4R | TRUE | 1 | 100 | 0.0458843 | XLM |
12 | :questId | 2025-02-02 18:09:10.000 | e709ea4a17a3c248bee9fa7ddbcd3fc1cd42a1786c1ccd012b31b33f2c9c31dc | 1 | GBDNEPSHOFVIKZABLIGA7SE34IM2CTRFPIYATEL53QD26WV7FFH3XGU3 | TRUE | 1 | 25 | 0.030626 | XLM |
13 | :questId | 2025-02-19 10:22:32.000 | f32ff2d94e40419c8fb46b8c518d926c1d3995e60e02dc85b2bc249d2bca4b40 | 1 | GBPCAZQPU3EIXTZAGKBR3GAXWMAXYW4QAB2HKPRSZ5TLWI37XHS6SXL3 | TRUE | 1 | 50 | 0.5857538 | XLM |
14 | :questId | 2025-02-09 02:31:35.000 | 6e28ded5d953c92683cefcb7829645f6a319827ae59727c607069b52b7fe70b3 | 1 | GDMRUBAP6J3KGWNZ3LDIPMHHLV4X6DXVIXBKK2XVZP2HSN36U4ETQIJB | TRUE | 1 | 5 | 0.5832058 | XLM |
15 | :questId | 2025-02-22 06:56:53.000 | 035e3277caa0d9410b157282311c2cbcd5bd0679f46c3486c49608b94e7469b5 | 1 | GCY6N3Y3E7FQ65IGRBFSPXELJXMIFYZQCWJTSCFBJDBKSHJOLL7SBG6D | TRUE | 1 | 225 | 0.3493384 | XLM |
16 | :questId | 2025-02-10 22:28:00.000 | 37e4df6d9f5af23c9a283867b37f61daaf2b37bb25b112a680be911399cb638a | 1 | GD5Z6NYV3WT4VIQHTNKXDU4MDUBDHK6KGICDFJGJXP4NWPVCS4ZJPZNP | TRUE | 1 | 3000000 | 0.3416126 | XLM |
17 | :questId | 2025-02-03 08:11:17.000 | d8dc258a7a6e2b30c5ab1e4eed1989c689ed955ae43e756c74d46919bf33f5bb | 1 | GDQMVKZGLZV75PCKX2YJPJBJXTBNXDJDHSXUY6CLIAYRCWAYGXUGIAMR | TRUE | 1 | 224488.261045 | 0.0559489 | XLM |
18 | :questId | 2025-02-07 10:21:19.000 | 935d6debea0b94d647318703680a8ae8458f9b081038ae69efaa2f91325f5663 | 1 | GCRLO4N2ZZYRHXBKHEJFASPUNT4TDETWO5ALO22SZVBX3NRSFIIHXQEB | TRUE | 1 | 1000 | 0.3398429 | XLM |
19 | :questId | 2025-02-05 22:45:53.000 | 855b5f09e3c48dffd63df6f1686a7b7f45a95906b19fe461e94dda62958c5158 | 1 | GAU64EGGNDGL7EPH2NJXTDNPIHLRJ5LHC7KQAGQEBBSYDUSF6GAZJEMQ | TRUE | 1 | 80 | 0.2301514 | XLM |
20 | :questId | 2025-02-21 10:17:33.000 | 382e7d95551874c3cfef4c75f6c82d4b2c7e14619809d2222287bb581a55a4c9 | 1 | GAONV4JS3LMEBTDT2C6DTEIGCSHSJUG2IGYQ2CPCARXRSQG7ESPWA547 | TRUE | 1 | 1994 | 0.5867229 | XLM |
Flipside Data ScienceMarch Onboarding #4 - Lend 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]:from::string as address,
1 as action_count,
TRUE as valid,
1 as quest_step,
'XLM' as currency,
asset_balance_changes[0]:amount::FLOAT 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
where
-- t.block_timestamp::date >= '2025-01-30'
-- and tx.block_timestamp::date >= '2025-01-30'
t.asset_balance_changes[0]:from::string in (:userAddresses)
Last run: 10 days ago
24
5KB
6s