Searching a trillion rows

Here are some sample queries for exploring BGP data

count by Peer_IP address for Dec 1st 2019

SELECT Peer_IP, count() 
FROM sample.bgp 
WHERE (timestamp BETWEEN '2019-12-01 00:00:00' AND '2019-12-02 00:00:00') GROUP BY Peer_IP;

count by Peer_ASN for Dec 1st 2019

SELECT Peer_ASN, count() 
FROM sample.bgp 
WHERE (timestamp BETWEEN '2019-12-01 00:00:00' AND '2019-12-02 00:00:00') GROUP BY Peer_ASN;