Nate nathan-castor

## index.html
<h4>Enter your email</h4>
<input />
<div style='color:red'></div>

## accnt_status_hist.ipynb

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                nathan-castor
                / accnt_status_hist.ipynb
            
            
              Last active
              July 12, 2018 05:47
            
          
      Loading

      Sorry, something went wrong. Reload?
      Sorry, we cannot display this file.
      Sorry, this file is invalid so it cannot be displayed.
      
          Viewer requires iframe.
      
    
## generate_series.sql

-- Generate a series of months! (join with other time series to get 0 values):
-- { ----
SELECT * FROM generate_series('2010-01-01'::date, '2011-01-01', '1 months')

select distinct date_trunc('month', (current_date - offs)) as date
from generate_series(0,365,28) as offs
order by 1 desc

select distinct date_trunc('day', (current_date - offs)) as date

## get_all_last_day.sql

SELECT
  *
FROM
  reports_account_snapshot
WHERE
  event_date IN (
    SELECT   MAX(event_date)
    FROM     reports_account_snapshot
    GROUP BY date_trunc('month',event_date), date_trunc('year',event_date)

## update_metabase.txt
git commit --allow-empty -m "empty commit"
git push -f heroku master

## 0_reuse_code.js
// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console
	<h4>Enter your email</h4>
	<input />
	<div style='color:red'></div>

	-- Generate a series of months! (join with other time series to get 0 values):
	-- { ----
	SELECT * FROM generate_series('2010-01-01'::date, '2011-01-01', '1 months')

	select distinct date_trunc('month', (current_date - offs)) as date
	from generate_series(0,365,28) as offs
	order by 1 desc

	select distinct date_trunc('day', (current_date - offs)) as date

	SELECT
	*
	FROM
	reports_account_snapshot
	WHERE
	event_date IN (
	SELECT MAX(event_date)
	FROM reports_account_snapshot
	GROUP BY date_trunc('month',event_date), date_trunc('year',event_date)
	git commit --allow-empty -m "empty commit"
	git push -f heroku master
	// Use Gists to store code you would like to remember later on
	console.log(window); // log the "window" object to the console