stocks.py

from datetime import datetime, timedelta
from sqlalchemy import Column, DateTime, Integer, MetaData, Numeric, Table, select

meta = MetaData()


def stock_table(company):
    return Table(
        'stock_{}'.format(company),
        meta,
        Column('id', Integer),
        Column('volume', Integer),
        Column('price', Numeric),
        Column('date', DateTime)
    )


aapl = stock_table('aapl')
engine.execute(
    select(['*'])
        .select_from(aapl)
        .where(aapl.c.date >= datetime.now() - timedelta(days=7))
)