lichess_eval_games

spec.json

{
    "$schema": "https://vega.github.io/schema/vega-lite/v5.json",
    "width": 600,
    "height": 400,
    "data": {
        "url": "https://api.tinybird.co/v0/sql?q=SELECT%20toStartOfDay(date)%2Ccount(*)%20FROM%20lichess_2020_eval_games%20group%20by%20toStartOfDay(date)%20order%20by%20toStartOfDay(date)%20desc%20%0A%20FORMAT%20CSVWithNames&token=p.eyJ1IjogIjNjYTZlNjZkLTBkZmItNGU4MS1hYWYyLWE5Y2QyMTA2NzVjNiIsICJpZCI6ICIxMTcwMzJiNS03N2Q1LTQ3NjEtODVhYy1lZTVkMWJiYzYyOTIifQ.dp6TJBEfgh-I_BS7DSxxTd-icd1Oyam4hg3yTXAde7w&pipeline=rango_temporal_datos_1563_copy",
        "format": {
            "type": "csv",
            "parse": {
                "count()": "number"
            }
        }
    },
    "mark": "bar",
    "encoding": {
        "x": {
            "field": "toStartOfDay(date)",
            "type": "temporal",
            "title": "day"
        },
        "y": {"aggregate": "sum", "field": "count()", "title": "count"},
        
        "tooltip": [
            {
                "field": "toStartOfDay(date)",
                "type": "temporal",
                "title": "day",
                "timeUnit": "utcyearmonthdatehoursminutes"
            },
            {
                "field": "count()",
                "title": "count",
                "type": "quantitative"
            }
        ]
    }
}