Group by Date (UNIX Timestamp)

[Kidbooo]

Hello everyone,,
Here's my problem:

Table
- id (int)
- value1 (varchar)
- value2 (varchar)
- value3 (varchar)
- date (int) [unix timestamp]

I need 3 different outputs:

Value1-3 of the
- last 30 days
- last 30 Weeks
- Last 30 Months Spending

the last 30 days [color=#333333]xvideos.onl/[/color] [color=#333333]xnxx.onl/[/color] [color=#333333]chaturbate.onl/[/color] is not a problem, but in the last 30 weeks you have to add the values of the 7 days of the week.

How do I do that? So BETWEEN is clear to me, but I have not a clue how to add for a week (no more, not less).

Ex:
Days: 1, 2, 3, 4, 5, 6, 7 | 1, 2, 1, 2, 1, 2, 3 | ...
Weeks: 28 | 12 | ...
months: 40 | ...

ask for help, thank you!