flipside

    required-brown
    mamad-5XN3k3required-brown
    Updated 2025-02-17
    select *
    from stellar.defi.fact_trades
    where SELLING_ASSET_CODE = 'XLM' or BUYING_ASSET_CODE = 'XLM'
    order by BLOCK_TIMESTAMP DESC
    limit 2000

    select *
    from stellar.core.fact_accounts
    order by BLOCK_TIMESTAMP DESC
    limit 1000
    Last run: 27 days ago
    HISTORY_OPERATION_ID
    TRADE_ORDER
    LEDGER_CLOSED_AT
    BLOCK_TIMESTAMP
    SELLING_ACCOUNT_ADDRESS
    SELLING_ASSET_CODE
    SELLING_ASSET_ISSUER
    SELLING_ASSET_TYPE
    SELLING_ASSET_ID
    SELLING_AMOUNT
    BUYING_ACCOUNT_ADDRESS
    BUYING_ASSET_CODE
    BUYING_ASSET_ISSUER
    BUYING_ASSET_TYPE
    BUYING_ASSET_ID
    BUYING_AMOUNT
    PRICE_N
    PRICE_D
    SELLING_OFFER_ID
    BUYING_OFFER_ID
    BATCH_ID
    BATCH_RUN_DATE
    BATCH_INSERT_TS
    SELLING_LIQUIDITY_POOL_ID
    LIQUIDITY_POOL_FEE
    TRADE_TYPE
    ROUNDING_SLIPPAGE
    SELLER_IS_EXACT
    _INSERTED_TIMESTAMP
    FACT_TRADES_ID
    INSERTED_TIMESTAMP
    MODIFIED_TIMESTAMP
    1
    		23953635623205683032025-02-17 03:59:03.0002025-02-17 03:59:03.000SHXGDSTRSHXHGJ7ZIVRBXEYE5Q74XUVCUSEKEBR7UCHEUUEK72N7I7KJ6JHcredit_alphanum457613640906855100001.1175GBZAEGCPKK7TROUGYEZW65DSOC72AX7SGKZH7ADDKXYJ4BXVVGD7YGAQXLMGAE5PQNUIP5E6HKBJ4HNKDFOORALGVRHU24FEADI5GQGUOEFUXLIWXLMcredit_alphanum4-409931416910308560012.5509566125509566111750004851222374659445000scheduled__2025-02-17T04:00:00+00:00-cc2025-02-17 03:50:00.0002025-02-17 04:11:01.00001b30e589f23b9362f870b5882e8d0221432a1e127ee2edcdbc06a1ab5eda5db3020TRUE2025-02-17 04:18:09.0007687e5f9bb3ffbd9021c98fd129e586b2025-02-17 04:33:06.7522025-02-17 04:33:06.752
    2
    		23953635623205683022025-02-17 03:59:03.0002025-02-17 03:59:03.000XLMGAE5PQNUIP5E6HKBJ4HNKDFOORALGVRHU24FEADI5GQGUOEFUXLIWXLMcredit_alphanum4-409931416910308560012.5509566GBZAEGCPKK7TROUGYEZW65DSOC72AX7SGKZH7ADDKXYJ4BXVVGD7YGAQXRPGBXRPL45NPHCVMFFAYZVUVFFVKSIZ362ZXFP7I2ETNQ3QKZMFLPRDTD5credit_alphanum4-35597193675562560000.0054528545281255095664851222374659445000scheduled__2025-02-17T04:00:00+00:00-cc2025-02-17 03:50:00.0002025-02-17 04:11:01.000ef4bc5674758df1a87d6594260de53cb120d214314a02788cd737884c2b5261a3020TRUE2025-02-17 04:18:09.0007f62432549276b069adba33cefa87ac82025-02-17 04:33:06.7522025-02-17 04:33:06.752
    3
    		23953630039812915042025-02-17 03:57:50.0002025-02-17 03:57:50.000VELOGDM4RQUQQUVSKQA7S6EM7XBZP3FCGH4Q7CL6TABQ7B2BEJ5ERARM2M5Mcredit_alphanum42513837991087332000.020742GCO45COWIBDZEGJ3DRGDGCCCJXK777F2S6D6HXQKXVB3EKQVCQU7B2WAXLMGBLWK4NIZBSD3Y2WUPXW6LPPMR3NOB2M6XTIRXSKDMV2F5MM5GMUBXLMcredit_alphanum4-7289998519671496000229537.796726122953779672612074204851222318825517000scheduled__2025-02-17T04:00:00+00:00-cc2025-02-17 03:50:00.0002025-02-17 04:11:01.00092ed9896c75917ca97a8dbd81401d3ea1aee6b46685379f5a1b1fba0f9626eca302100TRUE2025-02-17 04:18:09.000cfe51897d44655ae4d2e92c41051198b2025-02-17 04:33:06.7522025-02-17 04:33:06.752
    4
    		23953630039812915032025-02-17 03:57:50.0002025-02-17 03:57:50.000XLMGBLWK4NIZBSD3Y2WUPXW6LPPMR3NOB2M6XTIRXSKDMV2F5MM5GMUBXLMcredit_alphanum4-7289998519671496000229537.7967261GCO45COWIBDZEGJ3DRGDGCCCJXK777F2S6D6HXQKXVB3EKQVCQU7B2WAAFRGBX6YI45VU7WNAAKA3RBFDR3I3UKNFHTJPQ5F6KOOKSGYIAM4TRQN54Wcredit_alphanum42038883643097029000.5388816538881622953779672614851222318825517000scheduled__2025-02-17T04:00:00+00:00-cc2025-02-17 03:50:00.0002025-02-17 04:11:01.00058ed18506c5f1412e584962e459ec6d1cd1fe6d658dcac16470f0d1886762b013020TRUE2025-02-17 04:18:09.000a61fb15c075d0bc1e594c72e13726de62025-02-17 04:33:06.7522025-02-17 04:33:06.752
    5
    		23953570769214260012025-02-17 03:44:27.0002025-02-17 03:44:27.000XLMGA5CHXDIKQL77I7MFGBSDZIJIVWXOXQ4Z7RZODSEK2J6PF6FQSGQGSECcredit_alphanum4653836631771786600010.6138692GBLVLKGRDU66WLWY4XRORJXCC4LDZ347AQTUYBEPBABIZTVITW2OAGIPNLTGAX25ZVO4JVPEDK3R7EUFCGVI5XCOQGMVGQNZVFLGY2RWTBIQBW2ZNLTcredit_alphanum4351431007790865970045.7173044571730401061386924851221726119530000scheduled__2025-02-17T03:50:00+00:00-cc2025-02-17 03:40:00.0002025-02-17 04:01:29.000338cbb0744042659acb9b7701f54bb05230302bcc521ddfaa1e47b18dda958723020FALSE2025-02-17 04:18:09.000ee7910aa5e5e09fb6d3f0c34e44a310d2025-02-17 04:33:06.7522025-02-17 04:33:06.752
    6
    		23953570769214260022025-02-17 03:44:27.0002025-02-17 03:44:27.000native-57067058045835480000.0055484GBLVLKGRDU66WLWY4XRORJXCC4LDZ347AQTUYBEPBABIZTVITW2OAGIPXLMGA5CHXDIKQL77I7MFGBSDZIJIVWXOXQ4Z7RZODSEK2J6PF6FQSGQGSECcredit_alphanum4653836631771786600010.6138692106138692554844851221726119530000scheduled__2025-02-17T03:50:00+00:00-cc2025-02-17 03:40:00.0002025-02-17 04:01:29.000488e78fcc4085e3a9b5f3c7e867a17d96b97b7bb6ea01129a913045e9acd48603020FALSE2025-02-17 04:18:09.000b3fdde8e743cbc2dda8514cfd76df24a2025-02-17 04:33:06.7522025-02-17 04:33:06.752
    7
    		23953562608844390012025-02-17 03:42:36.0002025-02-17 03:42:36.000yUSDCGDGTVWSM4MGS4T7Z6W4RPWOCHE2I6RDFCIFZGS3DOA63LWQTRNZNTTFFcredit_alphanum12-65018771175468280000.0000332GDWYK4FLMLY7DE273XTKASLT4WDZT46RZT2IC6BPC7WGIPU7HRW37V6IXLMGA5CHXDIKQL77I7MFGBSDZIJIVWXOXQ4Z7RZODSEK2J6PF6FQSGQGSECcredit_alphanum465383663177178660000.183963518396353324851221644515832000scheduled__2025-02-17T03:50:00+00:00-cc2025-02-17 03:40:00.0002025-02-17 04:01:29.0001a7d55e943109d17fa1580445f93a796a4ad9c920d0cedea8751047de796e08d3020FALSE2025-02-17 04:18:09.0009c50b408b43ded9e73f8a484c2d60bd52025-02-17 04:33:06.7522025-02-17 04:33:06.752
    8
    		23953562608844390002025-02-17 03:42:36.0002025-02-17 03:42:36.000XLMGA5CHXDIKQL77I7MFGBSDZIJIVWXOXQ4Z7RZODSEK2J6PF6FQSGQGSECcredit_alphanum465383663177178660000.1839635GDWYK4FLMLY7DE273XTKASLT4WDZT46RZT2IC6BPC7WGIPU7HRW37V6INLTGAX25ZVO4JVPEDK3R7EUFCGVI5XCOQGMVGQNZVFLGY2RWTBIQBW2ZNLTcredit_alphanum435143100779086597000.79092790920018396354851221644515832000scheduled__2025-02-17T03:50:00+00:00-cc2025-02-17 03:40:00.0002025-02-17 04:01:29.000338cbb0744042659acb9b7701f54bb05230302bcc521ddfaa1e47b18dda958723020FALSE2025-02-17 04:18:09.0006606ffa49cc480b9a8532208beda30a62025-02-17 04:33:06.7522025-02-17 04:33:06.752
    9
    		23953525242551500042025-02-17 03:34:17.0002025-02-17 03:34:17.000XLMGAE5PQNUIP5E6HKBJ4HNKDFOORALGVRHU24FEADI5GQGUOEFUXLIWXLMcredit_alphanum4-40993141691030856000.0000293GCO45COWIBDZEGJ3DRGDGCCCJXK777F2S6D6HXQKXVB3EKQVCQU7B2WASBIXRPGAWBBEXU7IXHZERS7TVLJT2DHP65XAOH2ZBOI3GPRFE57UPSADU5SKUHcredit_alphanum1252443963222119240000.281041928104192934851221270852903000scheduled__2025-02-17T03:40:00+00:00-cc2025-02-17 03:30:00.0002025-02-17 03:51:05.0005d72eaefdf40efb34a258e540f179e50a2f1934de5c2de5638934cf10869e5d9302100TRUE2025-02-17 04:18:09.000a86de44e149c81198c455aa96686553a2025-02-17 04:33:06.7522025-02-17 04:33:06.752
    10
    		23953525242551500052025-02-17 03:34:17.0002025-02-17 03:34:17.000native-57067058045835480001e-7GCO45COWIBDZEGJ3DRGDGCCCJXK777F2S6D6HXQKXVB3EKQVCQU7B2WAXLMGAE5PQNUIP5E6HKBJ4HNKDFOORALGVRHU24FEADI5GQGUOEFUXLIWXLMcredit_alphanum4-40993141691030856000.000029329314851221270852903000scheduled__2025-02-17T03:40:00+00:00-cc2025-02-17 03:30:00.0002025-02-17 03:51:05.000232b00668adce63a7157f35c56ab11c4798984ca5a37a69a4a2745961e882fd0302100TRUE2025-02-17 04:18:09.000fcc206228638230307286aa1945211c42025-02-17 04:33:06.7522025-02-17 04:33:06.752
    11
    		23953502908742860002025-02-17 03:29:16.0002025-02-17 03:29:16.000GDHN7V7UZ6Y4X7TMXQC2JJD7L5WBX6RH6EDBDRQOHVVOX77HYAGP64UZXLMGBOI3JOTDZA5QJ5FMKW2JKW4TPY5ZXSTJUYTYJ7QIROVHCNGFH4GEUSXcredit_alphanum4-52450949879826280001GAWZCQCOHAYS35EM2FDCDLB2IUNLV73QTSIXTMMBZT6L73YYXNCAD6EMnative-570670580458354800011116943570634851221047514817000scheduled__2025-02-17T03:30:00+00:00-cc2025-02-17 03:20:00.0002025-02-17 03:41:00.0001true2025-02-17 04:18:09.000c95806e5957287a16a6cb39cea2296252025-02-17 04:33:06.7522025-02-17 04:33:06.752
    12
    		23953484010861363012025-02-17 03:25:02.0002025-02-17 03:25:02.000WGUARDIANGBYBVWOOVC4EJVRIF4HMWG5B7POLCS7JRPY5KYR3BCLEK24IJQOGUARDcredit_alphanum12388097072287931140088.7228484GDCVHDFEB2XBU2DHIDUUSC47W6LSE3UH4VFNIJBKRYQJCTOTAME6UBEDXLMGAE5PQNUIP5E6HKBJ4HNKDFOORALGVRHU24FEADI5GQGUOEFUXLIWXLMcredit_alphanum4-40993141691030856000.603019160301918872284844851220858536002000scheduled__2025-02-17T03:30:00+00:00-cc2025-02-17 03:20:00.0002025-02-17 03:41:00.00037cb70742bb50e8d86eb15026ad98df3e7ba7a0a986ed49af163fb1bab09f20f3020TRUE2025-02-17 04:18:09.00086ace590f8ce5f4f2af1f840b40fa5bb2025-02-17 04:33:06.7522025-02-17 04:33:06.752
    13
    		23953484010861363002025-02-17 03:25:02.0002025-02-17 03:25:02.000XLMGAE5PQNUIP5E6HKBJ4HNKDFOORALGVRHU24FEADI5GQGUOEFUXLIWXLMcredit_alphanum4-40993141691030856000.6030191GDCVHDFEB2XBU2DHIDUUSC47W6LSE3UH4VFNIJBKRYQJCTOTAME6UBEDyXLMGARDNV3Q7YGT4AKSDF25LT32YSCCW4EV22Y2TV3I2PU2MMXJTEDL5T55credit_alphanum447003574513935640000.0020912091060301914851220858536002000scheduled__2025-02-17T03:30:00+00:00-cc2025-02-17 03:20:00.0002025-02-17 03:41:00.0009de1df541089e674f42a2d4d447c3891c3ac18629e5556610cf7c955954b374c3020TRUE2025-02-17 04:18:09.00049c3fa421842540e43371d7269eaf0762025-02-17 04:33:06.7522025-02-17 04:33:06.752
    14
    		23953463824525312022025-02-17 03:20:26.0002025-02-17 03:20:26.000native-57067058045835480000.0033603GBLVLKGRDU66WLWY4XRORJXCC4LDZ347AQTUYBEPBABIZTVITW2OAGIPXLMGBLWK4NIZBSD3Y2WUPXW6LPPMR3NOB2M6XTIRXSKDMV2F5MM5GMUBXLMcredit_alphanum4-7289998519671496000701883.18819677018831881967336034851220656672641000scheduled__2025-02-17T03:30:00+00:00-cc2025-02-17 03:20:00.0002025-02-17 03:41:00.0007ffcd52ad7c8ff36bae996b59cc69367eff67838128de439dbd8b29fc3df72823020FALSE2025-02-17 04:18:09.000f6845000734f8f23e4ee756849d95faf2025-02-17 04:33:06.7522025-02-17 04:33:06.752
    15
    		23953463824525312012025-02-17 03:20:26.0002025-02-17 03:20:26.000XLMGBLWK4NIZBSD3Y2WUPXW6LPPMR3NOB2M6XTIRXSKDMV2F5MM5GMUBXLMcredit_alphanum4-7289998519671496000701883.1881967GBLVLKGRDU66WLWY4XRORJXCC4LDZ347AQTUYBEPBABIZTVITW2OAGIPAFRGBX6YI45VU7WNAAKA3RBFDR3I3UKNFHTJPQ5F6KOOKSGYIAM4TRQN54Wcredit_alphanum42038883643097029001.63230561632305670188318819674851220656672641000scheduled__2025-02-17T03:30:00+00:00-cc2025-02-17 03:20:00.0002025-02-17 03:41:00.00058ed18506c5f1412e584962e459ec6d1cd1fe6d658dcac16470f0d1886762b013020FALSE2025-02-17 04:18:09.000018a73708f8f2aa6eddf2abfdd750dc52025-02-17 04:33:06.7522025-02-17 04:33:06.752
    16
    		23953459959062120022025-02-17 03:19:35.0002025-02-17 03:19:35.000native-57067058045835480000.004629GBLVLKGRDU66WLWY4XRORJXCC4LDZ347AQTUYBEPBABIZTVITW2OAGIPXLMGCKGMO7NXXFNZUZGWH4RCAAQJZAYTUSIQFV6AGXF3E7G2TDA5UYLESVMcredit_alphanum4-6662336709583658000665579.19750276655791975027462904851220618018009000scheduled__2025-02-17T03:20:00+00:00-cc2025-02-17 03:10:00.0002025-02-17 03:31:02.000087724796bcc2259b5248dae6fd553c5f10e5b7b362d685d73816b00c9398ce93020FALSE2025-02-17 04:18:09.000bd557c82e120e47b33626e3e3be67d172025-02-17 04:33:06.7522025-02-17 04:33:06.752
    17
    		23953459959062120012025-02-17 03:19:35.0002025-02-17 03:19:35.000XLMGCKGMO7NXXFNZUZGWH4RCAAQJZAYTUSIQFV6AGXF3E7G2TDA5UYLESVMcredit_alphanum4-6662336709583658000665579.1975027GBLVLKGRDU66WLWY4XRORJXCC4LDZ347AQTUYBEPBABIZTVITW2OAGIPSDEXEXGBQHMDRWV3WU5YACBUUCBY4Y6PPWBJXW5WCSG5XJ63FC4HXJNGXYFD5Jcredit_alphanum12-894458416569730500037.509220137509220166557919750274851220618018009000scheduled__2025-02-17T03:20:00+00:00-cc2025-02-17 03:10:00.0002025-02-17 03:31:02.0006ba74aa4a56d310aaa6062fae11f836e571cbaec985147b2b44ef0a59fc0baa93020FALSE2025-02-17 04:18:09.000420af2e13cade5f9628a1ee92d647de22025-02-17 04:33:06.7522025-02-17 04:33:06.752
    18
    		23953449651221710012025-02-17 03:17:17.0002025-02-17 03:17:17.000WGUARDIANGBYBVWOOVC4EJVRIF4HMWG5B7POLCS7JRPY5KYR3BCLEK24IJQOGUARDcredit_alphanum123880970722879311400858.3785673GA6ZXCVN5DN4MD7ISUQJ7FSNPKYAQS4LMSQ4STL66YASSSZFBYIUVNFTXLMGAE5PQNUIP5E6HKBJ4HNKDFOORALGVRHU24FEADI5GQGUOEFUXLIWXLMcredit_alphanum4-40993141691030856005.81739365817393685837856734851220514939605000scheduled__2025-02-17T03:20:00+00:00-cc2025-02-17 03:10:00.0002025-02-17 03:31:02.00037cb70742bb50e8d86eb15026ad98df3e7ba7a0a986ed49af163fb1bab09f20f3020FALSE2025-02-17 04:18:09.000eaec6acb202364c1936395832db38a432025-02-17 04:33:06.7522025-02-17 04:33:06.752
    19
    		23953449651221710002025-02-17 03:17:17.0002025-02-17 03:17:17.000XLMGAE5PQNUIP5E6HKBJ4HNKDFOORALGVRHU24FEADI5GQGUOEFUXLIWXLMcredit_alphanum4-40993141691030856005.8173936GA6ZXCVN5DN4MD7ISUQJ7FSNPKYAQS4LMSQ4STL66YASSSZFBYIUVNFTnative-57067058045835480000.02200000581739364851220514939605000scheduled__2025-02-17T03:20:00+00:00-cc2025-02-17 03:10:00.0002025-02-17 03:31:02.000232b00668adce63a7157f35c56ab11c4798984ca5a37a69a4a2745961e882fd03020FALSE2025-02-17 04:18:09.000e2709ccedbe9b8855be49fa174397f922025-02-17 04:33:06.7522025-02-17 04:33:06.752
    20
    		23953437195773133002025-02-17 03:14:25.0002025-02-17 03:14:25.000XLMGAE5PQNUIP5E6HKBJ4HNKDFOORALGVRHU24FEADI5GQGUOEFUXLIWXLMcredit_alphanum4-40993141691030856001.120081GBLVLKGRDU66WLWY4XRORJXCC4LDZ347AQTUYBEPBABIZTVITW2OAGIPyXLMGARDNV3Q7YGT4AKSDF25LT32YSCCW4EV22Y2TV3I2PU2MMXJTEDL5T55credit_alphanum447003574513935640000.003882138821112008104851220390385119000scheduled__2025-02-17T03:20:00+00:00-cc2025-02-17 03:10:00.0002025-02-17 03:31:02.0009de1df541089e674f42a2d4d447c3891c3ac18629e5556610cf7c955954b374c3020FALSE2025-02-17 04:18:09.0004b4570557c36a839e8ae0f81eb849c9d2025-02-17 04:33:06.7522025-02-17 04:33:06.752
    ...
    2000
    1MB
    8s