This is the mascaret at the port of Saint-Pardon de Vayres, near the city of Bordeaux, a tidal bore that produces waves for 15 minutes of continuous surfing. One second the river is completely quiet, the next the waves break in, taking dozens of surfers with them.
A close up from the boards:
Some aerial shots that show the effect in full: