flipside

    Getting Started
    amishas157Getting Started
    Updated 10 days ago

    -- Get started with Flipside by running your first query:
    -- the SQL statement below will get you a list of NFT
    -- platforms on Ethereum, ranked by how many sales
    -- they've had in the past month.

    -- Be sure to see our documentation for more guidance,
    -- including a full walkthrough of the app:
    -- https://docs.flipsidecrypto.xyz/our-app/getting-started

    select
    *
    from stellar.core.fact_ledgers
    order by batch_run_date desc
    limit 8

    Last run: 10 days ago
    SEQUENCE
    LEDGER_HASH
    PREVIOUS_LEDGER_HASH
    TRANSACTION_COUNT
    OPERATION_COUNT
    CLOSED_AT
    BLOCK_TIMESTAMP
    ID
    TOTAL_COINS
    FEE_POOL
    BASE_FEE
    BASE_RESERVE
    MAX_TX_SET_SIZE
    PROTOCOL_VERSION
    SUCCESSFUL_TRANSACTION_COUNT
    FAILED_TRANSACTION_COUNT
    TX_SET_OPERATION_COUNT
    BATCH_ID
    BATCH_RUN_DATE
    BATCH_INSERT_TS
    SOROBAN_FEE_WRITE_1KB
    NODE_ID
    SIGNATURE
    TOTAL_BYTE_SIZE_OF_BUCKET_LIST
    FACT_LEDGERS_ID
    INSERTED_TIMESTAMP
    MODIFIED_TIMESTAMP
    1
    		560917875874365735a503c27e37a2e63bfddea1981249e73afdaeac9801b4c6a25c902f0a5e8a59b3b032a3d1e5dbe8a55a9533d73c663e86c0acc70e77375b5a1ac4381444502025-03-10 19:55:59.0002025-03-10 19:55:59.000240912390739197950105443902087347290052964690765050100500000010002214438507scheduled__2025-03-10T20:00:00+00:00-cc2025-03-10 19:50:00.0002025-03-10 20:11:06.00011128GDDANSYOYSY5EPSFHBRPCLX6XMHPPLIMHVIDXG6IPQLVVLRI2BN4HMH3
    ZP6nFOroslriIaiwUENsXngP0GsC1HBdkUKLN6txvbzl+D2Aw34gB+VGj4crwtOMS7S05uET...
    		105259153426fddbccf8c96687c275e0364c01a13842025-03-10 20:32:12.8192025-03-10 20:32:12.819
    2
    		5609181601d7e27c7042044dfdeb9db527c9d0d39a8c01b4f42377584a3da9d47f0d5548090562827a745316f56b6838479426d84845d11f49086401e65d123c110749a91713162025-03-10 19:58:48.0002025-03-10 19:58:48.0002409125152932495401054439020873472900529648284574451005000000100022171668993scheduled__2025-03-10T20:00:00+00:00-cc2025-03-10 19:50:00.0002025-03-10 20:11:06.00011128GCB2VSADESRV2DDTIVTFLBDI562K6KE3KMKILBHUHUWFXCUBHGQDI7VL
    HuAiHf69lvBV53p6ms//3b0IMJZFRZ72lTXGd8humRHKEPdGtHSgNmKVqLJiHQuEcUE4ZZiM...
    		10525915342333fe8571a3951a1bfaf5d6a78a1cf912025-03-10 20:32:12.8192025-03-10 20:32:12.819
    3
    		5609177913466f6b8adbdd4390a665f22f02f55afcfb16e6ad8680b8977708bb564f28eeb6e06ecc39d320f1f761db186c8422670b41e8fd54b3410708e5a937b10fd9c22106702025-03-10 19:55:10.0002025-03-10 19:55:10.0002409123563794596001054439020873472900529646455971621005000000100022210122809scheduled__2025-03-10T20:00:00+00:00-cc2025-03-10 19:50:00.0002025-03-10 20:11:06.00011128GBPLJDBFZO2H7QQH7YFCH3HFT6EMC42Z2DNJ2QFROCKETAPY54V4DCZD
    awerc3JZcStrIh221ENwbRKcPZHQKXPBMoP24qLGv5xOTZxQkn5H9X3XBzP+HxnyemIo2rfH...
    		1052591534243996f8a54a52d949365e3d2f0dd4df22025-03-10 20:32:12.8192025-03-10 20:32:12.819
    4
    		56091813bf1820f989b5003a5af661ca6a676da7071856e7d6d193cdef999278b9aa678c539c3f34ed3860440ff8f4d49eb07ce24f564c262e46705e2338dd500a738c711224902025-03-10 19:58:28.0002025-03-10 19:58:28.000240912502408347650105443902087347290052964712182576100500000010002212235638scheduled__2025-03-10T20:00:00+00:00-cc2025-03-10 19:50:00.0002025-03-10 20:11:06.00011128GCIXVKNFPKWVMKJKVK2V4NK7D4TC6W3BUMXSIJ365QUAXWBRPPJXIR2Z
    37r7dbAe3JUxpocu/DcqNCCHL9srkubUBMBoLEAU5h/hHXtayO9Pp1bsdYprGHFk/ji3Oc0s...
    		1052591534288c0a6783201ba52b02ceef522eeb3272025-03-10 20:32:12.8192025-03-10 20:32:12.819
    5
    		560917983b71d5613e32166303b008e2ddedf4a5edc9bc5a483e6732d8f5b6e9dc9d4ae8ec7451945b2e67214370655bdf0fa6322c5aebdc312c0d426adecb31b691eab31218152025-03-10 19:57:02.0002025-03-10 19:57:02.000240912437983838200105443902087347290052964705669400100500000010002212124948scheduled__2025-03-10T20:00:00+00:00-cc2025-03-10 19:50:00.0002025-03-10 20:11:06.00011128GCGB2S2KGYARPVIA37HYZXVRM2YZUEXA6S33ZU5BUDC6THSB62LZSTYH
    hmi4r9JwfH0FUx16xCZMcCo9TGzUAgRUd3Ei9ekQeX8bz4cm0uNuds89I+UEUG0XxBCeoTLr...
    		1052591534202dd6e9b831c5554ddd60119897731572025-03-10 20:32:12.8192025-03-10 20:32:12.819
    6
    		56091747d030f932c69120d927f3c09455a7a1bcdf9495bc91259552194324dd860c7dd06d5238bea53dd2170b238df751a55f38e3f72d2bed441561639545f90461abbb1593252025-03-10 19:52:04.0002025-03-10 19:52:04.0002409122189405061001054439020873472900529645840815681005000000100022159652989scheduled__2025-03-10T20:00:00+00:00-cc2025-03-10 19:50:00.0002025-03-10 20:11:06.00011128GCGB2S2KGYARPVIA37HYZXVRM2YZUEXA6S33ZU5BUDC6THSB62LZSTYH
    Djm/YuFVX0mWHyu9TKgZh3zM9QhY3Rem6Iyv88ZA25cMppBXpAMyiGx+WFEICMAoH0tJtjVD...
    		105257991289c5504c119f97ecc60ff5e3e2fa99ae82025-03-10 20:32:12.8192025-03-10 20:32:12.819
    7
    		56091824f8139b524049186dc698265b83c0c7f66c212b0054d07f18f891a74a761fe9d4c764d4e9f7370aea4f42649c9bdae457dbb2b9d8d4b419b8671ee835f2dd66a41762872025-03-10 19:59:39.0002025-03-10 19:59:39.00024091254965298790010544390208734729005296495041731510050000001000221767141007scheduled__2025-03-10T20:00:00+00:00-cc2025-03-10 19:50:00.0002025-03-10 20:11:06.00011128GBLJNN3AVZZPG2FYAYTYQKECNWTQYYUUY2KVFN2OUKZKBULXIXBZ4FCT
    BDt0dnnGyxT5ISLfW/jqs39dptfHXpCghxjHcdrDSCBcNnIQ4xPtsfSzkhPs0lSYQicihHbx...
    		105259153421934f93e9327cc75b142064ca5c7cb5d2025-03-10 20:32:12.8192025-03-10 20:32:12.819
    8
    		56091812539c3f34ed3860440ff8f4d49eb07ce24f564c262e46705e2338dd500a738c71180f5557a406ee90e7050b89ea04f58c206daa625eb269a03fcc2a53ebe914da1587772025-03-10 19:58:22.0002025-03-10 19:58:22.000240912498113380350105443902087347290052964712117776100500000010002215842822scheduled__2025-03-10T20:00:00+00:00-cc2025-03-10 19:50:00.0002025-03-10 20:11:06.00011128GAYXZ4PZ7P6QOX7EBHPIZXNWY4KCOBYWJCA4WKWRKC7XIUS3UJPT6EZ4
    1XwC3wqzARCNRzUSMMMmnLZRpz95oylGjqERhOTuXKwpi2Vr7+ozPbJbOSSXER1L6XFFCymy...
    		1052591534282a53b385b6476280d1d70f37ae012772025-03-10 20:32:12.8192025-03-10 20:32:12.819
    8
    5KB
    2s