LittlerDatastride on cosmos
    Updated 2023-11-06


    select
    *
    from cosmos.core.fact_msg_attributes
    where msg_type = 'send_packet'
    and try_parse_json(attribute_value):receiver ilike '%stride%'
    and try_parse_json(attribute_value):denom like 'transfer/channel-391/stuumee'
    limit 10

    select
    *
    from crosschain.cosmos.fact_transactions
    where tx_id = 'EBD172A112F52348632D04E1B8EA82FBF68500201EA3C6F4BBD3027133E52A4F'


    [{"events":[{"type":"message","attributes":[{
    "key":"action","value":"/ibc.core.client.v1.MsgUpdateClient"}
    ,{"key":"module","value":"ibc_client"}]}
    ,{"type":"update_client","attributes":
    [{"key":"client_id","value":"07-tendermint-1018"}
    ,{"key":"client_type","value":"07-tendermint"},
    {"key":"consensus_height","value":"2-4474182"},
    {"key":"header","value":"0a262f6962632e6c69676874636c69656e74732e74656e6465726d696e742e76312e4865616465721288cd010af04e0a96030a02080b120d717569636b73696c7665722d3218c68a9102220c08defd9faa0610c2c8d080012a480a20024abb983875e30f8d5d2ebdfe0b9265eed6f8faab7a84c0302b53c1b6877bce12240801122027e57ac97724edd9dcdf7682f08235d8e10d662dacd56fe86144e055a968dbb53220e3b0a15f3c024bf45c93f5f29d330adbb63987908eb8758d370dae2df6417f5f3a207dc9d717e5677aff9b3b7570dda66a361ba0aee93457f22ba65492ca74fae4224220540f15a67ac4fb8d36d6e29cc0b6e3bf89216af8eba86b41047b36eabd5dd5154a20540f15a67ac4fb8d36d6e29cc0b6e3bf89216af8eba86b41047b36eabd5dd5155220ace7ce5f91282b7f9b0d5f28e086c72272ac0c199baa60908d320945924197255a2097482e8a2431a74e8f00488e2093badf975ae1f02dd1dbb4c8099aea01aaca8162200434bb7ca21aadeaddce82b7c89f25ec995dacb6cdcc150edd9c4190acc7f1a96a20e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b8557214079c3d20305fb3987ec57bf88de85cc328c350c612d44b08c68a91021a480a20111816012048d9ba5443e297d716b4acd7d500c3c5a8e620c9a42cf194fe84d31224080212209a3d99c9ad43b6a4d68798944f6843552cd6f01605936b8842964baf4cfefba9226708021214a29ccf3c040af1364479b54ed919336e0007d2261a0b08e4fd9faa0610e7b980192240a0b7f3bc7dd536e53aa31ba7391c7d90bc2b42f868158549f1fc6cdfbdc7317e3fef017ae88e2aa0a29325555b54c4c8cf962f5347926cc3d9190e8f18cf6d0f220f08011a0b088092b8c398feffffff012267080212142e81d030da5183ac3ec0a9a4881b490e57a7f7df1a0b08e4fd9faa0610a6b78f3d2240544af672f0bdf5e9a119173a108439d4690ae4773bdd32cc1585eb01d1d9f4dfc52fa84303a2954d8185f9a63223bf809f93d73048e2f30dce4eda1bcf8ee70322670802121414b1a9bf60ac2a39199fceda7ffbe955006536011a0b08e4fd9faa0610f5b7b3462240500eae9d9eebe3c91f35397c40b96b4cb8c691788e91a0171dcd59d3899a7afc4fa0447e3bd8ab6940e50d5e38c85a76992d0ede6f7d3202bc64c17848237708220f08011a0b088092b8c398feffffff01226708021214c208b06801271002e74317038f3560aa375dc93d1a0b08e4fd9faa0610d599af36224017fde413a4b7f72f6604ecceab7df4707d719bb3c1a127a46b47110dad966662efebe24a9091728c61ba22d541b9295af8e4dc001a97118bcc0eed873df38d092267080212148978e47a1ffd76e10b797adef8361df2e50bbd171a0b08e4fd9faa0610d89e8b3a22408d07daa1e4133bb2b1b9fc879d05d486f8eb50409c1f550350a77f2004bf2e2cb2deca726a0974f536b77204c139ddf83c27d5119ec2ef6e1b8c6c483731d407220f08011a0b088092b8c398feffffff01226708021214904f8738b2c1587fe478cedb591e85392ad0ce161a0b08e4fd9faa0610de9d874922403db36b8310e7cbae30de178dedacff264dee874d7ef8c4ab4abcf0baff69dc6c57ab9273a428a97a35dda138bcf12bf32bea9aa8a475dd2c842874b85e14cc03226708021214d87540046efd125608ad67b1b850b371866816ef1a0b08e4fd9faa0610e3d19c532240be07c7986c884b84e55329f86403baa0186bd0ad175c4beb25563efd8b4e3e66518c6812b0c5e344e4d024c027b995338ac8db58de89ad8630ac9c0d6a47dd04226708021214b898abfaa3dee351449c9f8a4c9d44bed1f391e31a0b08e4fd9faa0610f5e683382240fc45dfbb7ae422b149056956bbac3a7b2f3e048501b56844f8a97d830a1341d39fdffd957ef7737088f62ca6595a55a1854e08b5b72e8ee7bac577bd19dd910b220f08011a0b088092b8c398feffffff012267080212145170fa28f501c7ef770b2c962bc2bb1491d68ce21a0b08e4fd9faa0610f7bdbe2c22406b88b7e9fe86d19042e2a725e26149a3ff361e974a6b7f16094543564917c09cc832256f4fe77a4c81cd72fd0460771ac67ce7168073d3ea676b1f2bdf30280c226708021214f6e10e4c24c1d4cf6161380e3d8d62e52707876f1a0b08e4fd9faa061081d48831224001c833db22c39298aeeae0d2dff545eb07dfdd0da1eb44d49ea72928886ba6037b18f4417ce37cf5e89884fbcfb5dea8cd67ed9bc2f053fed2b32fca2037810e220f08011a0b088092b8c398feffffff01226708021214b90f0e3a974d2048291800f51c2b0ce5e35043e61a0b08e4fd9faa0610d9a49c282240374c7bd2bbbd9c272365932dd96948d942445de15339f2aab0ec873c56344b8944876baafdae1e9f0cbfb6b287d954d393ee10aaec38dc43fe6a15a2d94ed70422670802121446b3df55c65a53ab6f8105eae4ec11dd1f85cbaa1a0b08e4fd9faa0610a8eea23122402a78c5d43807d48a23771741572a78c1625b936b8ef7f971c02d8c8b24643e6984303e75b5911cd4aa0a555463b3321801c2062d2a73bac7e298db12c2dc8407226708021214cf2451ebbec4ce30d0c1ff815755976fd9ce97311a0b08e4fd9faa0610f5b9ed492240d46b74408f344bc0fd69e3260e0a1b6a63e05c3938aa66d58448fdf72e7cd394023bc99b893fc66e375f21df41d24b1aaf1e3b7fbaea824e4
    e7303af47ed0b0d226708021214db3e772c7e39c751035c50e583400a56ae1102551a0b08e4fd9faa0610b4d5bb3e2240835181c0ad1aa378c041b849bc65e12ca46e10d8c958e22036c377
    fee8d124618358ca6f74ec58c29956c624080224609eadab0c5d0d741c2c6d3c7b187a2706220f08011a0b088092b8c398feffffff01226708021214ac646c10d537262120cbe6db06371b3
    120884f901a0b08e4fd9faa0610efefe3332240b16ee053253871fbaf938af02c831215195d1cc37f1865dc39c24a907f998f15ce69c43ca6d13ad4c52b233148b13a1f068fc2a8bc706f28
    daff624dc3ec00072267080212140b4236f46eb7cb95529126c2108caffc9d2cca331a0b08e4fd9faa06109294e83722401084851b6aa5024a312b2c618512b1e85fdc5d77405c583450da9
    9e1b567ae090159d9cec40c96b8eadfb2662809ebb99da99333e1c6f95bb57e34ac85b20e06220f08011a0b088092b8c398feffffff01226708021214649b58049652e35a60c4d77e44ec1e5
    1c39efd901a0b08e4fd9faa0610aeffe63a22406f2e79e26246ff744b6f07c5d2e622077388e98e5d5307621f9872568b9da1c1475363191d6c8a6fbcda7bbbb249a16136b1ddaec85c3236
    a68d4fcbe26c2b06220f08011a0b088092b8c398feffffff0122670802121461d8997762afe3a4b9117fb166b49edcddd8ddd71a0b08e4fd9faa0610b9ecb1472240c220824bc1a2688bab23
    68f98fb1b30420408ca152b086004b4bea4b6c108661931770864beb445a9f44f60b9d24f76bf074b57d2bdcf4967a872c28f88cf80e220f08011a0b088092b8c398feffffff012267080212
    14194ed59341bcae170891c69bd53cba41705324201a0b08e4fd9faa0610cdd39f2c2240e868c68fc94a4dac03d0edc46a3a1146ead602dea40397a6ed71f59e2f7eb737183abe41ef6a2f57
    c425dd2ec32abb9f1da5c1c6c424feb8081ef88ca57a4a09220f08011a0b088092b8c398feffffff01220f08011a0b088092b8c398feffffff01220f08011a0b088092b8c398feffffff01226
    708021214876c9676e90fea72beb58fe66ad0bff5a45fe7ba1a0b08e4fd9faa06108dd6fa2f22407ac9aa8e6c7bd0a19dc1743cff0ceb9439cda71ab6b9a571ee0b5370a03531ade58715535f
    Run a query to Download Data