hts/internal/tinybird/pipes/count_verifications_daily.pipe

NODE count_daily
DESCRIPTION >
    undefined

SQL >

    SELECT countState() as verifications, toStartOfDay(fromUnixTimestamp64Milli(time)) as time FROM key_verifications group by time