Ad
  • Custom User Avatar

    Can you explain this part of the query?
    from generate_series((select date_trunc('day',min(createdAt)) from market_data),
    (select date_trunc('day',min(createdAt)) from market_data)+'1 day',
    'PT00:05:00') as gs(date)
    Why did you use a table called generate_series.
    I liked your solution the most, so I would be happy to understand it and learn from it