flipside

    brief-blue
    datavortexbrief-blue
    Updated 2025-05-05
    SELECT * from stellar.defi.fact_trades
    limit 50

    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
    FACT_TRADES_ID
    INSERTED_TIMESTAMP
    MODIFIED_TIMESTAMP
    1
    		21952724606203085002024-04-06 03:19:06.0002024-04-06 03:19:06.000GAHQDGQ4IFY44KD3KAQ52X74BHJYTEJWLAXRMOEB4CDC3TXJAMNAG4IQUSDCGA5ZSEJYB37JRC5AVCIA5MOP4RHTM335X2KGX3IHOJAPP5RE34K4KZVNcredit_alphanum4-40256212312713320000.385047GBAOFTAOWXN7OWXAFBRIK5TIPVAKAENIFOL3277SZB4WLY2TJB2QFNKCnative-5706705804583548000310000000128349015129123364831213264489419000scheduled__2024-04-06T06:00:00+00:00-state2024-04-06 03:00:00.0002024-07-10 12:32:27.0001FALSE616e3661b4aac5d7e84983e57df345372025-02-11 17:52:05.7792025-02-11 17:52:05.779
    2
    		21954479529794765002024-04-06 09:56:28.0002024-04-06 09:56:28.000GATSTEPDCMPZUIHKPQVTPO7XUQ4N52OEAYTLEULDIOBQGJRCUP4KGOLDBTCGDUKI5Y635ENDG2KZQUEOZDV6V7IPV2W7BDLP7YAXJ7PESNWVH4ZEBTCcredit_alphanum4-61093750686725250001e-7GBMIHBY7456RUM3EIROGUBFQWAKK44OD3M2S4ILCVJ32HAESNZFWRX73native-57067058045835480000.030315715157808950013909449544831230813725336000scheduled__2024-04-06T12:00:00+00:00-state2024-04-06 09:00:00.0002024-07-10 12:37:02.0001truebb24dc60289d570fa323052d77b82b4c2025-02-11 17:52:05.7792025-02-11 17:52:05.779
    3
    		21957454224144800002024-04-06 21:16:48.0002024-04-06 21:16:48.000GCBZXBR4Z27PZQFDYEHAOZCXBRO4SH5ZVI2S3QRROVR3LC3DPV2ZCOEYeWHIPGDWZD3BHGX2DCCZCAMBJMYHGBJHXSMAKI6FOS3YNN4YHXHFW5S3WHXLMcredit_alphanum12-19753135858765645000.0225708GBRY7RZAHTUCL6LPPWTYYMWWMYG2LAMABA5J3BFDEWW3HCSJF3ZQTUWZnative-57067058045835480000.0999998443049611000000015134842824831260560668836000scheduled__2024-04-07T00:00:00+00:00-state2024-04-06 21:00:00.0002024-07-10 12:47:33.0001truec25336b0263b5fd38d23f7f9ba8392f92025-02-11 17:52:05.7792025-02-11 17:52:05.779
    4
    		21957021291487235002024-04-06 19:38:12.0002024-04-06 19:38:12.000GBM7E4FGKLCN7YG33VIKQC43SBAR6CG63ASL7KFS6WQ7TJQ33JCQNTUMQSOLGBBG66EKE77PPYWVKSEBIFSNBKMY2PJ7P5AYWTW7SBSXFOS7IK7MQQQQcredit_alphanum4-67271216184428120001e-7GBNWXVVJHMSOAVI5EPOMMCNPIF4ES57MYEG5CVHCI4NMHJKINGC62WALnative-57067058045835480000.000086886798131000014629117444831256231342260000scheduled__2024-04-06T21:00:00+00:00-state2024-04-06 18:00:00.0002024-07-10 12:43:45.0001trueb0135ffd7c8a08c53a2a3011efef03a92025-02-11 17:52:05.7792025-02-11 17:52:05.779
    5
    		21952206203612780002024-04-06 01:20:45.0002024-04-06 01:20:45.000GCLLU2IKJQAX6DQGXJXVZDWMYWRXQ6LISC7O5SGEOS7BFNISWI6TEXLMeBRONZEGCD2ZPSPGHIVZXRLONJL2BYBQNHAPNE2ODXHEX5FH2AN5N4BSUU6BRNZcredit_alphanum1233341972082830157000.00001GCT6EPQFFAVS3VKTA47F2Z6V7YDSVIU664OFAKATSLNJAK4HESBXYT2Unative-57067058045835480001e-7110011392855374831208080463516000scheduled__2024-04-06T03:00:00+00:00-state2024-04-06 00:00:00.0002024-07-10 12:28:24.0001truea357697b3803953f79c526b0096bb1ee2025-02-11 17:52:05.7792025-02-11 17:52:05.779
    6
    		21957345131951720012024-04-06 20:51:47.0002024-04-06 20:51:47.000SHXGDSTRSHXHGJ7ZIVRBXEYE5Q74XUVCUSEKEBR7UCHEUUEK72N7I7KJ6JHcredit_alphanum4576136409068551000018.0088282GCEETSI6ZGG3CS37YUFAUKCCJSCOILXL43JOJVZ435KBJ5NICDYY4EMPXAUGBCB4WO6J4ET55RWK2SVX76LUQ4PQ7TCDHG2YFILQML7D6XR3HACLXAUcredit_alphanum4-1727830864732900000195460.441504619546044150461800882824831259469746905000scheduled__2024-04-06T21:00:00+00:00-state2024-04-06 18:00:00.0002024-07-10 12:43:45.0000913cc390df388df2b18142f074a7c50d3b9001d062b9a4d6d1037ba09cda4fd3020FALSEd5755489f6bb9c868a29bafaff03986a2025-02-11 17:52:05.7792025-02-11 17:52:05.779
    7
    		21955229431290678002024-04-06 12:46:47.0002024-04-06 12:46:47.000GDFULLQBYFLVP2IPGQZ2UEX7FTCGMXPCNPU4JQPCJIHATJTTBQL4IISOIOTAGDYTPLRPLGQRF7OUUUB3XD6N6PO5F2567W3SF3U7WCDOIGNS5XOT6ISOcredit_alphanum4-46663942144115010000.00001GARZJBSD2VANLMWICH7DVFKPBV6GZ6JWUWU44LXKFL3UW6HLHLBSDRMVnative-57067058045835480000.000023211599500015103354564831238312740295000scheduled__2024-04-06T15:00:00+00:00-state2024-04-06 12:00:00.0002024-07-10 12:39:29.0001true03b034b7b1733866a2806821573d33442025-02-11 17:52:05.7792025-02-11 17:52:05.779
    8
    		21957750576894360022024-04-06 22:24:22.0002024-04-06 22:24:22.000native-57067058045835480001.5652521GBPXJQQOQKXPCGKVAL3VO4VVHK3K5T7FHBXJ6OVFY744R7TTDQI4ULI2LIBREGAYCCWKECNGDRHYU3UTREBD2XLC3CUQN6FV22TKM4WCQER3IWR7TF5CYcredit_alphanum12-89283519574974060001346.583738913465837389156525214831263524196332000scheduled__2024-04-07T00:00:00+00:00-state2024-04-06 21:00:00.0002024-07-10 12:47:33.000c8557b9d18c07040effa3c3528e7a09d19651ebf20ccd3d412ee94388d481c973020FALSEbba1b1f556d52003fd4e0b65a48a1fd92025-02-11 17:52:05.7792025-02-11 17:52:05.779
    9
    		21952160677009414002024-04-06 01:10:23.0002024-04-06 01:10:23.000GASMYGUOLDSSHG4WFCQF64CNWETRTN65THTW42Q6X7JQSNJMEFIKLOBSQNTGDEPJGYMDQQCJGMWQ4VCJZO7NHGIRYR2RGGBCHC3G7FMBN7KTW6T6QNTcredit_alphanum468052039712729360001e-7GBNWXVVJHMSOAVI5EPOMMCNPIF4ES57MYEG5CVHCI4NMHJKINGC62WALnative-57067058045835480000.0000868599910014126932304831207625197482000scheduled__2024-04-06T03:00:00+00:00-state2024-04-06 00:00:00.0002024-07-10 12:28:24.0001truef9442ed9e1d5bb64d8ba2e518f1733a22025-02-11 17:52:05.7792025-02-11 17:52:05.779
    10
    		21954479529794765002024-04-06 09:56:28.0002024-04-06 09:56:28.000GA3RAEHQZBFDTGAG6J35Z3JILHCFYZPLREYLHOFIR7TQAESZ5LG5YTKNYFIGDIVI7XEI4KDJUDHBEV3HRGBZNG3NRDZENTWYBPTZVQQZEE5U4A53YFIcredit_alphanum46313876832731956001e-7GBMIHBY7456RUM3EIROGUBFQWAKK44OD3M2S4ILCVJ32HAESNZFWRX73native-57067058045835480000.00674531349044320014084274454831230813725336000scheduled__2024-04-06T12:00:00+00:00-state2024-04-06 09:00:00.0002024-07-10 12:37:02.0001true8a5e649fb7fc6d097792a184fd8c06222025-02-11 17:52:05.7792025-02-11 17:52:05.779
    11
    		21952916591199030002024-04-06 04:02:17.0002024-04-06 04:02:17.000GALGRTXTUOGUWBKBCOSY77N37NKAHT6SCCX7IZAHKM2A6GHVK3FSYXLMBTCGBCGL54RP2GDMYMLJ3YM2A4M76RTRD62CDHAO2B3JMNOHOYCNTXUYXLMcredit_alphanum4-62411168879750060001e-7GARZJBSD2VANLMWICH7DVFKPBV6GZ6JWUWU44LXKFL3UW6HLHLBSDRMVnative-57067058045835480000.06008156008143110015103220604831215184339378000scheduled__2024-04-06T06:00:00+00:00-state2024-04-06 03:00:00.0002024-07-10 12:32:27.0001true80a2c90db2e62356b7fc2aeaa222bf8b2025-02-11 17:52:05.7792025-02-11 17:52:05.779
    12
    		21953200918216704002024-04-06 05:06:19.0002024-04-06 05:06:19.000VOLVOGB2L46JCH5EPMJIL2VOPUGGWCFFE237JPX6CIV4UDHFMUGOXRNGXZZ7Qcredit_alphanum12336398625396760770100000000GDVVX4TSNTOJ2LLW75CTALVSE2WDMLD7ANHPQXKKHDPRWI2SXTAEGMTBnative-57067058045835480000.1314093131409310000000000000004831218027609555000scheduled__2024-04-06T06:00:00+00:00-state2024-04-06 03:00:00.0002024-07-10 12:32:27.000f660dfac2b956f2aef8a524e9da469a7245f2cbe7a913bca4fa7f07ec49927603020TRUEd2d6515f10445d4178771b361a9955582025-02-11 17:52:05.7792025-02-11 17:52:05.779
    13
    		21953092684884790002024-04-06 04:41:45.0002024-04-06 04:41:45.000GDNWFHBXX6TVG2K3B6H6UNJONU6HEBX6MAHUHNA6PWKZJG6NYD4QHR2TDOTGD5N37F4W76AACJ26JPS3O66QGQTB5QBXGMK2RAUMLDB4V5XOMTWFDOTcredit_alphanum4-65921311149529150000.0000123GB2UMTIXCTHPBS2ZGWGJOUMCCG2SPYP2M7WS7PWCLNFKFDSL57UMSP4Pnative-57067058045835480000.00061371995599740000014968694964831216945276236000scheduled__2024-04-06T06:00:00+00:00-state2024-04-06 03:00:00.0002024-07-10 12:32:27.0001true0fc07863d0ec259bf45d282bd52bd9752025-02-11 17:52:05.7792025-02-11 17:52:05.779
    14
    		21957345131984490002024-04-06 20:51:47.0002024-04-06 20:51:47.000GALGRTXTUOGUWBKBCOSY77N37NKAHT6SCCX7IZAHKM2A6GHVK3FSYXLMSOLGCHYNVUJ3F3PE3DJ2GLL63IVN3Z4CFWHH7DHC7S6O6IZV73BKCJ2YXLMcredit_alphanum428217523362919890001e-7GARZJBSD2VANLMWICH7DVFKPBV6GZ6JWUWU44LXKFL3UW6HLHLBSDRMVnative-57067058045835480000.00014311430799100015103133184831259469747233000scheduled__2024-04-06T21:00:00+00:00-state2024-04-06 18:00:00.0002024-07-10 12:43:45.0001true8188c692642dbbf1b2e17a21d095872e2025-02-11 17:52:05.7792025-02-11 17:52:05.779
    15
    		21957453794826243002024-04-06 21:16:43.0002024-04-06 21:16:43.000GBM7E4FGKLCN7YG33VIKQC43SBAR6CG63ASL7KFS6WQ7TJQ33JCQNTUMQMotionGCN6R6M5QVKSBJKDB423WOTN3J44N7LLPAJNLZ5A2DH46MYNOWYNQQQQcredit_alphanum1279651325453852410000.000001GBNWXVVJHMSOAVI5EPOMMCNPIF4ES57MYEG5CVHCI4NMHJKINGC62WALnative-57067058045835480000.000817181703771000014629065764831260556375650000scheduled__2024-04-07T00:00:00+00:00-state2024-04-06 21:00:00.0002024-07-10 12:47:33.0001true97f6777c7da4ab3e637b3f1701ab6a712025-02-11 17:52:05.7792025-02-11 17:52:05.779
    16
    		21957750576903782002024-04-06 22:24:22.0002024-04-06 22:24:22.000DasKapitalGBJEIA7DSCBQS37XH6NYBVDVF6DDYM33DJRP6PIQQQNBQLSHHCUKVIDScredit_alphanum12-38256969791175665000.0174778GCU7LJ5S6U3YCTSLLZNMRHJBSXVI6O5WPQIJ2ESLYTYIUJ7WMSXNYERDyUSDCGDGTVWSM4MGS4T7Z6W4RPWOCHE2I6RDFCIFZGS3DOA63LWQTRNZNTTFFcredit_alphanum12-65018771175468280000.055000001747784831263524196426000scheduled__2024-04-07T00:00:00+00:00-state2024-04-06 21:00:00.0002024-07-10 12:47:33.000a7f2126293ae3e89fbc5e94588053bc8900a4959bd77e185bbccf5d7863c132e3020FALSE14f18e56a551f3f2f2dd1cf30bcba9442025-02-11 17:52:05.7792025-02-11 17:52:05.779
    17
    		21954276807428096002024-04-06 09:09:54.0002024-04-06 09:09:54.000GAA4EB53D25TK7QNGQ3J3YJ4I76CWTI6P62AJ2XB5TODXDOOLMR7CNC5BARDGDMSCG4PFEU7ONMTPXR3JGCJ7PMR7VSZM6MDTHTVXQ6KPOYXUPZJBARDcredit_alphanum4-830108670696621800.0983606GBYWHYX6YCIEX3MYPVLWNJFKLZYSB6CGIDZOZJK225FK2DGNHCKGXBWYnative-57067058045835480000.000002461250000015130944334831228786501669000scheduled__2024-04-06T12:00:00+00:00-state2024-04-06 09:00:00.0002024-07-10 12:37:02.0001true07bf139ffe8f61254be2ba57cf22a4122025-02-11 17:52:05.7792025-02-11 17:52:05.779
    18
    		21955268515368966002024-04-06 12:55:44.0002024-04-06 12:55:44.000GCO42MADBE4QFAMLXHV4AXG4FIQR5JBAMLSE3RYNRD427E4FPGSO3ETNHKDGDBCB4LPTVWSDBL6TMLP6VBLNK37XELWNP7EZH4E6TYFXC4EF2PAQHKDcredit_alphanum4-3024872877129213000.00001GBCAV3OLMM266S2NT63ADZTFALHJKLDXPPCJWURAQJESG5ZBYW4PN2ADnative-57067058045835480001e-7110015079590214831238703581078000scheduled__2024-04-06T15:00:00+00:00-state2024-04-06 12:00:00.0002024-07-10 12:39:29.0001true7c0ad05f27ebedfb52e027c19c97b6532025-02-11 17:52:05.7792025-02-11 17:52:05.779
    19
    		21955855637395870002024-04-06 15:10:13.0002024-04-06 15:10:13.000GDFULLQBYFLVP2IPGQZ2UEX7FTCGMXPCNPU4JQPCJIHATJTTBQL4IISOQNTGDSOU45EFM2N3F55CYM6EYZDP5DS3FDTTDEXS4RBTQ5ICSWGK5LD4ISOcredit_alphanum4-73541606217354830001e-7GARZJBSD2VANLMWICH7DVFKPBV6GZ6JWUWU44LXKFL3UW6HLHLBSDRMVnative-57067058045835480000.000092757914762515103329674831244574801347000scheduled__2024-04-06T18:00:00+00:00-state2024-04-06 15:00:00.0002024-07-10 12:43:03.0001truede8f82483cf8c566760b0e8a2e00c3552025-02-11 17:52:05.7792025-02-11 17:52:05.779
    20
    		21955917484830310022024-04-06 15:24:31.0002024-04-06 15:24:31.000AQUAGBNZILSTVQZ4R7IKQDGHYGY2QXL5QOFJYQMXPKWRRM5PAV7Y4M67AQUAcredit_alphanum490204874547600360001.2814285GAWLY7WEF5GGT5WCX2MMJEZG3CHLW73P7QJWOL7YWKV2LVH7NVL67ZVN818GBACAAL2B4E3B2CFEODT22E7R6W4THW5B7QPJUJXCBJP6TWKL4ZR6ILYcredit_alphanum419406415847010826001971.613724319716137243128142854831245193275691000scheduled__2024-04-06T18:00:00+00:00-state2024-04-06 15:00:00.0002024-07-10 12:43:03.000939f511557d90c7b6e1f498ba7e778423173b6684060733d077781847816a4e83020FALSE5d721d3e4b5cb7f6cbe602b5d3cd23f92025-02-11 17:52:05.7792025-02-11 17:52:05.779
    50
    30KB
    1s