Total historic volume (for scorecard)

[gipsh]

Scorecard needs to show the historic volume AKA amount of money in USD moved by the bridge.

How we calculate the total volume using vaa metric

• Create a new bucket called vaa_volume_count

• Create a task to calculate the total volume (amount * notional) like this

option task = {name: "summarize-volume", every: 5m}

from(bucket: "wormhole")
    |> range(start: -task.every)
    |> filter(fn: (r) => r["_measurement"] == "vaa")
    |> filter(fn: (r) => r["token"] != "none")
    |> filter(fn: (r) => r["_field"] == "amount")
    |> drop(
        columns: [
            "origin_chain",
            "target_chain",
            "origin_address",
            "target_address",
            "token",
        ],
    )
    |> sum(column: "_value")
    |> yield(name: "sumamount")
    |> to(bucket: "vaa_volume_count", timeColumn: "_stop")

• Figure out how to summarize the new calculated data with the one already stored in the bucket. incrementalSum().
  or regenerate the bucket data with the sum of the 2 values.

• For backfilling run the flux query with start:-900d and wait until the data is ready.