Top 20 Ethereum DEX Trades by USD Amount in a Date Range (Time and Amount Only)

{
  "type": "object",
  "required": [
    "source",
    "fields",
    "filters",
    "sort",
    "limit"
  ],
  "properties": {
    "sort": {
      "enum": [
        [
          {
            "field": "amount_usd",
            "order": "desc"
          }
        ]
      ],
      "type": "array",
      "items": {
        "type": "object",
        "properties": {
          "field": {
            "type": "string"
          },
          "order": {
            "type": "string"
          }
        },
        "additionalProperties": false
      },
      "description": "The ranking; only `[{\"field\": \"amount_usd\", \"order\": \"desc\"}]` (largest USD amount first) is offered."
    },
    "limit": {
      "enum": [
        20
      ],
      "type": "integer",
      "default": 20,
      "description": "How many rows to return; only 20, the one tested, is offered."
    },
    "fields": {
      "enum": [
        [
          "block_time",
          "amount_usd"
        ]
      ],
      "type": "array",
      "items": {
        "type": "string"
      },
      "description": "The columns returned; only `[\"block_time\", \"amount_usd\"]` (block time and USD amount) is offered."
    },
    "offset": {
      "enum": [
        0
      ],
      "type": "integer",
      "default": 0,
      "description": "Rows to skip; only 0 (start from the largest row) is offered."
    },
    "source": {
      "enum": [
        "agent.ethereum_dex_trades"
      ],
      "type": "string",
      "description": "The table queried; only `agent.ethereum_dex_trades` (Ethereum DEX trades) is offered."
    },
    "filters": {
      "type": "array",
      "items": {
        "type": "object",
        "required": [
          "field",
          "op",
          "value"
        ],
        "properties": {
          "op": {
            "enum": [
              "gte",
              "lte"
            ],
            "type": "string",
            "description": "`gte` for the first day of the range, `lte` for the last."
          },
          "field": {
            "enum": [
              "block_date"
            ],
            "type": "string",
            "description": "Only `block_date`, the trade's UTC day, is offered."
          },
          "value": {
            "type": "string",
            "pattern": "^\\d{4}-\\d{2}-\\d{2}$",
            "description": "The day, as YYYY-MM-DD."
          }
        },
        "additionalProperties": false
      },
      "maxItems": 2,
      "minItems": 2,
      "description": "The date range, as exactly two conditions on the trade's block date: one with `op` `gte` (the first day, inclusive) and one with `op` `lte` (the last day, inclusive)."
    }
  },
  "additionalProperties": false
}

{
  "type": "object",
  "properties": {
    "data": {
      "type": "array",
      "items": {
        "type": "object",
        "properties": {
          "amount_usd": {
            "type": "number",
            "description": "The trade row's value in USD."
          },
          "block_time": {
            "type": "number",
            "description": "When the trade's block was produced, in Unix seconds (UTC)."
          }
        }
      },
      "description": "Up to 20 trade rows, largest USD amount first."
    }
  },
  "description": "The largest DEX trade rows in the range."
}