-- this script made the chart
-- more about Entrance at http://dbentrance.com/

plot datetimeychart
  x, red dropline
  with
    title "Haiti Aftershocks"
    title y magnitude
    title x UTC
    note " "     -- so x title isn't cut off
    labelangle 0
    scale  x '2010-1-12 18:00:00' '2010-1-13 24:00:00' 6 hours
    format x  '%d %Hh'
    scale  y  0 9 1
    
    gridlines
select 
  dt, magnitude from earthquakes
  where lon > -77.344 and lon < -69.961
    and lat > 15.117 and lat < 22.148;