How to "transpose" date data into columns in SQL?

I have a table with (id, name, creation_timestamp)

I want to write a query that gives:

name, 2019-09-15, 2019-09-16, ... , 2019-10-15

Columns date are for the last 30 days.

In each column there will be the count of records per name that matches the date.

I know how to create this as rows

select  name
        ,cast ( creation_timestamp as DATE)
        ,count(1)
from my_bale 
group by name, cast ( creation_timestamp as DATE)

But this gives me 3 columns and the dates are listed in the 2nd columns. How can I convert this to the required output?

Lets say that my table has

id, name , creation_timestamp
1    A     2019-10-10 21:52:22.904  
2   A     2019-10-10 22:52:22.904   
3   B    2019-10-10 21:52:22.904    
3    C  2019-10-11 21:52:22.904 

Output should be:

name, 2019-09-15, 2019-09-16, ... , 2019-10-10, 2019-10-11, ..., 2019-10-15
 A     0             0                 2           0                0
 B     0             0                 1           0                0
 C     0             0                 0           1                0

Similar to the question sql date range in column and count by group but it didn't get any answer

I'm using Presto but a native SQL solution is great