Postgres database: Merge two tables using composite key constraints and Insert statement in what is know as an UPSERT

INSERT.sql

INSERT INTO bucket(
    market_id,
    timeframe_id,
    time_close,
    price_open,
    price_high,
    price_low,
    price_close,
    volume)
    SELECT
        market_id,
        timeframe_id,
        time_close,
        price_open,
        price_high,
        price_low,
        price_close,
        volume
        FROM bucket_temp
            ON CONFLICT (market_id, timeframe_id, time_close) DO NOTHING;