[{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: List the latest 5 blocks of 2021.\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT ?blockNumber ?slotNumber ?epochNumber ?timestamp ?blockSize ?hash ?transactionCount\n WHERE {\n ?block a b:Block ;\n c:hasBlockNumber ?blockNumber ;\n c:hasSlotNumber ?slotNumber ;\n b:hasTimestamp ?timestamp ;\n c:hasBlockSize ?blockSize ;\n c:hasEpoch ?epoch ;\n b:hasHash ?hash .\n ?epoch c:hasEpochNumber ?epochNumber .\n BIND (\"2021-01-01T00:00:00Z\"^^xsd:dateTime AS ?startDate)\n BIND (\"2021-12-31T23:59:59Z\"^^xsd:dateTime AS ?endDate)\n FILTER (?timestamp \u003e= ?startDate \u0026\u0026 ?timestamp \u003c= ?endDate)\n OPTIONAL { ?block b:hasTxCount ?transactionCount }\n }\n ORDER BY DESC(?blockNumber)\n LIMIT 5\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: Plot a bar chart showing monthly number of transactions in 2021.\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT\n ?timePeriod\n (SUM(?txCount) AS ?totalTxs)\n WHERE {\n ?block a b:Block ;\n b:hasTxCount ?txCount ;\n b:hasTimestamp ?timestamp .\n BIND (\"2021-01-01T00:00:00Z\"^^xsd:dateTime AS ?startDate)\n BIND (\"2021-12-31T23:59:59Z\"^^xsd:dateTime AS ?endDate)\n BIND(SUBSTR(STR(?timestamp), 1, 7) AS ?timePeriod)\n FILTER (?timestamp \u003e= ?startDate \u0026\u0026 ?timestamp \u003c= ?endDate)\n }\n GROUP BY ?timePeriod\n ORDER BY ?timePeriod\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: Plot a line chart showing monthly number of transactions and outputs in 2021.\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT\n ?timePeriod\n (COUNT(?tx) AS ?totalTxs)\n (SUM(COALESCE(?outputsCount, 0)) AS ?totalOutputs)\n WHERE {\n ?block a b:Block ;\n b:hasTx ?tx ;\n b:hasTimestamp ?timestamp .\n OPTIONAL { ?tx c:hasTxOutputCount ?outputsCount . }\n BIND (\"2021-01-01T00:00:00Z\"^^xsd:dateTime AS ?startDate)\n BIND (\"2021-12-31T23:59:59Z\"^^xsd:dateTime AS ?endDate)\n BIND(SUBSTR(STR(?timestamp), 1, 7) AS ?timePeriod)\n FILTER (?timestamp \u003e= ?startDate \u0026\u0026 ?timestamp \u003c= ?endDate)\n }\n GROUP BY ?timePeriod\n ORDER BY ?timePeriod\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: Plot a line chart showing monthly number of transactions, inputs and outputs in 2021.\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT\n ?timePeriod\n (COUNT(?tx) AS ?totalTxs)\n (SUM(COALESCE(?inputsCount, 0)) AS ?sumInputs)\n (SUM(COALESCE(?outputsCount, 0)) AS ?totalOutputs)\n WHERE {\n ?block a b:Block ;\n b:hasTx ?tx ;\n b:hasTimestamp ?timestamp .\n OPTIONAL { ?tx c:hasTxInputCount ?inputsCount . }\n OPTIONAL { ?tx c:hasTxOutputCount ?outputsCount . }\n BIND (\"2021-01-01T00:00:00Z\"^^xsd:dateTime AS ?startDate)\n BIND (\"2021-12-31T23:59:59Z\"^^xsd:dateTime AS ?endDate)\n BIND(SUBSTR(STR(?timestamp), 1, 7) AS ?timePeriod)\n FILTER (?timestamp \u003e= ?startDate \u0026\u0026 ?timestamp \u003c= ?endDate)\n }\n GROUP BY ?timePeriod\n ORDER BY ?timePeriod\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: Plot a bar chart showing monthly multi assets created.\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT\n ?timePeriod\n (COUNT(DISTINCT ?cnt) AS ?deployments)\n WHERE {\n ?cnt a c:MultiAssetCNT ;\n c:hasCreationTimestamp ?timestamp .\n BIND(SUBSTR(STR(?timestamp), 1, 7) AS ?timePeriod)\n }\n GROUP BY ?timePeriod\n ORDER BY ?timePeriod\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: Plot a bar chart showing monthly multi assets created in 2021.\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT\n ?timePeriod\n (COUNT(DISTINCT ?cnt) AS ?deployments)\n WHERE {\n ?cnt a c:MultiAssetCNT ;\n c:hasCreationTimestamp ?timestamp .\n BIND (\"2021-01-01T00:00:00Z\"^^xsd:dateTime AS ?startDate)\n BIND (\"2021-12-31T23:59:59Z\"^^xsd:dateTime AS ?endDate)\n BIND(SUBSTR(STR(?timestamp), 1, 7) AS ?timePeriod)\n FILTER (?timestamp \u003e= ?startDate \u0026\u0026 ?timestamp \u003c= ?endDate)\n }\n GROUP BY ?timePeriod\n ORDER BY ?timePeriod\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: Plot a line chart showing number of multi assets created per epoch.\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT\n ?epochNumber\n (COUNT(?asset) AS ?totalAssets)\n WHERE {\n ?block a b:Block ;\n b:hasTx ?tx ;\n c:hasEpoch ?epoch .\n ?epoch c:hasEpochNumber ?epochNumber .\n ?tx c:hasMintedAsset ?asset .\n ?asset a c:MultiAssetCNT .\n }\n GROUP BY ?epochNumber\n ORDER BY ?epochNumber\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: Plot a bar chart showing monthly number of transactions.\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT\n ?timePeriod\n (SUM(?txs) AS ?txCount)\n WHERE {\n ?block a b:Block ;\n b:hasTxCount ?txs ;\n b:hasTimestamp ?timestamp .\n BIND(SUBSTR(STR(?timestamp), 1, 7) AS ?timePeriod)\n }\n GROUP BY ?timePeriod\n ORDER BY ?timePeriod\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: Plot a line chart showing number of transactions per epoch.\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT\n ?epochNumber\n (SUM(?txCount) AS ?totalTxs)\n WHERE {\n ?block a b:Block ;\n b:hasTxCount ?txCount ;\n c:hasEpoch ?epoch .\n ?epoch c:hasEpochNumber ?epochNumber .\n }\n GROUP BY ?epochNumber\n ORDER BY ?epochNumber\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: Plot a line chart showing number of transactions and outputs per epoch.\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT\n ?epochNumber\n (COUNT(?tx) AS ?totalTxs)\n (SUM(COALESCE(?outputsCount, 0)) AS ?totalOutputs)\n WHERE {\n ?block a b:Block ;\n b:hasTx ?tx ;\n c:hasEpoch ?epoch .\n ?epoch c:hasEpochNumber ?epochNumber .\n OPTIONAL { ?tx c:hasTxOutputCount ?outputsCount . }\n }\n GROUP BY ?epochNumber\n ORDER BY ?epochNumber\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: Plot a line chart showing daily number of transactions and outputs on March, 2021.\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT\n ?timePeriod\n (COUNT(?tx) AS ?totalTxs)\n (SUM(COALESCE(?outputsCount, 0)) AS ?totalOutputs)\n WHERE {\n ?block a b:Block ;\n b:hasTx ?tx ;\n b:hasTimestamp ?timestamp .\n OPTIONAL { ?tx c:hasTxOutputCount ?outputsCount . }\n BIND (\"2021-03-01T00:00:00Z\"^^xsd:dateTime AS ?startDate)\n BIND (\"2021-03-31T23:59:59Z\"^^xsd:dateTime AS ?endDate)\n # Extract full YYYY-MM-DD\n BIND( SUBSTR(STR(?timestamp), 1, 10) AS ?timePeriod )\n FILTER (?timestamp \u003e= ?startDate \u0026\u0026 ?timestamp \u003c= ?endDate)\n }\n GROUP BY ?timePeriod\n ORDER BY ?timePeriod\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: Plot a line chart showing daily number of transactions and outputs on the first week of March, 2021.\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT\n ?timePeriod\n (COUNT(?tx) AS ?totalTxs)\n (SUM(COALESCE(?outputsCount, 0)) AS ?totalOutputs)\n WHERE {\n ?block a b:Block ;\n b:hasTx ?tx ;\n b:hasTimestamp ?timestamp .\n OPTIONAL { ?tx c:hasTxOutputCount ?outputsCount . }\n BIND (\"2021-03-01T00:00:00Z\"^^xsd:dateTime AS ?startDate)\n BIND (\"2021-03-07T23:59:59Z\"^^xsd:dateTime AS ?endDate)\n BIND(SUBSTR(STR(?timestamp), 9, 2) AS ?timePeriod)\n FILTER (?timestamp \u003e= ?startDate \u0026\u0026 ?timestamp \u003c= ?endDate)\n }\n GROUP BY ?timePeriod\n ORDER BY ?timePeriod\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: Plot a line chart showing weekly number of transactions and outputs on March, 2021.\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT\n ?timePeriod\n (COUNT(?tx) AS ?totalTxs)\n (SUM(COALESCE(?outputsCount, 0)) AS ?totalOutputs)\n WHERE {\n ?block a b:Block ;\n b:hasTx ?tx ;\n b:hasTimestamp ?timestamp .\n OPTIONAL { ?tx c:hasTxOutputCount ?outputsCount . }\n BIND (\"2021-03-01T00:00:00Z\"^^xsd:dateTime AS ?startDate)\n BIND (\"2021-03-31T23:59:59Z\"^^xsd:dateTime AS ?endDate)\n BIND(CONCAT(\n SUBSTR(STR(?timestamp), 1, 7),\n \"-W\",\n STR(FLOOR((xsd:integer(SUBSTR(STR(?timestamp), 9, 2)) - 1) / 7) + 1)\n ) AS ?timePeriod)\n FILTER (?timestamp \u003e= ?startDate \u0026\u0026 ?timestamp \u003c= ?endDate)\n }\n GROUP BY ?timePeriod\n ORDER BY ?timePeriod\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: What is your current tip and the current cardano tip?\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n SELECT ?currentCardanoHeight (MAX(?blockNum) AS ?capBlockNum) (COUNT(?block) AS ?count)\n WHERE {\n c:Cardano c:hasBlockNumber ?currentCardanoHeight .\n ?block a b:Block .\n ?block c:hasBlockNumber ?blockNum .\n }\n GROUP BY (?currentCardanoHeight)\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: What is the current cardano height and the current height you have in your database\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n SELECT ?currentCardanoHeight (MAX(?blockNum) AS ?capBlockNum) (COUNT(?block) AS ?count)\n WHERE {\n c:Cardano c:hasBlockNumber ?currentCardanoHeight .\n ?block a b:Block .\n ?block c:hasBlockNumber ?blockNum .\n }\n GROUP BY (?currentCardanoHeight)\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: What is your current sync status?\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n SELECT ?currentCardanoHeight (MAX(?blockNum) AS ?capBlockNum) (COUNT(?block) AS ?count)\n WHERE {\n c:Cardano c:hasBlockNumber ?currentCardanoHeight .\n ?block a b:Block .\n ?block c:hasBlockNumber ?blockNum .\n }\n GROUP BY (?currentCardanoHeight)\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: What is your sync status?\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n SELECT ?currentCardanoHeight (MAX(?blockNum) AS ?capBlockNum) (COUNT(?block) AS ?count)\n WHERE {\n c:Cardano c:hasBlockNumber ?currentCardanoHeight .\n ?block a b:Block .\n ?block c:hasBlockNumber ?blockNum .\n }\n GROUP BY (?currentCardanoHeight)\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: What is your current status?\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n SELECT ?currentCardanoHeight (MAX(?blockNum) AS ?capBlockNum) (COUNT(?block) AS ?count)\n WHERE {\n c:Cardano c:hasBlockNumber ?currentCardanoHeight .\n ?block a b:Block .\n ?block c:hasBlockNumber ?blockNum .\n }\n GROUP BY (?currentCardanoHeight)\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: What is your status?\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n SELECT ?currentCardanoHeight (MAX(?blockNum) AS ?capBlockNum) (COUNT(?block) AS ?count)\n WHERE {\n c:Cardano c:hasBlockNumber ?currentCardanoHeight .\n ?block a b:Block .\n ?block c:hasBlockNumber ?blockNum .\n }\n GROUP BY (?currentCardanoHeight)\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: What is the CAP's status?\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n SELECT ?currentCardanoHeight (MAX(?blockNum) AS ?capBlockNum) (COUNT(?block) AS ?count)\n WHERE {\n c:Cardano c:hasBlockNumber ?currentCardanoHeight .\n ?block a b:Block .\n ?block c:hasBlockNumber ?blockNum .\n }\n GROUP BY (?currentCardanoHeight)\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: Time of the latest update\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n SELECT ?timestamp\n WHERE {\n ?block a b:Block ;\n c:hasBlockNumber ?blockNumber ;\n b:hasTimestamp ?timestamp .\n }\n ORDER BY DESC(?blockNumber)\n LIMIT 1\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: Last update\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n SELECT ?timestamp\n WHERE {\n ?block a b:Block ;\n c:hasBlockNumber ?blockNumber ;\n b:hasTimestamp ?timestamp .\n }\n ORDER BY DESC(?blockNumber)\n LIMIT 1\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: What is your latest update?\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n SELECT ?timestamp\n WHERE {\n ?block a b:Block ;\n c:hasBlockNumber ?blockNumber ;\n b:hasTimestamp ?timestamp .\n }\n ORDER BY DESC(?blockNumber)\n LIMIT 1\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: What was the average transaction fee last week?\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT ?startDate ?endDate ?avgFee\n WHERE {\n BIND (NOW() AS ?endDate)\n BIND (NOW() - \"P7D\"^^xsd:dayTimeDuration AS ?startDate)\n {\n SELECT ((SUM(COALESCE(?fee, 0)) / COUNT(?tx)) AS ?avgFee)\n WHERE {\n ?block a b:Block ;\n b:hasTx ?tx ;\n b:hasTimestamp ?timestamp .\n BIND (NOW() - \"P7D\"^^xsd:dayTimeDuration AS ?startDate)\n FILTER (?timestamp \u003e= ?startDate)\n OPTIONAL { ?tx c:hasFee ?fee . }\n }\n }\n }\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: Plot a bar chart showing monthly smart contract deployments\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT\n ?timePeriod\n (COUNT(DISTINCT ?script) AS ?deployments)\n WHERE {\n ?script a c:PlutusScript ;\n c:hasCreationTimestamp ?timestamp .\n # Extract YYYY and MM\n BIND(SUBSTR(STR(?timestamp), 1, 4) AS ?year)\n BIND(SUBSTR(STR(?timestamp), 6, 2) AS ?month)\n # Build MM.YYYY\n BIND(CONCAT(?year, \".\", ?month) AS ?timePeriod)\n }\n GROUP BY ?timePeriod\n ORDER BY ?timePeriod\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: How many smart contracts were deployed today?\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT\n ?date\n (COUNT(DISTINCT ?script) AS ?deployments)\n WHERE {\n ?script a c:PlutusScript ;\n c:hasCreationTimestamp ?timestamp .\n BIND(xsd:date(?timestamp) AS ?date)\n BIND (xsd:date(NOW()) as ?startDate)\n FILTER (?date \u003e= ?startDate)\n }\n GROUP BY ?date\n ORDER BY ?date\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: How many NFTs were minted in the last month\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT (COUNT(DISTINCT ?asset) as ?nftCount)\n WHERE {\n ?asset a b:NFT ;\n c:hasCreationTimestamp ?timestamp .\n BIND (NOW() - \"P30D\"^^xsd:dayTimeDuration as ?startDate)\n FILTER (?timestamp \u003e= ?startDate)\n }\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: How many NFTs were minted today?\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT (COUNT(DISTINCT ?asset) as ?nftCount)\n WHERE {\n ?asset a b:NFT ;\n c:hasCreationTimestamp ?timestamp .\n BIND(xsd:date(?timestamp) AS ?date)\n BIND (xsd:date(NOW()) as ?startDate)\n FILTER (?date \u003e= ?startDate)\n }\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: List the most frequently transferred tokens in the last week\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT ?tokenName (COUNT(?output) as ?transfers) ?startDate\n WHERE {\n ?block a b:Block ;\n b:hasTimestamp ?timestamp .\n BIND(NOW() - \"P7D\"^^xsd:dayTimeDuration AS ?startDate)\n FILTER (?timestamp \u003e= ?startDate)\n ?block b:hasTx ?tx .\n ?tx c:hasTxOutput ?output .\n ?output b:hasTokenState ?tokenState .\n ?tokenState b:hasCurrency ?token .\n ?token b:hasTokenName ?tokenName .\n }\n GROUP BY ?tokenName ?startDate\n ORDER BY DESC(?transfers)\n LIMIT 10\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: Plot a line chart showing the number of new accounts created daily over the last month\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT ?date (COUNT(DISTINCT ?account) AS ?new_accounts)\n WHERE {\n BIND(NOW() - \"P30D\"^^xsd:dayTimeDuration AS ?startDate)\n ?account a b:Account ;\n c:hasCreationTimestamp ?timestamp .\n BIND(xsd:date(?timestamp) AS ?date)\n FILTER (?date \u003e= ?startDate)\n }\n GROUP BY ?date\n ORDER BY ?date\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: Show the 10 largest ADA transactions in the last 24 hours\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT ?txHash ?amount ?timestamp\n WHERE {\n ?block a b:Block ;\n b:hasTx ?tx ;\n b:hasTimestamp ?timestamp .\n BIND (NOW() - \"P1D\"^^xsd:dayTimeDuration as ?startDate)\n FILTER (?timestamp \u003e= ?startDate)\n ?tx c:hasTxOutput ?output ;\n b:hasTxID ?txHash .\n ?output b:hasTokenState ?tokenState .\n ?tokenState b:hasCurrency \u003chttps://mobr.ai/ont/cardano#cnt/ada\u003e ;\n b:hasValue ?amount .\n }\n ORDER BY DESC(?amount)\n LIMIT 10\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: Show the 5 largest ADA transactions today\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT ?txHash ?amount ?date\n WHERE {\n ?block a b:Block ;\n b:hasTx ?tx ;\n b:hasTimestamp ?timestamp .\n BIND(xsd:date(?timestamp) AS ?date)\n BIND (xsd:date(NOW()) as ?startDate)\n FILTER (?date \u003e= ?startDate)\n ?tx c:hasTxOutput ?output ;\n b:hasTxID ?txHash .\n ?output b:hasTokenState ?tokenState .\n ?tokenState b:hasCurrency \u003chttps://mobr.ai/ont/cardano#cnt/ada\u003e ;\n b:hasValue ?amount .\n }\n GROUP BY ?date\n ORDER BY DESC(?amount)\n LIMIT 5\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: Plot a bar chart showing number of daily transactions over the last month\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT\n ?date\n (COUNT(?tx) AS ?totalTxs)\n WHERE {\n BIND(NOW() - \"P30D\"^^xsd:dayTimeDuration AS ?startDate)\n ?block a b:Block ;\n b:hasTx ?tx ;\n b:hasTimestamp ?timestamp .\n BIND(xsd:date(?timestamp) AS ?date)\n FILTER (?date \u003e= ?startDate)\n }\n GROUP BY ?date\n ORDER BY ?date\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: Plot a line chart showing number of transactions and outputs daily over the last month\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT\n ?date\n (COUNT(?tx) AS ?totalTxs)\n (SUM(COALESCE(?outputsCount, 0)) AS ?totalOutputs)\n WHERE {\n BIND(NOW() - \"P30D\"^^xsd:dayTimeDuration AS ?startDate)\n ?block a b:Block ;\n b:hasTx ?tx ;\n b:hasTimestamp ?timestamp .\n BIND(xsd:date(?timestamp) AS ?date)\n FILTER (?date \u003e= ?startDate)\n OPTIONAL { ?tx c:hasTxOutputCount ?outputsCount . }\n }\n GROUP BY ?date\n ORDER BY ?date\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: Trace a line chart showing the number of NFTs minted daily in the last month\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT ?date (COUNT(DISTINCT ?asset) as ?nftCount)\n WHERE {\n BIND(NOW() - \"P30D\"^^xsd:dayTimeDuration AS ?startDate)\n ?asset a b:NFT ;\n c:hasCreationTimestamp ?timestamp .\n BIND(xsd:date(?timestamp) AS ?date)\n FILTER (?date \u003e= ?startDate)\n }\n GROUP BY ?date\n ORDER BY ?date\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: Bar chart showing number of smart contract deployed daily in the last month\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT\n ?timePeriod\n (COUNT(DISTINCT ?script) AS ?deployments)\n WHERE {\n BIND(NOW() - \"P30D\"^^xsd:dayTimeDuration AS ?startDate)\n ?script a c:PlutusScript ;\n c:hasCreationTimestamp ?timestamp .\n BIND(xsd:date(?timestamp) AS ?date)\n FILTER (?date \u003e= ?startDate)\n }\n GROUP BY ?date\n ORDER BY ?date\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: Plot a line chart showing the number of proposals submitted daily in the last month\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT\n (COUNT(?proposal) AS ?proposalCount)\n ?date\n WHERE {\n ?block b:hasTx ?tx ;\n b:hasTimestamp ?timestamp .\n BIND(xsd:date(?timestamp) AS ?date)\n FILTER (?date \u003e= ?startDate)\n ?proposal a c:GovernanceProposal .\n ?tx c:hasGovernanceProposal ?proposal ;\n b:hasTxID ?proposalTxHash .\n }\n GROUP BY ?date\n ORDER BY ?date\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: Line chart showing the number of multi assets created daily in the last month\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT\n (COUNT(?multiAsset) AS ?multiAssetCount)\n ?date\n WHERE {\n ?multiAsset a c:MultiAssetCNT ;\n c:hasCreationTimestamp ?timestamp .\n BIND(xsd:date(?timestamp) AS ?date)\n FILTER (?date \u003e= ?startDate)\n }\n GROUP BY ?date\n ORDER BY ?date\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: Current trends\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT\n ?date\n (SUM(?isScript) AS ?scriptsDeployed)\n (SUM(?isCNT) AS ?multiAssetsCreated)\n (SUM(?isNFT) AS ?nftsMinted)\n (SUM(?isAccount) AS ?accountsCreated)\n WHERE {\n BIND(NOW() - \"P7D\"^^xsd:dayTimeDuration AS ?startDate)\n ?e c:hasCreationTimestamp ?timestamp .\n BIND(xsd:date(?timestamp) AS ?date)\n FILTER (?date \u003e= ?startDate)\n BIND(\n IF(EXISTS { ?e a c:PlutusScript }, 1, 0)\n AS ?isScript\n )\n BIND(\n IF(EXISTS { ?e a c:MultiAssetCNT }, 1, 0)\n AS ?isCNT\n )\n BIND(\n IF(EXISTS { ?e a b:NFT }, 1, 0)\n AS ?isNFT\n )\n BIND(\n IF(EXISTS { ?e a b:Account }, 1, 0)\n AS ?isAccount\n )\n }\n GROUP BY ?date\n ORDER BY ?date\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: Trends past week\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT\n ?date\n (SUM(?isScript) AS ?scriptsDeployed)\n (SUM(?isCNT) AS ?multiAssetsCreated)\n (SUM(?isNFT) AS ?nftsMinted)\n (SUM(?isAccount) AS ?accountsCreated)\n WHERE {\n BIND(NOW() - \"P7D\"^^xsd:dayTimeDuration AS ?startDate)\n ?e c:hasCreationTimestamp ?timestamp .\n BIND(xsd:date(?timestamp) AS ?date)\n FILTER (?date \u003e= ?startDate)\n BIND(\n IF(EXISTS { ?e a c:PlutusScript }, 1, 0)\n AS ?isScript\n )\n BIND(\n IF(EXISTS { ?e a c:MultiAssetCNT }, 1, 0)\n AS ?isCNT\n )\n BIND(\n IF(EXISTS { ?e a b:NFT }, 1, 0)\n AS ?isNFT\n )\n BIND(\n IF(EXISTS { ?e a b:Account }, 1, 0)\n AS ?isAccount\n )\n }\n GROUP BY ?date\n ORDER BY ?date\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: Monthly trends\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT\n ?timePeriod\n (SUM(?isScript) AS ?scriptsDeployed)\n (SUM(?isCNT) AS ?multiAssetsCreated)\n (SUM(?isNFT) AS ?nftsMinted)\n (SUM(?isAccount) AS ?accountsCreated)\n WHERE {\n BIND(NOW() - \"P6M\"^^xsd:dayTimeDuration AS ?startDate)\n ?e c:hasCreationTimestamp ?timestamp .\n FILTER (?timestamp \u003e= ?startDate)\n BIND(\n CONCAT(\n SUBSTR(STR(?timestamp), 1, 4), \".\",\n SUBSTR(STR(?timestamp), 6, 2)\n ) AS ?timePeriod\n )\n BIND(\n IF(EXISTS { ?e a c:PlutusScript }, 1, 0)\n AS ?isScript\n )\n BIND(\n IF(EXISTS { ?e a c:MultiAssetCNT }, 1, 0)\n AS ?isCNT\n )\n BIND(\n IF(EXISTS { ?e a b:NFT }, 1, 0)\n AS ?isNFT\n )\n BIND(\n IF(EXISTS { ?e a b:Account }, 1, 0)\n AS ?isAccount\n )\n }\n GROUP BY ?timePeriod\n ORDER BY ?timePeriod\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: What is the average transaction fee today?\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT ?today ?avgFee\n WHERE {\n BIND (xsd:date(NOW()) as ?today)\n {\n SELECT ((SUM(COALESCE(?fee, 0)) / COUNT(?tx)) AS ?avgFee)\n WHERE {\n ?block a b:Block ;\n b:hasTx ?tx ;\n b:hasTimestamp ?timestamp .\n BIND(xsd:date(?timestamp) AS ?date)\n BIND (xsd:date(NOW()) as ?startDate)\n FILTER (?date \u003e= ?startDate)\n OPTIONAL { ?tx c:hasFee ?fee . }\n }\n }\n }\n GROUP BY ?today\n ORDER BY ?date\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: How many blocks were created in the cardano network?\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n SELECT (COUNT(?blocks) AS ?block_count)\n WHERE {\n ?blocks a b:Block .\n }\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: How many transactions in the cardano network?\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n SELECT (COUNT(?s) AS ?count)\n WHERE {\n ?s a b:Transaction .\n }\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: How many native tokens in the cardano network?\n "},{"role":"assistant","content":"\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n SELECT (COUNT(?s) AS ?count)\n WHERE {\n ?s a c:MultiAssetCNT .\n }\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: How many transactions in the last 24h?\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT (COUNT(?tx) AS ?count)\n WHERE {\n ?block a b:Block ;\n b:hasTx ?tx ;\n b:hasTimestamp ?timestamp .\n BIND (NOW() - \"P1D\"^^xsd:dayTimeDuration as ?startDate)\n FILTER (?timestamp \u003e= ?startDate)\n }\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: Plot a pie chart to show how much the top 1% ADA holders represent from the total supply on the Cardano network?\n "},{"role":"assistant","content":"\n \n ---split in multiple queries---\n ---query 1--- \n \n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n \n SELECT (COUNT(DISTINCT ?account) AS ?holders)\n WHERE {\n {\n SELECT ?account (SUM(xsd:decimal(?value)) AS ?totalAda)\n WHERE {\n FILTER NOT EXISTS { ?output c:hasOutputSpendTimestamp ?spendTimestamp . }\n ?account c:hasAccountUTXO ?output .\n ?output b:hasTokenState ?tokenState .\n ?tokenState b:hasCurrency \u003chttps://mobr.ai/ont/cardano#cnt/ada\u003e ;\n b:hasValue ?value .\n }\n GROUP BY ?account\n HAVING (?totalAda \u003e 0)\n }\n }\n ---query 2--- \n \n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n \n SELECT\n ((SUM(?balance) / ?totalSupply) AS ?topHolders)\n ((1 - (SUM(?balance) / ?totalSupply)) AS ?otherHolders)\n WHERE {\n {\n SELECT ?account (SUM(xsd:decimal(?value)) AS ?balance)\n WHERE {\n FILTER NOT EXISTS {?output c:hasOutputSpendTimestamp ?spendTimestamp .}\n ?account c:hasAccountUTXO ?output .\n ?output b:hasTokenState ?tokenState .\n ?tokenState b:hasCurrency \u003chttps://mobr.ai/ont/cardano#cnt/ada\u003e ;\n b:hasValue ?value .\n }\n GROUP BY ?account\n ORDER BY DESC(?balance)\n LIMIT INJECT(evaluate(holders * 0.01))\n }\n \u003chttps://mobr.ai/ont/cardano#cnt/ada\u003e b:hasTotalSupply ?totalSupply .\n }\n GROUP BY ?totalSupply\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: Show a table with the top 10 tokens by transfer count\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT ?tokenName (COUNT(?output) as ?transfers)\n WHERE {\n ?block a b:Block ;\n b:hasTx ?tx .\n ?tx c:hasTxOutput ?output .\n ?output b:hasTokenState ?tokenState .\n ?tokenState b:hasCurrency ?token .\n ?token b:hasTokenName ?tokenName .\n }\n GROUP BY ?tokenName\n ORDER BY DESC(?transfers)\n LIMIT 10\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: What were the 10 largest ADA transactions in the last 24 hours?\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT ?txHash ?amount ?timestamp\n WHERE {\n ?block a b:Block ;\n b:hasTx ?tx ;\n b:hasTimestamp ?timestamp .\n BIND (NOW() - \"P1D\"^^xsd:dayTimeDuration as ?startDate)\n FILTER (?timestamp \u003e= ?startDate)\n ?tx c:hasTxOutput ?output ;\n b:hasTxID ?txHash .\n ?output b:hasTokenState ?tokenState .\n ?tokenState b:hasCurrency \u003chttps://mobr.ai/ont/cardano#cnt/ada\u003e ;\n b:hasValue ?amount .\n }\n ORDER BY DESC(?amount)\n LIMIT 10\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: What were the average transaction fees last week?\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT ?startDate ?endDate ?avgFee\n WHERE {\n BIND (NOW() AS ?endDate)\n BIND (NOW() - \"P7D\"^^xsd:dayTimeDuration AS ?startDate)\n {\n SELECT ((SUM(COALESCE(?fee, 0)) / COUNT(?tx)) AS ?avgFee)\n WHERE {\n ?block a b:Block ;\n b:hasTx ?tx ;\n b:hasTimestamp ?timestamp .\n BIND (NOW() - \"P7D\"^^xsd:dayTimeDuration AS ?startDate)\n FILTER (?timestamp \u003e= ?startDate)\n OPTIONAL { ?tx c:hasFee ?fee . }\n }\n }\n }\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: How many accounts hold over 200,000 ADA?\n "},{"role":"assistant","content":"\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n SELECT (COUNT(DISTINCT ?account) AS ?holders)\n WHERE {\n {\n SELECT ?account\n WHERE {\n ?account c:hasAccountUTXO ?utxo .\n FILTER NOT EXISTS {\n ?utxo c:hasOutputSpendTimestamp ?spendTimestamp .\n }\n ?utxo b:hasTokenState ?tokenState .\n ?tokenState b:hasCurrency \u003chttps://mobr.ai/ont/cardano#cnt/ada\u003e ;\n b:hasValue ?value .\n }\n GROUP BY ?account\n HAVING (SUM(?value) \u003e 200000000000)\n }\n }\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: What are the average staking rewards for accounts holding more than 1 million ADA?\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n SELECT (AVG(?latestRewardLovelace) AS ?avgLatestReward)\n WHERE {\n {\n # Per-account: sum reward values found in the block(s) matching the max timestamp for that account\n SELECT ?account (SUM(?rewardLovelace) AS ?latestRewardLovelace)\n WHERE {\n # --- same account filter by unspent UTXOs \u003e 1,000,000 ADA ---\n {\n SELECT ?account\n WHERE {\n ?account a b:Account ;\n c:hasAccountUTXO ?utxo .\n FILTER NOT EXISTS { ?utxo c:hasOutputSpendTimestamp ?spendTimestamp }\n ?utxo b:hasTokenState ?tokenState .\n ?tokenState b:hasCurrency \u003chttps://mobr.ai/ont/cardano#cnt/ada\u003e ;\n b:hasValue ?amt .\n }\n GROUP BY ?account\n HAVING (SUM(?amt) \u003e 1000000000000)\n }\n # --- for each account, compute max block timestamp where a withdrawal for the account appears ---\n {\n SELECT ?account (MAX(?blockTs) AS ?maxBlockTs)\n WHERE {\n ?account b:hasAddress ?addr .\n ?addr c:hasRewardWithdrawal ?wd .\n ?tx c:hasRewardWithdrawal ?wd .\n ?block b:hasTx ?tx ;\n b:hasTimestamp ?blockTs .\n }\n GROUP BY ?account\n }\n # --- join back to the withdrawal(s) that occur in that max timestamp block(s) ---\n ?account b:hasAddress ?addr2 .\n ?addr2 c:hasRewardWithdrawal ?wd2 .\n ?tx2 c:hasRewardWithdrawal ?wd2 .\n ?block2 b:hasTx ?tx2 ;\n b:hasTimestamp ?blockTs2 .\n FILTER(?blockTs2 = ?maxBlockTs)\n ?wd2 c:hasRewardWithdrawTokenState ?timestamp_rw2 .\n ?timestamp_rw2 b:hasValue ?rewardLovelace .\n }\n GROUP BY ?account\n }\n }\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: Plot a bar chart showing monthly smart contract deployments in the last year\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT\n ?timePeriod\n (COUNT(DISTINCT ?script) AS ?deployments)\n WHERE {\n ?script a c:PlutusScript ;\n c:hasCreationTimestamp ?timestamp .\n # Extract YYYY and MM\n BIND(SUBSTR(STR(?timestamp), 1, 4) AS ?year)\n BIND(SUBSTR(STR(?timestamp), 6, 2) AS ?month)\n # Build MM.YYYY\n BIND(CONCAT(?year, \".\", ?month) AS ?timePeriod)\n BIND(NOW() - \"P365D\"^^xsd:dayTimeDuration AS ?startDate)\n FILTER (?timestamp \u003e= ?startDate)\n }\n GROUP BY ?timePeriod\n ORDER BY ?timePeriod\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: List the number of NFTs minted in the last month\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT (COUNT(DISTINCT ?asset) as ?nftCount)\n WHERE {\n ?asset a b:NFT ;\n c:hasCreationTimestamp ?timestamp .\n BIND (NOW() - \"P30D\"^^xsd:dayTimeDuration as ?startDate)\n FILTER (?timestamp \u003e= ?startDate)\n }\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: Which tokens were the most frequently transferred in the last week\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT ?tokenName (COUNT(?output) as ?transfers) ?startDate\n WHERE {\n ?block a b:Block ;\n b:hasTimestamp ?timestamp .\n BIND(NOW() - \"P7D\"^^xsd:dayTimeDuration AS ?startDate)\n FILTER (?timestamp \u003e= ?startDate)\n ?block b:hasTx ?tx .\n ?tx c:hasTxOutput ?output .\n ?output b:hasTokenState ?tokenState .\n ?tokenState b:hasCurrency ?token .\n ?token b:hasTokenName ?tokenName .\n }\n GROUP BY ?tokenName ?startDate\n ORDER BY DESC(?transfers)\n LIMIT 10\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: How many new accounts were created daily over the last month\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT ?date (COUNT(DISTINCT ?account) AS ?new_accounts)\n WHERE {\n BIND(NOW() - \"P30D\"^^xsd:dayTimeDuration AS ?startDate)\n ?account a b:Account ;\n c:hasCreationTimestamp ?timestamp .\n BIND(xsd:date(?timestamp) AS ?date)\n FILTER (?date \u003e= ?startDate)\n }\n GROUP BY ?date\n ORDER BY ?date\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: What percentage of delegated ADA is to the top 10 stake pools\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n SELECT\n (SUM(?top10_stake) AS ?total_top10_stake)\n (SUM(?all_stake) AS ?total_delegated_stake)\n ((SUM(?top10_stake) / SUM(?all_stake) * 100) AS ?percentage_top10)\n WHERE {\n {\n # Get all current delegations with account balances\n SELECT ?pool ?account (SUM(?lovelace) AS ?account_balance)\n WHERE {\n # Find delegations\n ?delegation a c:Delegation ;\n c:hasDelegator ?account ;\n c:hasDelegatee ?pool ;\n c:hasDelegationTimestamp ?delegationTime .\n # Get the credential from the account\n ?account c:hasScriptCredential ?credential .\n # Ensure no later delegation exists for this account\n FILTER NOT EXISTS {\n ?laterDelegation a c:Delegation ;\n c:hasDelegator ?account ;\n c:hasDelegationTimestamp ?laterTime .\n FILTER (?laterTime \u003e ?delegationTime)\n }\n # Ensure the credential is not deregistered after this delegation\n # Check for any certificate that deregisters this credential\n FILTER NOT EXISTS {\n ?deregCert c:certToAccount ?account ;\n c:hasCredential ?credential .\n # This would be a deregistration certificate type\n # (specific type depends on schema - might need adjustment)\n FILTER NOT EXISTS {\n ?deregCert a c:Delegation .\n }\n }\n # Get account UTXOs (unspent outputs only)\n ?account c:hasAccountUTXO ?output .\n # Critical: Output must NOT be spent\n FILTER NOT EXISTS {\n ?output c:hasOutputSpendTimestamp ?spendTimestamp\n }\n # Get ADA balance from unspent UTXOs\n ?output b:hasTokenState ?tokenState .\n ?tokenState b:hasCurrency \u003chttps://mobr.ai/ont/cardano#cnt/ada\u003e ;\n b:hasValue ?lovelace .\n }\n GROUP BY ?pool ?account\n }\n # Calculate total stake per pool\n {\n SELECT ?pool (SUM(?account_balance) AS ?pool_stake)\n WHERE {\n {\n SELECT ?pool ?account (SUM(?lovelace) AS ?account_balance)\n WHERE {\n ?delegation a c:Delegation ;\n c:hasDelegator ?account ;\n c:hasDelegatee ?pool ;\n c:hasDelegationTimestamp ?delegationTime .\n ?account c:hasScriptCredential ?credential .\n FILTER NOT EXISTS {\n ?laterDelegation a c:Delegation ;\n c:hasDelegator ?account ;\n c:hasDelegationTimestamp ?laterTime .\n FILTER (?laterTime \u003e ?delegationTime)\n }\n FILTER NOT EXISTS {\n ?deregCert c:certToAccount ?account ;\n c:hasCredential ?credential .\n FILTER NOT EXISTS {\n ?deregCert a c:Delegation .\n }\n }\n ?account c:hasAccountUTXO ?output .\n # Only unspent outputs\n FILTER NOT EXISTS {\n ?output c:hasOutputSpendTimestamp ?spendTimestamp\n }\n ?output b:hasTokenState ?tokenState .\n ?tokenState b:hasCurrency \u003chttps://mobr.ai/ont/cardano#cnt/ada\u003e ;\n b:hasValue ?lovelace .\n }\n GROUP BY ?pool ?account\n }\n }\n GROUP BY ?pool\n ORDER BY DESC(?pool_stake)\n LIMIT 10\n }\n BIND(?pool_stake AS ?top10_stake)\n # Get total delegated stake (all pools)\n {\n SELECT (SUM(?account_balance) AS ?all_stake)\n WHERE {\n {\n SELECT ?account (SUM(?lovelace) AS ?account_balance)\n WHERE {\n ?delegation a c:Delegation ;\n c:hasDelegator ?account ;\n c:hasDelegationTimestamp ?delegationTime .\n ?account c:hasScriptCredential ?credential .\n FILTER NOT EXISTS {\n ?laterDelegation a c:Delegation ;\n c:hasDelegator ?account ;\n c:hasDelegationTimestamp ?laterTime .\n FILTER (?laterTime \u003e ?delegationTime)\n }\n FILTER NOT EXISTS {\n ?deregCert c:certToAccount ?account ;\n c:hasCredential ?credential .\n FILTER NOT EXISTS {\n ?deregCert a c:Delegation .\n }\n }\n ?account c:hasAccountUTXO ?output .\n FILTER NOT EXISTS {\n ?output c:hasOutputSpendTimestamp ?spendTimestamp\n }\n ?output b:hasTokenState ?tokenState .\n ?tokenState b:hasCurrency \u003chttps://mobr.ai/ont/cardano#cnt/ada\u003e ;\n b:hasValue ?lovelace .\n }\n GROUP BY ?account\n }\n }\n }\n }\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: How many accounts voted on the latest governance proposal\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n SELECT\n ?proposalTxHash\n ?proposalUrl\n (COUNT(?vote) AS ?voteCount)\n (SUM(?isYes) AS ?yesCount)\n (SUM(?isNo) AS ?noCount)\n (SUM(?isAbstain) AS ?abstainCount)\n ?proposalTimestamp\n WHERE {\n {\n SELECT ?latestProposal ?proposalTimestamp ?proposalTxHash ?eUrl\n WHERE {\n ?latestProposal a c:GovernanceProposal .\n ?tx c:hasGovernanceProposal ?latestProposal ;\n b:hasTxID ?proposalTxHash .\n ?block b:hasTx ?tx ;\n b:hasTimestamp ?proposalTimestamp .\n BIND(CONCAT(\"https://cardanoscan.io/transaction/\", STR(?proposalTxHash)) AS ?eUrl)\n }\n ORDER BY DESC(?proposalTimestamp)\n LIMIT 1\n }\n ?vote a c:Vote ;\n c:votesOn ?latestProposal ;\n c:hasVoterId ?voter ;\n c:hasVotingResult ?voteValue .\n BIND(IF(LCASE(STR(?voteValue)) = \"yes\", 1, 0) AS ?isYes)\n BIND(IF(LCASE(STR(?voteValue)) = \"no\", 1, 0) AS ?isNo)\n BIND(IF(LCASE(STR(?voteValue)) = \"abstain\", 1, 0) AS ?isAbstain)\n OPTIONAL {\n ?latestProposal c:hasProposalMetadata ?metadata .\n ?metadata c:hasUrl ?url .\n }\n BIND(COALESCE(?url, ?eUrl) AS ?proposalUrl)\n }\n GROUP BY ?proposalTxHash ?proposalUrl ?proposalTimestamp\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: What day was one week ago?\n "},{"role":"assistant","content":"\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT (xsd:date(?startDate) as ?date)\n WHERE {\n BIND (NOW() - \"P7D\"^^xsd:dayTimeDuration as ?startDate)\n }\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: What month was two months ago?\n "},{"role":"assistant","content":"\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT (month(?startDate) as ?month)\n WHERE {\n BIND (NOW() - \"P60D\"^^xsd:dayTimeDuration as ?startDate)\n }\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: What year was two years ago?\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT (year(?startDate) as ?year)\n WHERE {\n BIND (NOW() - \"P730D\"^^xsd:dayTimeDuration as ?startDate)\n }\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: How many blocks cardano up to March 14, 2021?\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT (COUNT(DISTINCT ?block) AS ?countBlock)\n WHERE {\n ?block a b:Block ;\n b:hasTimestamp ?timestamp .\n BIND (\"2021-03-14T23:59:59Z\"^^xsd:dateTime as ?someDate)\n FILTER (?timestamp \u003c= ?someDate)\n }\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: How many transactions up to March 15, 2021?\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT (SUM(?txCount) AS ?totalTxs)\n WHERE {\n ?block a b:Block ;\n b:hasTimestamp ?timestamp ;\n b:hasTxCount ?txCount .\n BIND (\"2021-03-15T23:59:59Z\"^^xsd:dateTime as ?someDate)\n FILTER (?timestamp \u003c= ?someDate)\n }\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: How many blocks did Cardano process on 03.14.2021?\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT (COUNT(DISTINCT ?block) AS ?countBlock)\n WHERE {\n ?block a b:Block ;\n b:hasTimestamp ?timestamp .\n BIND (\"2021-03-14T00:00:00Z\"^^xsd:dateTime AS ?startDate)\n BIND (\"2021-03-14T23:59:59Z\"^^xsd:dateTime AS ?endDate)\n FILTER (?timestamp \u003e= ?startDate \u0026\u0026 ?timestamp \u003c= ?endDate)\n }\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: How many transactions did Cardano process on 15.04.2021?\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT (SUM(?txCount) AS ?totalTxs)\n WHERE {\n ?block a b:Block ;\n b:hasTimestamp ?timestamp ;\n b:hasTxCount ?txCount .\n BIND (\"2021-04-15T00:00:00Z\"^^xsd:dateTime AS ?startDate)\n BIND (\"2021-04-15T23:59:59Z\"^^xsd:dateTime AS ?endDate)\n FILTER (?timestamp \u003e= ?startDate \u0026\u0026 ?timestamp \u003c= ?endDate)\n }\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: What is the average of transactions per block on March 2021?\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT\n (COUNT(DISTINCT ?block) AS ?totalBlocks)\n (COUNT(?transaction) AS ?txCount)\n (?totalTransactions / ?totalBlocks AS ?avgTransactionsPerBlock)\n WHERE {\n ?block a b:Block ;\n b:hasTimestamp ?timestamp ;\n b:hasTx ?transaction .\n BIND (\"2021-03-01T00:00:00Z\"^^xsd:dateTime AS ?startDate)\n BIND (\"2021-03-31T23:59:59Z\"^^xsd:dateTime AS ?endDate)\n FILTER (?timestamp \u003e= ?startDate \u0026\u0026 ?timestamp \u003c= ?endDate)\n }\n GROUP BY ?totalTransactions\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: how much ada in the account that holds more ada on February 13, 2021?\n "},{"role":"assistant","content":"\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT ?account (SUM(xsd:decimal(?value)) AS ?balance)\n WHERE {\n ?block a b:Block ;\n b:hasTimestamp ?timestamp ;\n b:hasTx ?tx .\n FILTER(?timestamp \u003c= \"2021-02-13T23:59:59Z\"^^xsd:dateTime)\n ?tx c:hasTxOutput ?output .\n ?account c:hasAccountUTXO ?output .\n # Keep only unspent outputs\n FILTER NOT EXISTS { ?output c:hasOutputSpendTimestamp ?spendTimestamp . }\n ?output b:hasTokenState ?tokenState .\n ?tokenState b:hasCurrency \u003chttps://mobr.ai/ont/cardano#cnt/ada\u003e ;\n b:hasValue ?value .\n }\n GROUP BY ?account\n ORDER BY DESC(?balance)\n LIMIT 1\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: Show me the 5 blocks with the largest number of transactions on March 2021\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT ?block_hash ?block_number ?timestamp ?number_of_transactions\n WHERE {\n ?block b:hasTxCount ?number_of_transactions ;\n c:hasBlockNumber ?block_number ;\n b:hasHash ?block_hash ;\n b:hasTimestamp ?timestamp .\n BIND (\"2021-03-01T00:00:00Z\"^^xsd:dateTime AS ?startDate)\n BIND (\"2021-03-31T23:59:59Z\"^^xsd:dateTime AS ?endDate)\n FILTER (?timestamp \u003e= ?startDate \u0026\u0026 ?timestamp \u003c= ?endDate)\n }\n ORDER BY DESC(?number_of_transactions)\n LIMIT 5\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: Show me the 3 blocks with the largest number of outputs on April 18, 2021\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT\n ?block_hash\n ?block_number\n ?timestamp\n ?number_of_transactions\n (SUM(COALESCE(?outputsCount, 0)) AS ?sumOutputs)\n WHERE {\n ?block b:hasTxCount ?number_of_transactions ;\n c:hasBlockNumber ?block_number ;\n b:hasHash ?block_hash ;\n b:hasTimestamp ?timestamp ;\n b:hasTx ?tx .\n OPTIONAL { ?tx c:hasTxOutputCount ?outputsCount . }\n BIND (\"2021-04-18T00:00:00Z\"^^xsd:dateTime AS ?startDate)\n BIND (\"2021-04-18T23:59:59Z\"^^xsd:dateTime AS ?endDate)\n FILTER (?timestamp \u003e= ?startDate \u0026\u0026 ?timestamp \u003c= ?endDate)\n }\n GROUP BY ?block_hash ?block_number ?timestamp ?number_of_transactions\n ORDER BY DESC(?sumOutputs)\n LIMIT 3\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: Show me the latest 5 blocks\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n SELECT ?blockNumber ?slotNumber ?epochNumber ?timestamp ?blockSize ?hash ?transactionCount\n WHERE {\n ?block a b:Block ;\n c:hasBlockNumber ?blockNumber ;\n c:hasSlotNumber ?slotNumber ;\n b:hasTimestamp ?timestamp ;\n c:hasBlockSize ?blockSize ;\n c:hasEpoch ?epoch ;\n b:hasHash ?hash .\n ?epoch c:hasEpochNumber ?epochNumber\n OPTIONAL { ?block b:hasTxCount ?transactionCount }\n }\n ORDER BY DESC(?blockNumber)\n LIMIT 5\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: Show me the latest epoch\n "},{"role":"assistant","content":"\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n SELECT ?epoch ?epochNumber (COUNT(?block) as ?blockCount) (COUNT(?tx) as ?txCount) (SUM(?totalTxOutput) as ?totalOutput) (SUM(?txFee) as ?totalFees) (SUM(?rewardAmount) as ?rewardsDistributed)\n WHERE {\n ?epoch a c:Epoch ;\n c:hasEpochNumber ?epochNumber .\n ?block c:hasEpoch ?epoch .\n OPTIONAL { ?block b:hasTx ?tx }\n OPTIONAL { ?tx c:hasTxOutputValue ?totalTxOutput }\n OPTIONAL { ?tx c:hasFee ?txFee }\n OPTIONAL {\n ?tx c:hasRewardWithdrawal ?reward .\n ?reward c:hasRewardWithdrawTokenState ?tokenState .\n ?tokenState b:hasValue ?rewardAmount .\n }\n BIND((?endTime - ?startTime) AS ?duration)\n }\n GROUP BY ?epoch ?epochNumber\n ORDER BY DESC(?epochNumber)\n LIMIT 1\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: List the top 10 stake pools by stake amount\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n SELECT ?poolId (SUM(?amount) as ?stakeAmount)\n WHERE {\n ?delegationSpec c:hasDelegatee ?pool ;\n c:hasDelegator ?account .\n ?pool b:hasHash ?poolId .\n }\n GROUP BY ?poolId\n ORDER BY DESC(?stakeAmount)\n LIMIT 10\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: What is the average of transactions per block in the last week?\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT\n (COUNT(DISTINCT ?block) AS ?totalBlocks)\n (COUNT(?transaction) AS ?txCount)\n (?totalTransactions / ?totalBlocks AS ?avgTransactionsPerBlock)\n WHERE {\n ?block a b:Block ;\n b:hasTimestamp ?timestamp ;\n b:hasTx ?transaction .\n BIND (NOW() - \"P7D\"^^xsd:dayTimeDuration as ?startDate)\n FILTER (?timestamp \u003e= ?startDate)\n }\n GROUP BY ?totalTransactions\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: What is the average of transactions per block?\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n SELECT (COUNT(DISTINCT ?block) AS ?totalBlocks) (SUM(?txCount) AS ?totalTransactions) (?totalTransactions / ?totalBlocks AS ?avgTransactionsPerBlock)\n WHERE {\n ?block a b:Block ;\n b:hasTxCount ?txCount .\n }\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: How much ADA the top 1% ADA holders have?\n "},{"role":"assistant","content":"\n \n ---split in multiple queries---\n ---query 1--- \n \n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n \n SELECT (COUNT(DISTINCT ?account) AS ?holders)\n WHERE {\n {\n SELECT ?account (SUM(xsd:decimal(?value)) AS ?balance)\n WHERE {\n FILTER NOT EXISTS { ?output c:hasOutputSpendTimestamp ?spendTimestamp . }\n ?account c:hasAccountUTXO ?output .\n ?output b:hasTokenState ?tokenState .\n ?tokenState b:hasCurrency \u003chttps://mobr.ai/ont/cardano#cnt/ada\u003e ;\n b:hasValue ?value .\n }\n GROUP BY ?account\n HAVING (?balance \u003e 0)\n }\n }\n ---query 2--- \n \n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n \n SELECT\n (SUM(?balance) AS ?topTotalBalance)\n (INJECT(evaluate(holders * 0.01)) AS ?numberOfTopHolders)\n WHERE {\n {\n SELECT ?account (SUM(xsd:decimal(?value)) AS ?balance)\n WHERE {\n FILTER NOT EXISTS {?output c:hasOutputSpendTimestamp ?spendTimestamp .}\n ?account c:hasAccountUTXO ?output .\n ?output b:hasTokenState ?tokenState .\n ?tokenState b:hasCurrency \u003chttps://mobr.ai/ont/cardano#cnt/ada\u003e ;\n b:hasValue ?value .\n }\n GROUP BY ?account\n ORDER BY DESC(?balance)\n LIMIT INJECT(evaluate(holders * 0.01))\n }\n }\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: How much the top 1% ADA holders represent from the total supply on the Cardano network?\n "},{"role":"assistant","content":"\n \n ---split in multiple queries---\n ---query 1--- \n \n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n \n SELECT (COUNT(DISTINCT ?account) AS ?holders)\n WHERE {\n {\n SELECT ?account (SUM(xsd:decimal(?value)) AS ?balance)\n WHERE {\n FILTER NOT EXISTS { ?output c:hasOutputSpendTimestamp ?spendTimestamp . }\n ?account c:hasAccountUTXO ?output .\n ?output b:hasTokenState ?tokenState .\n ?tokenState b:hasCurrency \u003chttps://mobr.ai/ont/cardano#cnt/ada\u003e ;\n b:hasValue ?value .\n }\n GROUP BY ?account\n HAVING (?balance \u003e 0)\n }\n }\n ---query 2--- \n \n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n \n SELECT\n (SUM(?balance) AS ?topTotalBalance)\n ((SUM(?balance) / ?totalSupply) AS ?supplyRepresentation)\n (INJECT(evaluate(holders * 0.01)) AS ?numberOfTopHolders)\n WHERE {\n {\n SELECT ?account (SUM(xsd:decimal(?value)) AS ?balance)\n WHERE {\n FILTER NOT EXISTS {?output c:hasOutputSpendTimestamp ?spendTimestamp .}\n ?account c:hasAccountUTXO ?output .\n ?output b:hasTokenState ?tokenState .\n ?tokenState b:hasCurrency \u003chttps://mobr.ai/ont/cardano#cnt/ada\u003e ;\n b:hasValue ?value .\n }\n GROUP BY ?account\n ORDER BY DESC(?balance)\n LIMIT INJECT(evaluate(holders * 0.01))\n }\n \u003chttps://mobr.ai/ont/cardano#cnt/ada\u003e b:hasTotalSupply ?totalSupply .\n }\n GROUP BY ?totalSupply\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: how much ada in the account that holds more ada?\n "},{"role":"assistant","content":"\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n SELECT (SUM(?value) AS ?balance)\n WHERE {\n FILTER NOT EXISTS {?output c:hasOutputSpendTimestamp ?spendTimestamp .}\n ?account c:hasAccountUTXO ?output .\n ?output b:hasTokenState ?tokenState .\n ?tokenState b:hasCurrency \u003chttps://mobr.ai/ont/cardano#cnt/ada\u003e ;\n b:hasValue ?value .\n }\n GROUP BY ?account\n ORDER BY DESC(?balance)\n LIMIT 1\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: Show me the 5 blocks with the largest number of transactions?\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n SELECT ?block_hash ?block_number ?timestamp ?number_of_transactions\n WHERE {\n ?block b:hasTxCount ?number_of_transactions ;\n c:hasBlockNumber ?block_number ;\n b:hasHash ?block_hash ;\n b:hasTimestamp ?timestamp .\n }\n ORDER BY DESC(?number_of_transactions)\n LIMIT 5\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: Show me the 3 blocks with the largest number of outputs\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n SELECT\n ?block_hash\n ?block_number\n ?timestamp\n ?number_of_transactions\n (SUM(COALESCE(?outputsCount, 0)) AS ?sumOutputs)\n WHERE {\n ?block b:hasTxCount ?number_of_transactions ;\n c:hasBlockNumber ?block_number ;\n b:hasHash ?block_hash ;\n b:hasTimestamp ?timestamp ;\n b:hasTx ?tx .\n OPTIONAL { ?tx c:hasTxOutputCount ?outputsCount . }\n }\n GROUP BY ?block_hash ?block_number ?timestamp ?number_of_transactions\n ORDER BY DESC(?sumOutputs)\n LIMIT 3\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: Show me the latest transaction\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n SELECT ?txHash ?blockHash ?blockNumber ?epoch ?slot (COALESCE(?fee, 0) AS ?txFee) (COALESCE(?outputsValue, 0) AS ?txOutputsValue)\n WHERE {\n ?transaction a b:Transaction ;\n b:hasTxID ?txHash ;\n c:hasAnchor ?block .\n ?block c:hasBlockNumber ?blockNumber ;\n b:hasHash ?blockHash ;\n c:hasSlotNumber ?slot ;\n c:hasEpoch ?epochObj .\n ?epochObj c:hasEpochNumber ?epoch .\n OPTIONAL { ?transaction c:hasTxOutputValue ?outputsValue }\n OPTIONAL { ?transaction c:hasFee ?fee }\n }\n ORDER BY DESC(?blockNumber)\n LIMIT 1\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: Show me the latest 5 transactions\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n SELECT ?txHash ?blockHash ?blockNumber ?epoch ?slot (COALESCE(?fee, 0) AS ?txFee) (COALESCE(?outputsValue, 0) AS ?txOutputsValue)\n WHERE {\n ?transaction a b:Transaction ;\n b:hasTxID ?txHash ;\n c:hasAnchor ?block .\n ?block c:hasBlockNumber ?blockNumber ;\n b:hasHash ?blockHash ;\n c:hasSlotNumber ?slot ;\n c:hasEpoch ?epochObj .\n ?epochObj c:hasEpochNumber ?epoch .\n OPTIONAL { ?transaction c:hasTxOutputValue ?outputsValue }\n OPTIONAL { ?transaction c:hasFee ?fee }\n }\n ORDER BY DESC(?blockNumber)\n LIMIT 5\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: Show me 5 transactions by value of outputs\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n SELECT ?txHash ?blockHash ?blockNumber ?epoch ?slot (COALESCE(?fee, 0) AS ?txFee) ?outputsValue\n WHERE {\n ?transaction a b:Transaction ;\n b:hasTxID ?txHash ;\n c:hasTxOutputValue ?outputsValue ;\n c:hasAnchor ?block .\n ?block c:hasBlockNumber ?blockNumber ;\n b:hasHash ?blockHash ;\n c:hasSlotNumber ?slot ;\n c:hasEpoch ?epochObj .\n ?epochObj c:hasEpochNumber ?epoch .\n OPTIONAL { ?transaction c:hasFee ?fee }\n }\n ORDER BY DESC(?outputsValue)\n LIMIT 5\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: Show me 5 transactions by outputs\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n SELECT ?txHash ?blockHash ?blockNumber ?epoch ?slot (COALESCE(?fee, 0) AS ?txFee) (COALESCE(?outputsValue, 0) AS ?txOutputsValue) ?outputsCount\n WHERE {\n ?transaction a b:Transaction ;\n b:hasTxID ?txHash ;\n c:hasAnchor ?block .\n ?block c:hasBlockNumber ?blockNumber ;\n b:hasHash ?blockHash ;\n c:hasSlotNumber ?slot ;\n c:hasEpoch ?epochObj .\n ?epochObj c:hasEpochNumber ?epoch .\n OPTIONAL { ?transaction c:hasTxOutputValue ?outputsValue }\n OPTIONAL { ?transaction c:hasFee ?fee }\n }\n ORDER BY DESC(?outputsCount)\n LIMIT 5\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: Show me 5 transactions by inputs count\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n SELECT ?txHash ?blockHash ?blockNumber ?epoch ?slot (COALESCE(?fee, 0) AS ?txFee) ?inputsCount (COALESCE(?outputsCount, 0) AS ?outputs)\n WHERE {\n ?transaction b:hasTxID ?txHash ;\n c:hasTxInputCount ?inputsCount .\n ?block c:hasBlockNumber ?blockNumber ;\n b:hasTx ?transaction ;\n b:hasHash ?blockHash ;\n c:hasSlotNumber ?slot ;\n c:hasEpoch ?epochObj .\n ?epochObj c:hasEpochNumber ?epoch .\n OPTIONAL { ?transaction c:hasFee ?fee . }\n OPTIONAL { ?transaction c:hasTxOutputCount ?outputsCount . }\n }\n ORDER BY DESC(?inputsCount)\n LIMIT 5\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: Show me 5 transactions by inputs\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT\n ?txHash\n ?blockHash\n ?blockNumber\n ?epoch\n ?slot\n (COALESCE(?fee, 0) AS ?txFee)\n ?inputsCount\n (COALESCE(?outputsCount, 0) AS ?outputs)\n WHERE {\n ?transaction a b:Transaction ;\n b:hasTxID ?txHash ;\n c:hasTxInputCount ?inputsCount ;\n c:hasAnchor ?block .\n ?block c:hasBlockNumber ?blockNumber ;\n b:hasHash ?blockHash ;\n c:hasSlotNumber ?slot ;\n c:hasEpoch ?epochObj .\n ?epochObj c:hasEpochNumber ?epoch .\n OPTIONAL { ?transaction c:hasFee ?fee }\n OPTIONAL { ?transaction c:hasTxOutputCount ?outputsCount . }\n }\n ORDER BY DESC(?inputsCount)\n LIMIT 5\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: Show 5 transactions by token transfer\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n SELECT ?txHash ?tokenName (COUNT(?output) as ?numberOfTransfers)\n WHERE {\n ?tx a b:Transaction ;\n b:hasTxID ?txHash ;\n c:hasTxOutput ?output .\n ?output b:hasTokenState ?tokenState .\n ?tokenState b:hasCurrency ?token .\n ?token b:hasTokenName ?tokenName .\n }\n GROUP BY ?txHash ?tokenName\n ORDER BY DESC(?numberOfTransfers)\n LIMIT 5\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: Show 5 transactions with largest volume of token transfer\n "},{"role":"assistant","content":"\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n SELECT ?txHash ?tokenName (SUM(?value) as ?volume)\n WHERE {\n ?tx a b:Transaction ;\n b:hasTxID ?txHash .\n ?tx c:hasTxOutput ?output .\n ?output b:hasTokenState ?tokenState .\n ?tokenState b:hasCurrency ?token ;\n b:hasValue ?value .\n ?token b:hasTokenName ?tokenName .\n FILTER NOT EXISTS { ?output c:hasOutputSpendTimestamp ?spendTimestamp . }\n }\n GROUP BY ?txHash ?tokenName\n ORDER BY DESC(?volume)\n LIMIT 5\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: What is the average transaction fee per epoch?\n "},{"role":"assistant","content":"\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT\n ?epochNumber\n (SUM(xsd:decimal(?fee)) AS ?totalFee)\n (COUNT(?tx) AS ?txCount)\n (SUM(xsd:decimal(?fee)) / xsd:decimal(COUNT(?tx)) AS ?avgFee)\n WHERE {\n ?block c:hasEpoch ?epoch ;\n b:hasTx ?tx .\n OPTIONAL {?tx c:hasFee ?fee .}\n ?epoch c:hasEpochNumber ?epochNumber .\n }\n GROUP BY ?epochNumber\n ORDER BY ?epochNumber\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: Plot a line chart showing the average transaction fee per epoch?\n "},{"role":"assistant","content":"\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT\n ?epochNumber\n (SUM(xsd:decimal(?fee)) AS ?totalFee)\n (COUNT(?tx) AS ?txCount)\n (SUM(xsd:decimal(?fee)) / xsd:decimal(COUNT(?tx)) AS ?avgFee)\n WHERE {\n ?block c:hasEpoch ?epoch ;\n b:hasTx ?tx .\n OPTIONAL {?tx c:hasFee ?fee .}\n ?epoch c:hasEpochNumber ?epochNumber .\n }\n GROUP BY ?epochNumber\n ORDER BY ?epochNumber\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: Which transactions had the highest fees in epoch 300?\n "},{"role":"assistant","content":"\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT ?txHash ?fee\n WHERE {\n ?epoch c:hasEpochNumber \"300\"^^xsd:decimal .\n ?block c:hasEpoch ?epoch ;\n b:hasTx ?tx .\n ?tx b:hasTxID ?txHash ;\n c:hasFee ?fee .\n }\n GROUP BY ?txHash ?fee\n ORDER BY DESC(?fee)\n LIMIT 5\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: What is the distribution of transaction count over time?\n "},{"role":"assistant","content":"\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n SELECT ?epochNumber (SUM(?txCount) AS ?epochTxCount)\n WHERE {\n ?block c:hasEpoch ?epoch ;\n b:hasTxCount ?txCount .\n ?epoch c:hasEpochNumber ?epochNumber .\n }\n GROUP BY ?epochNumber\n ORDER BY ?epochNumber\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: How many transactions include metadata?\n "},{"role":"assistant","content":"\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n SELECT (COUNT(?tx) AS ?txWithMetadata)\n WHERE {\n ?tx c:hasTxMetadataCount ?countMetadata .\n FILTER (?countMetadata \u003e 0)\n }\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: What's the average number of inputs and outputs per transaction?\n "},{"role":"assistant","content":"\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT\n ?txCount\n (?sumInputs / ?txCount AS ?avgInputsPerTx)\n (?sumOutputs / ?txCount AS ?avgOutputsPerTx)\n WHERE {\n {\n SELECT\n (COUNT(?tx) AS ?txCount)\n (SUM(COALESCE(?inputsCount, 0)) AS ?sumInputs)\n (SUM(COALESCE(?outputsCount, 0)) AS ?sumOutputs)\n WHERE {\n ?tx a b:Transaction .\n OPTIONAL { ?tx c:hasTxInputCount ?inputsCount . }\n OPTIONAL { ?tx c:hasTxOutputCount ?outputsCount . }\n }\n }\n }\n "},{"role":"user","content":"\n You are a SPARQL query generator for the cardano blockchain domain.\n You output ONLY a valid SPARQL query aligned with cardano ontology, and nothing else.\n Never include explanations, text, comments, or markdown formatting.\n Do not answer in natural language under any circumstance.\n \n User Question: Show latest transaction json\n "},{"role":"assistant","content":"\n PREFIX c: \u003chttps://mobr.ai/ont/cardano#\u003e\n PREFIX b: \u003chttps://mobr.ai/ont/blockchain#\u003e\n PREFIX xsd: \u003chttp://www.w3.org/2001/XMLSchema#\u003e\n SELECT\n ?txHash\n ?json\n WHERE {\n ?block c:hasBlockNumber ?blockNumber ;\n b:hasTx ?tx .\n ?tx b:hasTxID ?txHash ;\n c:hasTxMetadata ?metadata .\n ?metadata c:hasMetadataJSON ?json .\n }\n ORDER BY DESC(?blockNumber)\n LIMIT 1\n "},{"role":"user","content":"\n You