Responsive Range Plot¶

%matplotlib inline
from verticapy.datasets import load_amazon
amazon = load_amazon()
amazon.search("YEAR(date) = 1999").hchart(x = "date", 
                                          y = ["AVG(number)", "MIN(number)", "MAX(number)"], 
                                          kind = "area_range")

%load_ext verticapy.hchart

%%hchart -type area_range
SELECT 
    date,
    AVG(number),
    MIN(number),
    MAX(number)
FROM amazon WHERE YEAR(date) = 1999 GROUP BY 1;