grid postgis query

query.sql

WITH

hgrid AS (
  SELECT CDB_HexagonGrid(
    ST_Transform(ST_MakeEnvelope(-180, -89, 180, 89, 4326), 3857), -- extent of the grid
    CDB_XYZ_Resolution({z}) * 15 -- size of each cell
  ) as cell
) 

SELECT count(i.<%=prop%>) as points_count 
FROM hgrid, <%= table_name %> i 
where ST_Intersects(i.the_geom_webmercator, hgrid.cell) GROUP BY hgrid.cell;